Unexpected Tran Code 16 Generated In Tran_Data table Due To Rounding Issues
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.
Tran code 16 generated in TRAN_DATA due to rounding issues.
Steps to Reproduce:
- Select an item that is on clearance and range a new location to this item during transaction like inventory adjustment.
- Execute newitemloc batch.
- 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
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