Total Retail Value is Posted as 'Null' in TRAN_DATA Table for Inventory Adjustments When the Total Unit Retail Value is -999
(Doc ID 2537144.1)
Last updated on JUNE 04, 2019
Applies to:Oracle Retail Merchandising System - Version 14.0 and later
Information in this document applies to any platform.
In Retail Merchandising System, when Inventory Adjustment is done for an Item, TRAN_DATA.TOTAL_RETAIL value is being posted as NULL when the total retail value is -999.
Steps to Reproduce:
1. Create an inventory adjustment for an item/location (warehouse) such that the total retail (i.e. unit retail of the item * units adjusted = -999)
2. Validate the transaction in TRAN_DATA table.
3. Notice that the TOTAL_RETAIL value will be populated 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