I am trying to build a query that will fetch the Receipt Accounting entries and related data for Oracle cloud 19a version. I am using xla_ae_headers and xla_ae_lines to get the accounting entries along with the receipt accounting tables like CMR_RCV_TRANSACTIONS and CMR_RCV_DISTRIBUTIONS.
However, for journal category Deliver and accounting class Reserve for Encumbrance, I cannot see any entries in XLA_DISTRIBUTION_LINKS table to connect with the receipt accounting tables using the column source_distribution_id_num_1. Please help me in identifying the table link for the same.
Did u try to link to the following table?