My Oracle Support Banner

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

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