Cost Management - EBS (MOSC)

MOSC Banner

Material Transactions and SLA: why 2 entries in XLA_DISTRIBUTION_LINKS for the same distribution

edited Jul 17, 2015 10:09AM in Cost Management - EBS (MOSC) 1 commentAnswered

Hi all,

am bulding a query to join Material Transactions details with SLa and GL. I am using the link between MTL_TRANSOURCE_DISTRIBUTION_ID_NUM_1 and INV_SUB_LEDGER_ID, however for the same MTL_TRANSACTION_ACCOUNTS.transaction_id am getting 2 records with different XLA_DISTRIBUTION_LINKS.ae_header_id.

What does it means to have 2 different ae_header_id and how to distinguish the 2 to get the right information?

This is the simple query am using.

select xdl.* --xae.*,

from  XLA_DISTRIBUTION_LINKS XDL --, xla_events xae

where xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

and XDL.SOURCE_DISTRIBUTION_ID_NUM_1 in (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Cost Mgmt Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center