Receive Error: EXCEPTION: Missing IN OR OUT Parameter, When Attempting To Add Lines To Sourcing Event RFQ and/or RFI . (Doc ID 2086748.1)

Last updated on DECEMBER 21, 2015

Applies to:

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

Symptoms

On Release 12.1.3 version, Create Negotiation

When attempting to create a New RFQ Negotiation and Add Lines to that RFQ Negotiation the following returns the following error.
 
ERROR:
Returns Error: You have encountered an unexpected error.
Please contact the System Adminstrator for assistance.
Click: here for exception details.
.
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageBean.releaseRootApplicationModule(OAPageBean.java:6072)
at oracle.apps.fnd.framework.webui.OAPageContextImpl.performReleaseApplicationModule(OAPageContextImpl.java:2571)
at oracle.apps.fnd.framework.webui.OAPageContextImpl.performReleaseRootApplicationModule(OAPageContextImpl.java:2527)
at oracle.apps.fnd.framework.webui.OAPageBean.performReleaseApplicationModules(OAPageBean.java:4669)
at oracle.apps.fnd.framework.webui.OAPageBean.finalizeRequest(OAPageBean.java:4394)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:607)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:213)
.
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 3

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Sign on to Application
2. Select Responsibility: Sourcing Super User
3. Navigation: Sourcing Home - Page ->> Create RFQ # 1234 ->>
4. Enter RFQ # 1234 Header - Details ->> Click: "Lines" ->>
5. Opens Create RFQ 1234: Lines Page ->> Select Action: Create Line ->>
6. Click: "GO" ->>
7. Returns Error: You have encountered an unexpected error.
    Please contact the System Administrator for assistance.
    Click: here for exception details.
.
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageBean.releaseRootApplicationModule(OAPageBean.java:6072)
at oracle.apps.fnd.framework.webui.OAPageContextImpl.performReleaseApplicationModule(OAPageContextImpl.java:2571)
at oracle.apps.fnd.framework.webui.OAPageContextImpl.performReleaseRootApplicationModule(OAPageContextImpl.java:2527)
at oracle.apps.fnd.framework.webui.OAPageBean.performReleaseApplicationModules(OAPageBean.java:4669)
at oracle.apps.fnd.framework.webui.OAPageBean.finalizeRequest(OAPageBean.java:4394)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:607)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:213)
.
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 3

BUSINESS IMPACT
The issue has the following business impact:
U User are unable to create and publish any Sourcing Events for Suppliers.

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