Inventory Adjustment Transactions are Being Populated with Total_retail As NULL in TRAN_DATA Table

(Doc ID 2193792.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


While doing inventory adjustment from external system, TRAN_DATA.TOTAL_RETAIL is updated to null and does not have the value.

Steps To Recreate:

1. Create an item whose UNIT_RETAIL in ITEM_LOC table is 9.99.

2. Choose a reason code whose COGS_IN is Y.

3. Now try to do an inventory adjustment for -100 using the script / RMS screen.

4. Check the TRAN_DATA, a record inserted with TRAN_CODE 23 with TOTAL_RETAIL as null.




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