• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 8, 2021
  • Reading time:2 mins read
You are currently viewing SQL Query to extract Business objects and attributes enabled for Auditing
SQL Query to extract Business objects and attributes enabled for Auditing

In this article, we will look into how to extract the business objects/attributes which are enabled for auditing.

If you don’t know how to enable auditing, please check out Enabling Audit for Business Objects in Fusion Applications

Once the Auditing is enabled, all the transactions that happen post that change will get tracked as part of auditing. We can query the underlying audit tables (core tables with _ at the end) to get details of what has actually changed.

However if there is a need to get the list of fields for which the auditing functionality has been turned on, then here is the savior.

SQL Query to fetch Auditing Business Objects/Attributes

select * from FND_AUDIT_ATTRIBUTES where CREATED_BY <> 'SETUP' and enabled_flag='Y';

Here is the output of the query from sample instance.

image 28 - SQL Query to extract Business objects and attributes enabled for Auditing

Hope this will be useful when you have to extract the business objects and attributes that are turned on for auditing.

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.