RTLOG Load Process Is Inserting Incorrect Value in UOM_QUANTITY Field in SA_TRAN_DISC Table (Doc ID 2115868.1)

Last updated on MARCH 16, 2016

Applies to:

Oracle Retail Sales Audit - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Sales Audit (ReSA), the RTLOG load process is inserting an incorrect value into the UOM_QUANTITY field in SA_TRAN_DISC table.


Steps to Reproduce:

  1. Load RTLOG file containing two or more digits in the unit discount amount field.
  2. Run batches to load RTLOG.
  3. Note the quantity entered in the UOM_QUANTITY field in the SA_TRAN_DISC table.

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