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

Last updated on FEBRUARY 23, 2017

Applies to:

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

Symptoms

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

Pre-requisite:

1. Patch: 21869499 - CASH ROUNDING IS NOT HAPPENING WHILE USING ANY METHOD FOR ROUNDING VIZ. ROUND UP

2. Patch: 25308437 - ROUNDING ADJUST. IS NOT SAVED PROPERLY TO THE DATABASE WITH PATCH 22125024


Scenario 1 - Regular rounding out of balance error

Receipt:

  

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

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