R12:AP:When Attempting To Query Vendor in Subledger Accounting Lines (XLA_AE_LINES) and Compare with Invoice Lines (AP_INVOICES_ALL) Notice the Data Discrepancy Between the Tables
(Doc ID 3035086.1)
Last updated on JULY 22, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to query vendor in subledger accounting lines and compare with invoice lines the user notices a data discrepancy between the tables for the field vendor_site_id
STEPS
-----------------------
1. Query the vendor site id in xla_ae_lines and ap_invoices_all tables
2. Compare the data for the vendor site id
3. Data is a mismatch between xla_ae_lines and ap_invoices_all tables
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |