Oracle Transactional Business Intelligence

Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A
Summary:
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A
Content (required):
Which table in SaaS stores information for Audit Reports?
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A
Navigation
Tools - Reports & Analytics - Audit Reports
Version (include the version you are using, if applicable):
22A
Code Snippet (add any code snippets that support your topic, if applicable):
Best Answer
-
I got the audit tables for base tables. As per current analysis, it appears the audit occurs on the basis of audit policies set for the entity. the base table name with _ will be the audit table for the base table.
Answers
-
Can you be a bit specific which audit data you are looking for ?
Since you have created this thread under OTBI i would assume you are looking for BI related audit data ?
Take a look at this
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
-
Hi,
Can you please share the table names? Thanks
-
Sample table is for example : fa_additions_b , the audit table is fa_additions_b_
-
Thanks for sharing. Just for everyone's information I was specifically looking for the Audit Tables related to roles assignment at user level. Confirmed over SR that we do not have access to audit tables related to user role assignment. Alternatively OTBI subject area can be used to access that information (its Security Audit something.)