My Oracle Support Banner

Wrong Value Getting Inserted in ReSA SA_TRAN_HEAD for Sale Transactions (Doc ID 1949624.1)

Last updated on MARCH 09, 2019

Applies to:

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


 Wrong value getting inserted in Retail Sales Audit (ReSA),  SA_TRAN_HEAD for sale transactions when the Sale Total's sign bit is either '+' or blank.

Steps To Recreate:

1. Create a sale transaction in Retail Point Of Service (ORPOS).
2. Pass Retail Transaction Log (RTLOG) from ORPOS to ReSA.
3. Process RTLOG file into ReSA.
4. Note that the value of the transaction in SA_TRAN_HEAD is wrongly updated. If the tender amount is $1210,then SA_TRAN_HEAD.VALUE = $12110.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.