My Oracle Support Banner

Tables XLA_DISTRIBUTION_LINKS and GMF_XLA_EXTRACT_LINES do not match for some POs (Doc ID 2648226.1)

Last updated on MARCH 12, 2020

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.


In purchasing for OPM enabled organization, scripts are not returning the data while linking the following tables "xdl_distribution_links and
GMF_XLA_EXTRACT_LINES" for some purchase orders. Example queries being executed that do not return data 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 =
 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)
 AND gxel.header_id = gxeh.header_id;


 Need assistance to understand the issue and if it is a data corruption / data mismatch issue require data fix.



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

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