My Oracle Support Banner

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

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