When the RTLOG UOM Quantity Field Uses the Entire Range (number(12,4)), the Database Value Is Truncated
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Sales Audit - Version 184.108.40.206 and later
Information in this document applies to any platform.
When the RTLOG UOM quantity field uses the entire range (number(12,4)), the process that writes the value to the ReSA (Oracle Retail Sales Audit) database tables truncates the value.
QTY = 12345678.9012
UOM_QTY = 345678.9012
Steps to recreate:
1. Upload RTLOG which have UOM_Quantity 12345678.9012
2. The UOM_QUANTITY field is not populated correctly as per the RTLOG. It is populated as 345678.9012, and due to this, incorrect data appears on the ReSA screen.
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