My Oracle Support Banner

Error When Trying To View Details For A Purchase Order Tied To A Requisition - PLS-00306: Wrong Number Or Types Of Arguments In Call To GET_PO_TOTAL_INVOICED (Doc ID 2687225.1)

Last updated on JULY 08, 2020

Applies to:

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

Symptoms

In Oracle iProcurement, Release 12.2.4 and later, an error occurs when trying to view the purchase order (PO) tied to a requisition line.
Due to this issue, users cannot view the order information for POs tied to the requisitions.

The issue is noticed to occur after the following patch was applied:
- Patch 30654559:R12.PRC_PF.C - Oracle Sourcing, iSP, SLM, Supplier Hub Consolidation Patch for 12.2.4 - February 2020


Error

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

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

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.pos.changeorder.server.PosPOHdrSummVORowImpl.populateData(PosPOHdrSummVORowImpl.java:543)
at oracle.apps.pos.changeorder.server.PosPOHdrSummVORowImpl.getAmtReceived(PosPOHdrSummVORowImpl.java:234)
at oracle.apps.pos.changeorder.server.PosPOHdrSummVORowImpl.getAttrInvokeAccessor(PosPOHdrSummVORowImpl.java:162)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.pos.changeorder.webui.PosPoStatusSummCO.processRequest(PosPoStatusSummCO.java:102)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:645)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAContentContainerBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OACellFormatBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OARowLayoutBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-06550: line 1, column 197:
PLS-00306: wrong number or types of arguments in call to 'GET_PO_TOTAL_INVOICED'
ORA-06550: line 1, column 191:
PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.pos.changeorder.server.PosPOHdrSummVORowImpl.populateData(PosPOHdrSummVORowImpl.java:534)
at oracle.apps.pos.changeorder.server.PosPOHdrSummVORowImpl.getAmtReceived(PosPOHdrSummVORowImpl.java:234)
at oracle.apps.pos.changeorder.server.PosPOHdrSummVORowImpl.getAttrInvokeAccessor(PosPOHdrSummVORowImpl.java:162)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.pos.changeorder.webui.PosPoStatusSummCO.processRequest(PosPoStatusSummCO.java:102)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:645)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAContentContainerBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OACellFormatBean.processRequest(Unknown Source)
..
..

 



Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications.
2. Navigate to an iProcurement responsibility > iProcurement Home Page.
3. On the iProcurement shopping home page, click the Requisitions tab.
4. On the Requisition Views page, click the Search button.
5. On the Requisitions Search page, search by Requisition Number.
6. In the search results, click the link of the requisition number.
7. On the Requisition Details page, in the Details region (Lines region), click the Order Number link for a PO number of one of the requisition lines.
The 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.