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 laterOracle 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.
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 |