My Oracle Support Banner

XItemSupMod Message Fails With Error ORA-20001 When Updating Barcodes (Doc ID 2564942.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

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

Symptoms

Getting below error when trying to update VPN using XItemSupMod message.

Error
-----------------------
"RMSSUB_XITEM.CONSUME(?,?,?,?)}: [E] Error ORA-20001: This column should not be null.INNER_NAME,ITEM:XXX,SUPPLIER:YYY returned by program unit CORESVC_ITEM.PROCESS_IS"

Steps To Recreate:
1. Attach a new supplier to an existing barcode by injecting a XItemSupCre message for the barcode
2. Observe the new supplier is added to table ITEM_SUPPLIER
3. Modify the VPN of the barcode attached to the new supplier just added. Inject a XItemSupMod message for this purpose.
4. Note the above error.

Changes

 

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
Changes
Cause
Solution
References


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