My Oracle Support Banner

Incorrect Values Is Updated In The TRAN_DATA.TOTAL_COST After ALC Finalization (Doc ID 2481770.1)

Last updated on NOVEMBER 30, 2021

Applies to:

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


In Oracle Retail Trade Management 16.0.1, Incorrect values is updated in the TRAN_DATA.TOTAL_COST after Actual Landed Cost(ALC) Finalization.

Steps To Reproduce:

  1. Create a purchase order with a cost of USD 1000.00.
  2. Add a MASESTC component, estimated at 10%, so we have ELC = USD 1100,00 now.
  3. Approve and receive the Purchase Order. Note that in the tran_data table a record has been created with tran_code 20, adj = null, with the amount of USD 1,100.
  4. Create an obligation with the MASESTC component with zero value, approve and allocated in the ALC.
  5. Create another obligation with the FLETEEXT component with USD 500.00 value, approve and allocated in the ALC.
  6. Finalize the ALC.
  7. Notice that there are now two records in tran_data which is not correct:
    tran_code 20, adj = null = 1100
    tran_code 20, adj = "A" = 500




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

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

In this Document

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