My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

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:


THEAD RoundedAmount = 5123, RoundedOffamount = 0023
ITEM with value     P590000
DISC with value       077700
CASH1 with value  P510000
ROUND with value N002300

  
In this regular rounding scenario as described above, ReSA is giving transaction out of balance error. Removing the RoundedOffAmount from THEAD and reversing the sign of rounding TTEND causes the transaction to go through in ReSA.

 

Scenario 2 - Rounding + issue change for customer

 Receipt:

1/17/17 9:06 AM

Business Date: 1/17/17

Transaction: 0901

Store: 04020

Register: 031

Till: 03101

Cashier: 0

Sales: 0

VAT: 572 8421 28

Item: 204225255 29.88 N

S12 FLORAL JEANS FD 18-2

Quantity: 1 @ 29.88

Reason Code: Ad Price

Total Discount: 0.00

Total: 29.50

Cash Tendered: 40.00

Total Tender: 40.00

Change Due: 10.50

1/17/17 9:06 AM

  RTLog result records:

TTEND0000000008CASH 1000 P00000000000000400000
TTEND0000000009CASH 1000 N00000000000000105000
TTAIL00000000100000000003
FTAIL00000000110000000009

  

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.