OBLIGATION_COMP.QTY Accepting only Number with 4 Decimals Resulting in Bad Data for ALC
(Doc ID 2687497.1)
Last updated on JULY 08, 2020
Applies to:Oracle Retail Trade Management - Version 14.1 and later
Information in this document applies to any platform.
ALC ( Actual Landed Cost) is calculated wrong when there is a conversion from CBM (Cubic meters) to EA (eaches).
The problem appears when entering the final invoice amounts to RTM (Retail Trade Management) due to rounding of alc_comp_loc.act_value to 4 decimals. Depending on the numbers it can cause data mismatch. alc_comp_loc.act_value needs to be changed in order to accept number with 40 decimals, otherwise the ALC ( Actual Landed Cost) is calculated wrong when there is a conversion from CBM to EA.
Steps to reproduce:
1. Add Obligation into RTM (field alc_comp_loc.act_value).
2. Notice that the field is not accepting number with more than 4 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