XLA_DISTRIBUTION_LINKS and GMF_XLA_EXTRACT_LINES Tables Have Mismatch Data for Some Purchase Orders/Receipts Which Causes this Data to Not Be Included in the AP and PO Accrual Reconciliation Report (Doc ID 2648226.1)

Last updated on MAY 01, 2024

Applies to:

Symptoms

Some purchase orders and receipts are not included in the AP and PO accrual reconciliation report.
Found that the scripts below do not return the data when linking the  tables "xdl_distribution_links and
GMF_XLA_EXTRACT_LINES" for some purchase orders.

select * from xla_ae_headers where ae_header_id in (select ae_header_id
from xla_ae_lines where gl_sl_link_id in (select gl_sl_link_id from
gl_import_references where je_header_id = xxx) ) ;


 select xdl.source_distribution_type , xdl.source_distribution_id_num_1 ,
 xdl.* from apps.xla_ae_headers xah,
 apps.xla_ae_lines xae,
 apps.xla_distribution_links xdl where xah.ae_header_id =
 xae.ae_header_id
 and xah.ae_header_id = xdl.ae_header_id
 and xae.ae_line_num = xdl.ae_line_num
 and xah.ae_header_id in (xxx);


 select *
 from gmf_xla_extract_headers gxeh, gmf_xla_extract_lines gxel
 WHERE gxel.line_id in (xxx)
 xdl.source_distribution_id_num_1
 AND gxel.header_id = gxeh.header_id;

Cause

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