Supplier Audit tables in oracle apps r12 : Audit Tables in Oracle apps r12

Supplier Audit tables in oracle apps r12 : Audit Tables in Oracle apps r12

In this post , We will be discuss about the auditing in Oracle apps r12. We will be talk about , when we do enable the audit trial in Oracle apps for suppliers then , which tables do stores these audit information's and if we want to build any report based on Supplier audit information we can use these tables and can track all the changes in the oracle apps supplier. Here below i will share those tables information's which stores supplier audit information's in oracle apps r12. 

4 Important Supplier Audit tables in oracle apps r12

1. For AP_SUPPLIERS Oracle has given the Audit Table 'AP_SUPPLIERS_A'

Supplier headers all changes stores in the AP_SUPPLIERS_A table for record.

2. For AP_SUPPLIER_SITES_ALL Oracle has given the Audit Table 'AP_SUPPLIER_SITES_ALL_A'

Supplier Site all changes do stores in this AP_SUPPLIER_SITES_ALL_A table.

These Following main views based on base table and Audit table.

AP_SUPPLIERS_AC1 for AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL_AC1 for AP_SUPPLIER_SITES_ALL

In Supplier Auditing setups , We have the option to select which columns in the suppliers tables we want to keep track or enable auditing as shown below too.

We can create the custom supplier Auditing reports based on these Supplier Audit tables and extract the information from the system as per our requirement. 

Supplier Audit tables in oracle apps r12 : Audit Tables in Oracle apps r12