Exception Error Occurs During Checkout Process in iProcurement - java.sql.SQLException: ORA-06550 PLS-00306 UPDATE_WO_ADD_DES_DIR_ITEM (Doc ID 1453778.1)

Last updated on DECEMBER 28, 2016

Applies to:

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

Symptoms

In Oracle iProcurement, Release 12.1.3, an error occurs when attempting to complete the requisition checkout process.


Error

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.

The exception details show:

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 'UPDATE_WO_ADD_DES_DIR_ITEM'
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(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:972)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:232)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:150)
at oracle.apps.icx.por.req.webui.CheckoutSummaryCO.processNextButton(CheckoutSummaryCO.java:544)
at oracle.apps.icx.por.req.webui.CheckoutSummaryCO.processFormRequest(CheckoutSummaryCO.java:491)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'UPDATE_WO_ADD_DES_DIR_ITEM'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.icx.por.schema.server.MaintenanceHelper.validateInternal(MaintenanceHelper.java:233)
at oracle.apps.icx.por.schema.server.CheckoutInfoBaseHelper.validate(CheckoutInfoBaseHelper.java:144)
at oracle.apps.icx.por.schema.server.PoRequisitionLineEOImpl.validationLogic(PoRequisitionLineEOImpl.java:388)
at oracle.apps.icx.por.schema.server.PorBaseEOImpl.executeHelperLogic(PorBaseEOImpl.java:576)
at oracle.apps.icx.por.schema.server.PorBaseEOImpl.validateEntity(PorBaseEOImpl.java:628)
at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:1544)
at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4013)
at oracle.apps.icx.por.req.server.ValidationSvrCmd.validateReq(ValidationSvrCmd.java:87)
at oracle.apps.icx.por.req.server.RequisitionAMImpl.validateReq(RequisitionAMImpl.java:758)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.populateValidateAndSave(CheckoutSummarySvrCmd.java:2050)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.executeMethodByName(CheckoutSummarySvrCmd.java:108)
at oracle.apps.icx.por.req.server.CheckoutInfoBaseSvrCmd.execute(CheckoutInfoBaseSvrCmd.java:118)
at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)
at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:972)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:232)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:150)
at oracle.apps.icx.por.req.webui.CheckoutSummaryCO.processNextButton(CheckoutSummaryCO.java:544)
at oracle.apps.icx.por.req.webui.CheckoutSummaryCO.processFormRequest(CheckoutSummaryCO.java:491)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
..
..


Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications, using an iProcurement responsibility.
2. Create a catalog or non-catalog request, adding item(s) to cart.
3. View Cart and Proceed to Checkout.
4. On the Checkout: Requisition Information page (Checkout Step 1 of 3), click the Next button. The error page then appears.



Business Impact

Due to this issue, users cannot complete the requisition checkout process and requisitions cannot be submitted for approval.

Changes

Patch 12914431:R12.EAM.B "QUALITY ACTIONS TRIGGERED WHEN COMPLETING EAM WORK ORDERS" was applied.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms