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.

Goal

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?
 

Solution

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 hundreds of Community platforms