My Oracle Support Banner

Getting ORA-01400 Error While Adding a New Country of Sourcing (Doc ID 2279219.1)

Last updated on DECEMBER 24, 2019

Applies to:

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


Getting ORA-01400 error while adding new item country of sourcing.


"Error ORA-01400:cannot insert NULL into ("SCH_RMS13"."ITEM_COST_HEAD"."NIC_STATIC_IND")returns by program unit ITEM_LOC_SQL.INSERT_ITEM_COST_LOC."

Steps To Reproduce:

  1. Navigate to Items -> Items.
  2. Select Edit Item -> Enter the Item number and tab out -> Click on OK button.
  3. Click on Suppliers button on the top left corner.
  4. lick on Item-Supplier-Country of Sourcing button on top left.
  5. Add a new country of Sourcing,in the Country of sourcing field, For Ex 'CA' and click on Create.
  6. Click ok.
  7. Note the above error.




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

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