My Oracle Support Banner

GLNLINS.sql Fails With The Error ORA-01858: A Non-numeric Character Was Found.. (Doc ID 2704172.1)

Last updated on AUGUST 27, 2020

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Adding a new language to Oracle E-Business Suite per note (R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)).
As per this note, running sql file GLNLINS.sql and it is ending with an error. 

GLNLINS.sql fails with the below error:

Adding new languages rows for GL_JE_SOURCES_TL and GL_JE_CATEGORIES_TL

PL/SQL procedure successfully completed.


MESG
--------------------------------------------------------------------------------
LANGUAGE=AMERICAN PACKAGE=GL_JE_CATEGORIES_PKG SQLERRM=ORA-00001: unique constraint (GL.GL_JE_CATEGORIES_U1) violated


select to_date('ERROR')
  *
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected



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
References


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