My Oracle Support Banner

PLS-00306: wrong number or types of arguments in call to 'OWNER_CAN_APPROVE_AME'ORA-06550 (Doc ID 2486949.1)

Last updated on OCTOBER 10, 2022

Applies to:

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

Symptoms

When attempting to click on Edit button from Shopping Cart, the following error occurs:

ERROR
-----------------------
Error Page
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 'OWNER_CAN_APPROVE_AME'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(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1051)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:258)
at oracle.apps.icx.por.approval.webui.ApprovalsCO.processRequest(ApprovalsCO.java:91)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:643)
...
...
## Detail 0 ##
java.sql.SQLException: ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'OWNER_CAN_APPROVE_AME'ORA-06550: line 1, column 7: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.icx.por.approval.server.ApprovalListAMImpl.ameInitQuery(ApprovalListAMImpl.java:3598)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.ameBuildApprovalListForPreparer(ApprovalListAMImpl.java:1903)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.buildApprovalListForPreparer(ApprovalListAMImpl.java:1590)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.buildApprovalList(ApprovalListAMImpl.java:277)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.buildApprovalList(ApprovalListAMImpl.java:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
...




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to iProcurement responsibility
2. Create a Non-Catalog Request
3. In the Shopping Cart, click on Edit button
4. See the error:
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details

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.