Clicking Requisition Details Gives ReqDetailsCO.processPRDSHistoryRendering(ReqDetailsCO.java:2310) (Doc ID 2294033.1)

Last updated on AUGUST 04, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Requisition Creation

When attempting to click the requisition details after <patch 22684834>:R12.ICX.D,
the following error occurs.

ERROR
-----------------------

Exception Details.
oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:647)


## Detail 0 ##
java.lang.NullPointerException at
oracle.apps.icx.por.reqmgmt.webui.ReqDetailsCO.processPRDSHistoryRendering(ReqDetailsCO.java:2310)
at oracle.apps.icx.por.reqmgmt.webui.ReqDetailsCO.processPageForRendering(ReqDetailsCO.java:856)
at oracle.apps.icx.por.reqmgmt.webui.ReqDetailsCO.processRequest(ReqDetailsCO.java:429)

Errors for invalid PACKAGE BODY ICX_PRDS_GEN_PKG

PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PLS-00201: identifier 'ICX_PRDS_CUSTOM_UPDATE_PKG.ICX_XML_ELEMENT_TBL' must be declared
PL/SQL: Item ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Requisition Details in iProcurement



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