SA_ERROR Shows TRAN_OUT_BAL Error for a Penny but Shows Balanced on POS and in ReSA Screens
(Doc ID 2908304.1)
Last updated on NOVEMBER 10, 2022
Applies to:Oracle Retail Sales Audit - Version 16.0.2 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.
On : 16.0.2 version, Transaction Maintenance
When fuel sales are imported that contain discounts the result is TRAN_OUT_BAL errors even though the sales are in balance. Fuel sales will include quantities that are more than 2 decimal points (for example, 205.863 gallons) and unit retails that are more than 2 decimal points (for example, 1.599 per gallon). Although these sales are in balance in POS and show in balance in the ReSA screens there is an SA_ERROR record created with TRAN_OUT_BAL showing a 1 penny discrepancy.
There is an inconsistency between the two calculations that are made. The balance correctly calculated (shows $0.00 as the difference on the screen) in one place but incorrectly calculated (shows ! on the screen and a penny difference in the SA_ERROR record). Either they both should be balanced or both be unbalanced.
STEPS TO REPRODUCE
1. Import a fuel sale containing quantities and retails to 3 decimal points. Include discounts and multiple tenders.
2. Notice TRAN_OUT_BAL error in SA_ERROR
3. Notice sale is balanced in ReSA
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