"iProcurement ECC Data Load" Is Failing With Ora-00600 Error (Doc ID 2810669.1)

Last updated on OCTOBER 15, 2023

Applies to:

Symptoms

When attempting to run  iProcurement data load, the following error occurs.

Even trying to recreate the intermedia index, the following error occurs:
begin
ICX_CAT_INTERMEDIA_INDEX_PVT.drop_index ;
ICX_CAT_INTERMEDIA_INDEX_PVT.create_index ;
end;

Error starting at line : 2 in command -
begin
ICX_CAT_INTERMEDIA_INDEX_PVT.drop_index ;
ICX_CAT_INTERMEDIA_INDEX_PVT.create_index ;
end;
Error report -
ORA-20000: Exception at ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1210):
ORA-20000: Oracle Text error:
DRG-13004: language is invalid
ORA-06512: at "APPS.ICX_CAT_INTERMEDIA_INDEX_PVT", line 410
ORA-06512: at line 3
20000. 00000 -  "%s"
*Cause:    The stored procedure 'raise_application_error'
          was called which causes this error to be generated.
*Action:   Correct the problem as described in the error message or contact
          the application administrator or DBA for more information.


Oracle RDBMS/Tools Version(s): Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

ERROR
-----------------------
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

ECCRUNDL: ECC Run Data Load
+---------------------------------------------------------------------------+

Current system time is 25-AUG-2021 16:00:28

+---------------------------------------------------------------------------+

CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: https://dev2-boss-oci.sgs.net:443
datasetsForSerialLangsProfile is empty
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:icx]
Parameter [name:pDataSetKey, value:]
Parameter [name:pLoadType, value:FULL_LOAD]
.
.
.ERROR 4.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule ICX_ECC_UTIL_PVT.get_ecc_data_load_info with dataset icx-catalog for job 43,952java.sql.SQLException: ORA-00600: internal error code, arguments: [kdsgrp1-qetlbr], [], [], [], [], [], [], [], [.
....
There is SQLException while applying load rule for dataset icx-catalog for job 43,952java.sql.SQLException: ORA-00600: internal error code, arguments: [kdsgrp1-qetlbr], [], [], [], [], [], [], [],
....


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run "iProcurement ECC Data Load"
2. See the error in the log file

.

Cause

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