My Oracle Support Banner

TRAN_OUT_BAL ReSA Errors Experienced For Multiple Scenarios Including Rounding (Doc ID 2235847.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Retail Point-of-Service - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Point-of-Service version, TRAN_OUT_BAL Retail Sales Audit (ReSA) errors experienced for multiple scenarios including rounding:

Pre-requisite:

1. <Patch 21869499>  and <Patch 25308437>


Scenario 1 - Regular rounding out of balance error

Receipt:

1/15/17 10:33 AM

Business Date: 1/15/17

Transaction: 0842

Store: 07266

Register: 027

Till: 02701

Cashier: xxxxxx

Sales: xxxxxx

VAT: 572 8421 28

Item: 207110325 59.00 N

LETTERS - K - MWL UNISEX

Quantity: 1 @ 59.00

Transaction: Discount (7.77)

Discount: Amount

Discount Reason: 2155 - Corporate

Total Discount: (7.77)

Total: 51.00

Cash Tendered: 51.00

Total Tender: 51.00

Change Due: 0.00

Rounding Adjustment: 0.23

Change Given: 0.00

1/15/17 10:35 AM

 RTLog records result:

  

In this scenario, (i.e. transaction price 29.88, after rounding 29.50, customer pays 40.00). Only the change is saved in TR_LTM_TND_CHN, but the rounding is not. The resulting RTLog causes TRAN_OUT_BAL error in ReSA.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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