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

Last updated on SEPTEMBER 01, 2017

Applies to:

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

Symptoms

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

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.

Cause

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