Unable to Range Locations to Items Due to 'Error ORA-01400'

(Doc ID 2038769.1)

Last updated on JANUARY 04, 2018

Applies to:

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

Goal

Why while ranging Locations to Items, below error is seen on the RMS form:

Error:
Status Code:E
Error msg:Error ORA-01400: cannot insert NULL into ("RMS14DEV"."ITEM_COUNTRY"."COUNTRY_ID") returned by program unit NEW_ITEM_LOC_SQL.CHECK_ITEM_COUNTRY.

How to avoid this error?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms