My Oracle Support Banner

ECC: Data Load For IProcurment Runs Into An Error DRG-10825: stored query does not exist: icxzb (Doc ID 2603239.1)

Last updated on JANUARY 29, 2020

Applies to:

Oracle iProcurement - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version,

ACTUAL BEHAVIOR
---------------
ECC: Data Load for iProcurment runs into an error

As per document "Oracle iProcurement Implementation and Administration Guide", page 6-5, client has performed a full load from ECC Developer responsibility.
The full load runs into an error. When running the full log with debug,
Found errors in the log, like "DRG-10825: stored query does not exist: icxzb".



here is the error in log file:

SELECT
ecc_spec_id,
zonesb
from icx_cat_ecc_zones_b
09:29:07.272 [pool-4-thread-2] ERROR
1.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 16,829
java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb

 

SELECT
ecc_spec_id,
zonesb
from icx_cat_ecc_zones_b;
==>
client ran the query, this is the result:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.

 

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.