Icx-iproc Sandbox Error ORA-06512: At "APPS.ICX_ENDECA_UTIL_PKG", Line 2729

(Doc ID 2360847.1)

Last updated on MARCH 16, 2018

Applies to:

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

Symptoms

On : 12.2.7 version, Information Discovery (v6 and higher)

Installed Information Discovery for Ebusiness Suite 12.2v8 on top of Ebusiness 12.2.7 upgraded environment.
icx-iproc full sandbox fails at step graph/Impl/DataDeNormalizerDesc.grf with below error message.

ERROR
-----------------------
Ran icx-iproc full sandbox.
At step graph/Impl/DataDeNormalizerDesc.grf fails in phase 1 READ_REQUISITION_LINES with:
2017-11-14 14:29:52,070 ERROR 252644 [WatchDog_252644] Component [Read Requisition Lines:READ_REQUISITION_LINES] finished with status ERROR. (Out0: 0 recs)
 ORA-06503: PL/SQL: Function returned without value
 ORA-06512: at "APPS.ICX_ENDECA_UTIL_PKG", line 2729


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run icx-iproc full sandbox.
2. icx-iproc full sandbox fails at step graph/Impl/DataDeNormalizerDesc.grf


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