Error ORA-20001:This Column Should Not Be Null.DIRECT_SHIP_IND,ITEM:%s,SUPPLIER:%n Returned By Program
(Doc ID 2515294.1)
Last updated on MARCH 27, 2020
Applies to:Oracle Retail Merchandising System - Version 16.0.1 to 16.0.2 [Release 16.0]
Information in this document applies to any platform.
When Processing Message XITEMSUPMOD
The following error is returned:
CONSUME API returned(E) errorString(Error ORA-20001: This column should not be null.DIRECT_SHIP_IND,ITEM:%s, SUPPLIER:%n returned by program unit CORESVC_ITEM.PROCESS_IS.)
Steps to recreate:
Oracle RMS Demo Data and the item does have a value of "N" at ITEM_SUPPLIER
Process XITEMSUPMOD via RDMT or via RIBScript and ensure Null value for DIRECT_SHIP_IND
In this case the Non Mandatory field is not provided within the message (non mandatory as per Integration guide)
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