My Oracle Support Banner

How To Join Between Landed Cost And Invoice Line Payables (Doc ID 1554427.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.


We have some Average cost update in Material transaction from Landed Cost Management; but we do not know which line of the invoice is joined.

There is a field "parent_transaction_id" in "rcv_transactions" table from the PO Receipt.

This ID in "trx_source_line_id" shows all Average Cost update from LCM in Material transaction, but we do not know which line join with each invoice line.

Is ID to join this average cost from Material Transaction LCM with Invoice lines?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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