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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.