Unexpected Tran Code 16 Generated In Tran_Data table Due To Rounding Issues

(Doc ID 2394323.1)

Last updated on MAY 14, 2018

Applies to:

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

Symptoms

Tran code 16 generated in TRAN_DATA due to rounding issues.  

Steps to Reproduce:

  1. Select an item that is on clearance and range a new location to this item during transaction like inventory adjustment.
  2. Execute newitemloc batch.
  3. Observe the tran code 16 due to the rounding issues.

Considering the following example where Tran code 16 is posted for the difference in retail :

Item original retail - 94.97

Item ranged to a location on clearance by inventory adjustment : 5 qty

Clearance is 15%

New unit retail is 94.97 *.85 = 80.7245

In RMS/RPM tables,the price is rounded to 80.72

In SIM,the price is 80.7245

In TRAN_DATA total_retail = 403.62 (80.7245 *5 rounded to 2 decimals)

After executing the New Item Loc batch.

Now the system posts a tran_code 16 due to the rounding issues

tran_code 16 : Old retail = 80.7245, new retail =80.72

Hence system posts a difference in total_retail of (80.7245-80.72)* 5= .02 under tran_code 16

Changes

 

Cause

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