My Oracle Support Banner

File icxr12fi.sql Fails During Upgrade to R12.1 (Doc ID 1082681.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle iProcurement - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
**Checked for relevance on 13-Dec-2011***


During an upgrade to Release 12.1.x, the upgrade patch driver fails when attempting to process the file icxr12fi.sql.

sqlplus -s APPS/***** @/u01/oracle/dev/apps/apps_st/appl/icx/12.0.0/patch/115/sql/icxr12fi.sql
ERROR at line 1:
ORA-20000: icxr12fi.sql(100): ORA-20000: Exception at
ICX_CAT_R12_UPGRADE_PVT.callICXFinalSteps(1400), ORA-20000: Exception at
ICX_CAT_R12_UPGRADE_PVT.createCtxDomainIndex(600), ORA-20000: Exception at
ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800): ORA-20000: Exception at
ICX_CAT_INTERMEDIA_INDEX_PVT.create_index(1800): ORA-29855: error occurred in
the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10754: memory size must be between 1024 and 2097152000
ORA-06512: at line 19



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.