ORA-00001 Modification Error. (Doc ID 2113067.1)

Last updated on FEBRUARY 18, 2017

Applies to:

Oracle Fusion Goal Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Goal Management

ORA-00001 Modification Error.


We have an error when trying to increase the data to the Manage Worker Goal Setting Lookups in Setup and Maintenance Sections.
We need to change the meaning by 25 to a wider data by 5, thus we required to add more entry.


The problem is happening directly in Production.


ERROR
-----------------------
ORA-00001: unique constraint (FUSION.FND_LOOKUP_VALUES_TL_U2) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup and Maintenance -> Manage Worker Goal Setting Lookups
2. HRG_PERCENT_COMPLETE
3. When we capture a new record, we click on Save an we get the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
We are about to start a new process to capture the 2016 Objectives, thus, we need your support urgently in order to resolve this 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