My Oracle Support Banner

Variance Between ALC and ELC In Decimal Precision Is Not Correctly Updated in Tran_Data (Doc ID 2576471.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 15.0.2 and later
Information in this document applies to any platform.


Due to the rounding, variance between ALC (actual landed cost) and ELC (estimated landed cost) values are incorrectly inserted in TRAN_DATA. 

Steps To Reproduce:

  1. Create an Purchase Order(PO) for an Simple Pack item having expense details.
  2. Ship and receive the PO.
  3. Close the PO.
  4. Create an Obligation for the cost component on that PO with amount 0.
  5. Approve and allocate the Obligation.
  6. Finalize the PO.
  7. Validate the data in TRAN_DATA and check the results, 2 lines should have been generated. One for the receipt and another for the variance
  8. Since the Obligation is of 0 value, the variance should be exactly the same as the ELC.
  9. Compare TOTAL_COST - TOTAL_COST_EXCL_ELC from the receipt record (tran_code = 20 and ADJ_CODE is null) with the value from the variance record (tran_code = 20 and ADJ_CODE = ‘A’). The values will be different by some decimals.




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.