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 to [Release 11.5.10]
Information in this document applies to any platform.


 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.

SQLERRM=ORA-01400: cannot insert NULL into ("XDO"."XDO_CURRENCY_FORMAT_SETS_TL".

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



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


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