My Oracle Support Banner

ECC Iprocurement Data Load Failed With ORA-29902 and ORA-00068 (Doc ID 2695783.1)

Last updated on JULY 30, 2020

Applies to:

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


On : 12.2.9 version, ECC iProcurement

ECC Iprocurement Data Load Failed With the following error:

Failed as one of the load rules failed which is [id = 8,204, ICX_ECC_UTIL_PVT.get_ecc_data_load_info]. Please check the load rule audit entry

There is SQLException while applying load rule for dataset icx-catalog for job 24,003. Exception details ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-00068: invalid value 1500000000 for parameter _kgl_large_heap_assert_threshold, must be between 0 and 0oracle.jdbc.driver.T4CTTIoer11.processError( oracle.jdbc.driver.T4CTTIoer11.processError( oracle.jdbc.driver.T4C8Oall.processError( oracle.jdbc.driver.T4CTTIfun.receive(


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

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