My Oracle Support Banner

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

Last updated on SEPTEMBER 29, 2021

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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