Inventory Adjustment Transactions Are Populated with Total_retail As Null in TRAN_DATA Table
(Doc ID 2193792.1)
Last updated on FEBRUARY 21, 2019
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, total_retail in TRAN_DATA table 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.
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