Patch Failing With "Check Protect and Custom Level of ITEM_TYPE 'ICXBLKNT' Or Having Slow Performance For Sql Populate_icx_endeca.sql (Doc ID 1642574.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

When attempting to apply <patch 17862003>:R12.ICX.B ( can also happen with other patches)
the following error occurs.

ERROR
-----------------------
wferr:
- 1602: Could not save.
- 1400: Could not save to database. MODE=UPGRADE EFFDATE=&amp;lt;null&amp;gt;
- 1404: Please first load this entity or check protect and custom level of ITEM_TYPE 'ICXBLKNT'.
Oracle Workflow Definition Loader 2.6.4.0.

Access level: 100, Mode: UPGRADE
ITEM_TYPE 'ICXBLKNT' is protected, no changes were saved.

Or patch gets  stuck with performance issue for sql populate_icx_endeca.sql

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms