My Oracle Support Banner

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.

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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