Running Fndnlins.Sql Isn't Updating FND_FLEX_VALUES_TL Correctly (Doc ID 1223725.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Application Object Library - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Symptoms

For independent value set ATC AFF Profit_Cost_Center,
when entering some new values like 35782, receive the error message:
"This value is already in use for this value set. Please enter a unique value."

However this value cannot be queried in the forms.

Did run FNDNLINS.sql - but this did not resolve error.

Have more than one language. For this customer had the following:
Code Language                                Status
----   ------------------------------------- ---------
US   American English                      Base
PTB Brazilian Portuguese                  Install
ESA Latin American Spanish             Install

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