My Oracle Support Banner

TRAN_OUT_BAL Flagged for Catch Weight Item (Doc ID 2827582.1)

Last updated on DECEMBER 13, 2021

Applies to:

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


Getting TRAN_OUT_BAL errors when there WEIGHTABLE ITEMS transactions  in RTLOG.


1. Send an RTLOG with mix of catchweight and regular items. All with the RTLOG catchweight indicator set to N (position 377 on TITEM line)

2. After running saimptlogi, TRAN_OUT_BAL error occurs even though the thetotal sales value is equal to the Tender Line amount.

3.  Issue occurs because the rounding on RESA makes use of the store's retail decimal precision (usually set as 2) , instead of 4.

For example for Catweight item 1 = Unit retail is 1.7897 whilst Qty is 13.46 with Selling UOM of LB  - The total retail for this item should be 24.0894  but saimptlogi was computing it as 24.09.




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

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