Payables and Cash Management - EBS (MOSC)

MOSC Banner

unable to match the distribution records in Audit table and base table

Hi,

We have enable the audit trial in payables invoice and related tables are ap_invoices_all, ap_invoice_lines_all, ap_invoice_distributions_all. we have enabled some columns in those table for auditing. In that distributions table we enable the gl_date and account column for audit. if user update or delete the records then it will be stored in shadow table ap_invoice_distributions_a.

Our problem is, invoice having more than 100 lines and enduser change the account in particular invoice distributions and changed records are stored in audit table. we unable to match the records using invoice_distribution_id in ap_invoice_distributions_all and ap_invoice_distributions_a which table is shadow table and stored the audit records. in that audit table, invoice_id and distribution_line_number is having the records. invoice_distribution_id value is null in audit table. Please help us in this regards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center