Worker Job (XDONLINS.sql) Errored Out With ORA-01400 Maintain Multi-Languale Tables From adadmin Utility (Doc ID 1607379.1)

Last updated on DECEMBER 07, 2015

Applies to:

Oracle Application Install - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

 Maintain Multi-Languale Tables via adadmin utility.   The worker job (XDONLINS.sql) errored out with ORA-01400 as follows:

From adworkxxx.log:

sqlplus -s APPS/***** @$XDO_TOP/11.5.0/sql/XDONLINS.sql

PL/SQL procedure successfully completed.


MESG
--------------------------------------------------------------------------------
LANGUAGE=AMERICAN
PACKAGE=XDO_CURRENCY_FORMAT_SETS_PKG
SQLERRM=ORA-01400: cannot insert NULL into ("XDO"."XDO_CURRENCY_FORMAT_SETS_TL".
"FORMAT_SET_NAME")


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

 

Changes

 After licensing KO/Korean language, it will apply to any new language

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