SA_TRAN_ITEM.UOM_QTY Column is Getting Populated Wrongly (Doc ID 1548515.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

SA_TRAN_ITEM. UOM_QTY column is getting populated wrongly.

Steps To Recreate:

1. Run sastdycr batch.
2. Run sagetref batch.
3. Upload an RTLOG file with UOM_QTY  as  01234567.0000 by running the saimptlogi batch.
4. UOM_QTY field in SA_TRAN_ITEM table has incorrect value 234567 instead of 1234567.

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