My Oracle Support Banner

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.

Symptoms

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)

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


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