Copy Requisition Errors: PLS-00306 'COPY_TAX_ATTRIBUTES' (Doc ID 2817721.1)

Last updated on OCTOBER 27, 2021

Applies to:

Symptoms

On : 12.1.2 version, Requisitions

When trying to copy a requisition in IProcurement the following exception error is raised.

ERROR
-----------------------
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 'COPY_TAX_ATTRIBUTES'
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.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:176)
at oracle.apps.icx.por.req.webui.ReqOpCO.processPerformAction(ReqOpCO.java:1035)
at oracle.apps.icx.por.req.webui.ReqOpCO.processRequestAction(ReqOpCO.java:238)
at oracle.apps.icx.por.req.webui.ReqOpCO.processRequest(ReqOpCO.java:95)
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.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1538)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1588)
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.form.OAFormBean.processRequest(Unkn

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. iProcurement > Requisitions > Select Requisition
2. Click on Copy button
3. Error is raised

Changes

CPU and Framework patches were applied:

R12.AD.C.DELTA.12
R12.TXK.C.DELTA.12
32662188:R12.AD.C - ADDITIONAL MANAGED SERVER NOT GETTING STARTED IN WINDOWS
31904550:R12.TXK.C - This patch delivers the fix to ensure fs_clone duration is not impacted due to symbolic links of large size in APPL_TOP or COMMON_TOP
32438203: ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR APR 2021
32418566: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.7 BUNDLE13

Cause

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