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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |