FndLWMLSConvDB.pl Fails On Synchronizing FND_EID_GROUPS_ZD_TL With Error ORA-00942 And ORA-06512 (Doc ID 2953554.1)

Last updated on JUNE 06, 2023

Applies to:

Symptoms

When attempting to convert languages to Lightweight from Full, the script fndLWMLSConvDB.pl fails with the following errors.

ERROR
-----------------------
Synchronizing FND_EID_GROUPS_ZD_TL
*******FATAL ERROR*******
PROGRAM : (fndLWMLSConvDB.pl)
TIME : Wed Jul 20 14:20:40 2022
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 20 14:20:37 2022

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 232



STACK TRACE
 at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
  TXK::Error::abort('TXK::Error', 'HASH(0x1102c7728)') called at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
  TXK::Common::doError('TXK::SQLPLUS=HASH(0x111ee9b60)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
  TXK::Common::setError('TXK::SQLPLUS=HASH(0x111ee9b60)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
  TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x111ee9b60)', 0) called at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
  TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x111ee9b60)', 'HASH(0x1113d53e8)') called at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 621
  TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x111837b48)', 'SET VERIFY OFF\x{a}WHENEVER SQLERROR EXIT FAILURE ROLLBACK;\x{a}WHENE...') called at /xxxx/xxxx/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Follow document "Using Lightweight MLS With Oracle E-Business Suite Release 12.1.3 and Higher" (Doc ID 1077709.1) to convert MLS language to lightweight from full.
2. Run the fndLWMLSConvDB.pl script.
3. Observe the errors.

Changes

Cause

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