Oracle 12.1.3+ E-Business Suite RPC1 (17774755) failed for worker populate_icx_endeca.sql
Hi All,
While applying patch 17774755 worker populte_icx_endeca.sql failed with below error:
sqlplus -s APPS/***** @/finapp/PILLARC1/apps/apps_st/appl/icx/12.0.0/patch/115/sql/populate_icx_endeca.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-20000: Exception at ICX_ENDECA_UTIL_PKG.populate_precedence_rules
SQLERRM:ORA-20000: Exception at
ICX_ENDECA_UTIL_PKG.populate_metadata001SQLERRM:ORA-20000: Exception at
ICX_ENDECA_UTIL_PKG.populate_KVPs SQLERRM:ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 14
ORA-06512: at line 8
I saw some threads on same issue, however I'm not sure what is the right solution.
Also note that patch