It is a type of template only where you can get csv/txt output format as per you need. Check below link: Creating eText Templates Thanks.

Hi Ivony, As CSV is a data format, so it is dependent upon the data model. As there is no template, you can't hide the ID columns. But if you don't need IDs, you can remove them from the select clause in data model or create an Etext template. Thanks.

Thanks for sharing the resolution with community. Appreciated !!

As per my knowledge, there is no direct way to extract that data from a single table. Please check similar thread: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A — Oracle Analytics Thanks.

Can you verify your source query? Are you pulling the correct data? If possible share the piece of code to get this url to verify. Thanks.

This will be a great enhancement. Currently, in our organization, we are replacing one the existing fields with a new one and we have to scan through all the reports one by one. If we can get to extract the SQL statements, it will definitely help a lot. Upvoted. Thanks.

Hi, If you are looking for an exact replica of audit information that you see from UI audit reports, that is difficult to get. Are you facing any challenges with seeded audit reports? You can however build your custom logic. For all objects where audit is available, a corresponding shadow table exists (with same name as…

Can you please confirm the exact details for what modules you need or your are looking for a specific object? Thanks.

Hi Francisco, This forum is specific to Oracle Analytics. For any specific queries to other products, please post it on cloud customer connect: General Ledger & Intercompany — Cloud Customer Connect Thanks.

Hi Vrinda, As per my understanding, you will not be able to get the number of times the approval was done. That history is not maintained. You can only get last appoval if the transaction is approved and current assignees if in progress. Thanks.

Thank you @Benjamin Arnulf-Oracle @Daniel C Mohan-Oracle @Farivar Javanbakhti-Oracle for this opportunity. I am grateful for your support throughout this journey. Your kind words mean a lot to me!!! Thanks to all my other community peers. This learning journey is not possible without the amazing community peers.

Thank you @Benjamin Arnulf-Oracle for putting this together. In addition, people should avoid posting duplicate posts on the forum. Thanks.

Can you check if below help? How To Compare Budget Versus Actual Balances? (Doc ID 2068897.1) How to create actual vs budget and variance report? — Cloud Customer Connect Sample Report: Project Financial Management Cloud: Project Budget vs. Actual — Cloud Customer Connect Thanks.

Hi @Rajat Agarwal , This looks like more of a question/query instead of an idea. Can you please post it under correct category? Thanks.

Have you followed step by step instructions link? You need to provide a customer CSI number also to be able to make full use of customer connect. if you still face an issue, please reach out to cloudconnect-help_ww@oracle.com. Thanks.

Check below blog on step by step instructions: Configuring OCI Object Storage access control policies Thanks.

If you are looking for a table for BIP data model, then check below thread: Query to get payment method field in Order Management in Oracle Fusion — Cloud Customer Connect Thanks.

Can you try below in your RTF file? <?If:PARAMETER_NAME = ''?>All<?end if?> to print All explicitly? Thanks.

Versioning of BIP and OTBI is one of the key requirements from audit perspective. Upvoted.

Did you check the learning assignment records table? Please check if below helps: Thanks.