Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Hello Folks, we are upgrading from R12.2.2 to R12.2.4, and the upgrade patch 17919161 failed with the following error occurs when running POS_SUPPLIER_SEARCH_INDEX.sql

DB: 11.2.0.3
 
DECLARE
*
ERROR at line 1:
ORA-20000: possearchindex.sql(500): ORA-20000: Exception at
POS_SUPPLIER_SEARCH_INDEX_PKG.create_index(1800): ORA-20000: Exception at
POS_SUPPLIER_SEARCH_INDEX_PKG.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 1073741824
ORA-06512: at line 58

Have you followed MOS Note: Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1) and applied with downtime mode ?