R12: AP: After Supplier Site Data Is Changed, The Vendor_ID Value Does Not Populate In The AP_SUPPLIER_SITES_ALL Shadow Tables (Doc ID 2029379.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

The steps from Note 370874.1 were used to implement an audit trail on the tables AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL.

But in the AP_SUPPLIER_SITES_ALL shadow (audit) table (AP_SUPPLIER_SITES_ALL_AC#), the VENDOR_ID column is only populated when the AUDIT_TRANSACTION_TYPE = 'C' (current). When the AUDIT_TRANSACTION_TYPE = 'U' (update), the VENDOR_ID column is not populated, which means it cannot be joined to the AP_SUPPLIERS shadow (audit) table (AP_SUPPLIERS_AC#). This means one cannot view both the current data and also updated data in these tables.

Require some sample SQLs to help achieve the requirement.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms