Carrier Form Error: APP-WSH-231106: Unexpected Errors Encountered at position 10 when Calling FND_LOOKUP_VALUE_PKG_INSERT_ROW (Doc ID 1986518.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Setup Issues

When adding a new ship method for Carrier and selecting  "Organization Assignments" button, the following error occurs:

APP-WSH-231106: Unexpected Errors Encountered at position 10
when Calling FND_LOOKUP_VALUE_PKG_INSERT_ROW
Details : Exception Message &EXCEPTION
Error ORA-00001: unique constraint
(APPLSYS.FND_LOOKUP_VALUES_U2) violated, Code -1.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Shipping->setup->freight carriers, cost types-> Freight Carriers.
1. Query the desired Carrier.
2. Add a Service level and a mode of transport.
3. Click "Organization Assignments" button.
4. Error pops up.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add new Carrier

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