My Oracle Support Banner

TRAN_OUT_BAL Error Appears Again Even After Deleting the Transactions and Re-loading Them With Correct Values (Doc ID 2818929.1)

Last updated on NOVEMBER 02, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

TRAN_OUT_BAL errors appear again even after deleting the transactions and re-loading them with correct values.

ERROR
-----------------------
TRAN_OUT_BAL

Steps to Recreate:

  1. Create one transaction with mismatch between sales value and tender amount. Notice TRAN_OUT_BAL error.
  2. Delete store day transactions from the Store Day Audit screen.
  3. Notice that errors got deleted.
  4. Create another transaction with correct tender amount.
  5. Audit the store day from Store Day Audit screen.
  6. Run the sapreexp post job.
  7. Notice that TRAN_OUT_BAL error appear again.

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.