Incorrect Quantity and Amount Posting in ALC Tables

(Doc ID 2008824.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Retail Trade Management - Version and later
Information in this document applies to any platform.


In Actual Landed Cost (ALC) tables, the TRAN_DATA.TOTAL_COST and ITEM_LOC_SOH.AV_COST are incorrectly calculated for allocation basis different than Each (EA).

Steps to Reproduce :

  1. Create a cost component on freight that has the CBM allocation basis
  2. Create an import Purchase Order PO and use this cost component in expenses.
  3. Create transportation records for the PO in sailed status.
  4. Ship and receive the PO
  5. Create an obligation for the cost component at Vessel Voyage ETD level .
  6. Approve the obligation.
  7. Finalize the Actual Landed Cost ALC for the order .




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