For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Great !
Thanks for the quick update.
Regards,
Madhu
Thank you so much for this document.
Appreciate if you can update this with 19D.
Hi Roop,
This is not specific to Conflicting Roles. Question is generic. As we have commonly used reports in other modules, sharing center.
I want to know if anyone using custom BIP/OTBI reports and any issues they are facing.
Thanks,
Madhu
Very useful !
Thanks.
We have similar request too but we didn't find any way.
Hope any expert here can comment.
Very Useful one.
Thanks!
2) If you want to access the report's output and show only User's Cost center. Then try below
Hi Abhishek,
Thanks Linda and Abdul. This is really useful.
Hi ,
You can enable the at the ESS Job definition level. Go to the specific job definition, click 'Show more' in the header. Then choose the Database Trace LOV.
But to access the Log generate you need to have a specific role(kind of Admin) , I'm not sure about it.
Thanks,
Madhu
Great Senthil!
Marks it as resolved. It will help others in future.
Thanks,
Madhu
Hi Manish,
I don't think that is possible but you can try.
Please refer below and screenshot
Creating a Data Set Using a Content Server as DataSource
Thanks,
Madhu
Hi Senthi,
We also had same issue and resolved after adding the required roles.
Oracle Support gave us the Data Security Policies required to have access.
1) Grant On GL Ledgers ::: Ledger for Table GL_LEDGERS Read;Update;Report Oracle Fusion General Ledger;View Accounting Period Status; Actions
2) Subledger Application :: Subledger Application Manage Subledger Application Data; Actions
3) Subledger Source Transaction :: Subledger Source Transaction Manage Subledger Source Transaction Data; Actions
4) Subledger Accounting Ledger :: Subledger Accounting Ledger Read;Manage Accounting Period Status;Report Oracle Fusion General Ledger;Manage Ledger for Subledger Data;View Accounting Period Status;Update; Actions
5) Grant on Business Unit :: Business Unit Review Receipt Accounting;Run Accounting Period Close Exceptions report;Create Payables Payment Request;Report Payables;Manage Supplier Negotiation as Procurement Agent;View Supplier
Refer below post :
https://cloudcustomerconnect.oracle.com/posts/784cc01212
Thanks,
Madhu
Hi ,
For incremental extract , you can create ESS job of type BIP.
In the BIP report datamodel query refer table ESS_REQUEST_HISTORY for the last run date. Then use this as reference ( like -poh.creation_date > last_run_date) in your main query to fetch latest/incremental data only.
Thanks,
Madhu
Hi Hari,
Mark this as resolved if you think it is.
Thanks,
Madhu