My Oracle Support Banner

Exception Error When Viewing the Approval Notification or Approval History of a Requisition With Status of In Process - ORA-06550 and PLS-00306 on Function RETRIEVE_APPROVAL_INFO (Doc ID 2647997.1)

Last updated on MARCH 12, 2020

Applies to:

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

Symptoms

In Oracle iProcurement, Release 12.1.3, an error occurs when approvers try to view the requisition approval notification or when trying to view the approval history of the requisition with status "In Process".

The issue began to occur after the following patch was applied:
- Patch 18294720:R12.ICX.B - This patch resolves the issue of index icx_cat_items_ctx_hdrs_tlp_n5 erroring out

Due to this issue, approvers are unable to see the requisitions that they need to approve.


Error

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

 

Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'RETRIEVE_APPROVAL_INFO'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764)
at oracle.apps.icx.por.reqmgmt.webui.ApprovalHistoryCO.processRequest(ApprovalHistoryCO.java:174)
..
..

 


Steps To Reproduce

The issue can be reproduced at will with the following steps:

A1. Log in to Oracle Applications.
A2. On the Oracle Applications Home Page (where responsibilities are listed), in the Worklist region. see the notification for the purchase requisition approval. Click the link for the notification. The error occurs at this point.

-- OR --

B1. Log in to Oracle Applications.
B2. Select an iProcurement responsibility > iProcurement Home Page.
B3. On the iProcurement shopping home page, click the Requisitions tab.
B4. On the View Requisitions page, click the Search button.
B5. On the Requisitions Search page, search for the desired requisition by requisition number.
B6. In the search results, see that the status of the requisition is "In Process". Click the "In Process" link. An error occurs at this point:



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.