Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A

Abhilash K - Deloitte USI

Check if Gaurav's response helps you. It is an add-on for us at the time. Its shows both BI and OTBI as far as I recall.

Take a look at this

Main Document : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-audit-data-publisher-catalog-objects.html#GUID-6E05FC42-D2CF-4658-B9A1-595968CC8FA6

Download Sample Audit Reports with table and query details here : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-publisher-audit-data.html#GUID-5DF09423-C313-4B03-9F6E-BC414B9895E9

Mak Sahil-Oracle

Hi Abhilash,
Do you know the table which can help in getting the name of the column that was updated.

Abhilash K - Deloitte USI

Hi Mak,

I am not aware of that.

Sulakshna Kancherla

Hi We are looking for similar audit table data and I cannot view this link mentioned above. Can some one please provide updated link

Main Document : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-audit-data-publisher-catalog-objects.html#GUID-6E05FC42-D2CF-4658-B9A1-595968CC8FA6

Bala Murali SV8

Hi,

Please let me know if anyone able to find the tables behind the following page. The information provided by standard oracle audit reports is not sufficient to us. So, we are exploring if there is any possibility how to know which column is updated in a particular table when audit is enabled.

Jayant Ajayrao Deshmukh

Looks helpful thanks for sharing

User_KGUF0

Hi Bala Murali SV8,

Have you got any resolution? I am also looking for the same audit report to build a query. the main document links aren't working for me.

So any inputs would be appreciated.

Thanks

S.A.A Dinoli

Hi Abilash @Abhilash K - Deloitte USI
Could you please provide a comprehensive list of all tables across all modules where data is stored?

SunilD

@Jazmin Saldierna were you able to get the table name which stores the movements in ERP Cloud?

Gaurav Bharadwaj-Oracle

@SunilD I would recommend moving this concern ie creating a new thread in this forum : https://community.oracle.com/products/oracleanalytics/categories/fusion-erp-analytics

At this point this looks like an ERP requirement than OTBI.

Thanks