Unable to Range Locations to Items Due to 'Error ORA-01400'
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.
Why while ranging Locations to Items, below error is seen on the RMS form:
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?
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