My Oracle Support Banner

Patch:18120913:R12.PRC_PF.B Fails Processing Populate_icx_endeca.sql (Doc ID 1670786.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Issue while applying 12.1.3:Procurement Family Update-Current Rollup Patch:18120913:R12.PRC_PF.B

Problem Description
---------------------------------------------------
As suggested in the MOS Doc ID#1468883.1, we have applied Patch#18120913 and it failed with the below error while running
/<SERVER>/app/appl/icx/12.0.0/patch/115/sql/populate_icx_endeca.sql.


sqlplus -s APPS USER/***** @/<SERVER>/app/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-29902: error in executing
ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb41
ORA-06512: at line 8

Error Codes
---------------------------------------------------
ORA-20000: Exception at ICX_ENDECA_UTIL_PKG.populate_precedence_rules

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.