My Oracle Support Banner

Consignment Item - TOTAL_COST And TOTAL_RETAIL Are Populated As Null For Tran Code 122 And 123 Posting In TRAN_DATA (Doc ID 2988959.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Oracle Retail Merchandising System - Version 19.0.1 and later
Information in this document applies to any platform.


Performing an inventory adjustment for a consignment Item, the values in the table TRAN_DATA (columns TOTAL_COST and TOTAL_RETAIL) are populated as NULL for tran_code 122 and 123 (instead of zero).

The issue can be reproduced at will with the following steps:
1. Navigate to RMS application and open Inventory adjustment screen.
2. Perform inventory adjustment for consignment Item and Save.
3. Verify RMS database for inventory adjustment posting.

Note :
- If inv_adj_reason.cogs_ind is 'N', then 122 will be posted.
- If inv_adj_reason.cogs_ind is 'Y', then 123 will be posted.


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.