fndnlins.sql ORA-00001 adnuniq.sql ORA-00932
(Doc ID 795600.1)
Last updated on MARCH 04, 2023
Applies to:
Oracle EBS Applications Translation - Version 11.5.10.0 to 12.0.6 [Release 11.5.10 to 12]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
fndnlins.sql fails with the following error:
MESG
LANGUAGE=AMERICAN
PACKAGE=FND_LOOKUP_VALUES_PKG
SQLERRM=ORA-00001: unique constraint (APPLSYS.FND_LOOKUP_VALUES_U2) violated
select to_date('ERROR')
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
adnuniq.sql fails with the following error:
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got -
ORA-06512: at line 203
STEPS
The issue can be reproduced at will with the following steps:
1. Run fndnlins.sql.
2. Get the error.
3. Run adnuniq.sql.
BUSINESS IMPACT
The issue has the following business impact:
Cannot compile flexfields or maintain multi-lingual tables.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |