PLS-00306: Wrong Number Or Types Of Arguments In Call To 'GET_TEMPLATE_ID' (Doc ID 2874215.1)

Last updated on JANUARY 10, 2023

Applies to:

Symptoms

When attempting to copy a requisition to the shopping cart, the following error occurs.

ERROR
-----------------------
You have encountered an expected error. Please contact your System Administrator for assistance.

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 44:
PLS-00306: wrong number or types of arguments in call to 'GET_TEMPLATE_ID'
ORA-06550: line 1, column 38:
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:1070)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:258)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:176)
at oracle.apps.icx.por.req.webui.ReqOpCO.processPerformAction(ReqOpCO.java:1010)
at oracle.apps.icx.por.req.webui.ReqOpCO.processRequest(ReqOpCO.java:99
...
  at oracle.apps.icx.por.req.server.CheckoutInfoBaseSvrCmd.getTemplateId(CheckoutInfoBaseSvrCmd.java:4438)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.executeMethodByName(CheckoutSummarySvrCmd.java:196)
at oracle.apps.icx.por.req.server.CheckoutInfoBaseSvrCmd.execute(CheckoutInfoBaseSvrCmd.java:163)
at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)
at sun.reflect.GeneratedMethodAccessor4957.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:1070)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:258)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:176)
at oracle.apps.icx.por.req.webui.ReqOpCO.processPerformAction(ReqOpCO.java:1010)
at oracle.apps.icx.por.req.webui.ReqOpCO.processRequest(ReqOpCO.java:99)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into iProcurement
2. Open the Requisitions page, select a requisition, and click on the Copy to Cart button

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.