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

Last updated on APRIL 04, 2025

Applies to:

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

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