1 Reply Latest reply on Dec 17, 2019 2:35 PM by user10271304

    No entry in XLA_DISTRIBUTION_LINKS for Reserve for Encumbrance




      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.