Maintain Multilingual Tables Errors: 'ORA-12838: cannot read/modify an object after modifying it in paralle'l and 'ORA-01858: a non-numeric character was found where a numeric was expected' (Doc ID 2150546.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Payroll - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to run adadmin Maintain Multilingual tables in a 12.2.4 environment with JA and US languages enabled, the following error occurs:

sqlplus -s APPS/***** @/d01/appsdev/EBSSIT1/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/d01/appsdev/EBSSIT1/fs1/EBSapps/appl/ff/12.0.0/sql/FFNLINS.sql '
Connected.

MESG
--------------------------------------------------------------------------------
LANGUAGE=AMERICAN
PACKAGE=FF_DATABASE_ITEMS_PKG
SQLERRM=ORA-12838: cannot read/modify an object after modifying it in parallel


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


Steps to Reproduce:
-----------------------
The issue can be reproduced at will with the following steps:

  1. Attempt to run adadmin Maintain Multilingual tables in a 12.2.4 environment with JA and US languages enabled




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