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:

Symptoms

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.

Cause

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