Inventory Adjustment Transactions are Being Populated with Total_retail As NULL in TRAN_DATA Table
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