How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger?
For transactions like Additions, Adjustments, and Retirements etc. the mapping is:
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_ADJUSTMENTS.TRANSACTION_HEADER_ID
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_ADJUSTMENTS.ADJUSTMENT_LINE_ID
For Depreciation event transaction rows:
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_CHAR_4 = FA_DEPRN_DETAIL.BOOK_TYPE_CODE
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_DEPRN_DETAIL.ASSET_ID
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_DEPRN_DETAIL.PERIOD_COUNTER
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_3 = FA_DEPRN_DETAIL.DEPRN_RUN_ID
XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_5 = FA_DEPRN_DETAIL.DISTRIBUTION_ID
Reference: Doc ID 2002464.1