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

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

For independent value set <Value Set Name>,
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

Changes

Cause

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