Oracle Fusion AP - How to correctly pair Debit and Credit XLA lines for AP Invoice accounting report

hi

We are building a custom BI Publisher report in Oracle Fusion Cloud (Oracle ERP Cloud) 
that shows AP invoice journal accounting details with debit and credit account side by side 
for each transaction line.

 

ENVIRONMENT:
- Oracle Fusion Cloud ERP
- BI Publisher Report
- AP Payables, application_id = 200

 

APPROACH:
We use xla_distribution_links to get the debit XLA line for each AP invoice distribution, 
then join credit XLA lines from the same entity via same GL journal (je_header_id).

 

WORKING CORRECTLY FOR:
- Standard PO invoices (single line, single distribution)
- AR transactions (using xla_distribution_links on credit side via REV distribution)