Custom Query To Drill Back From XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1 Into Costing (Doc ID 2601895.1)

Last updated on FEBRUARY 05, 2023

Applies to:

Goal

User have a custom query hitting the XLA_TRANSACTION_ENTITIES table along with other XLA% tables as well as GL% tables.

Data columns and values from XLA_TRANSACTION_ENTITIES table:
XLA_TRANSACTION_ENTITIES.SOURCE_APPLICATION_ID = 401
XLA_TRANSACTION_ENTITIES.ENTITY_CODE = MISCELLANEOUS_TRANSACTION
XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER = XXX
XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1 = YYY

The above transaction pertains to Miscellaneous Transaction of type Account Alias. For the value of YYY from column SOURCE_ID_INT_1 in table XLA_TRANSACTION_ENTITIES, which source table(s) does this value coming from?
Looking in INV_MATERIAL_TXNS, but no columns such as TRANSACTION_ID contain that value.
Also look into CST_TRANSACTIONS, no luck either.

With that value of YYY, user need to drill back to that specific inventory transaction.
 

Solution

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