My Oracle Support Banner

Error While Adding Attachments To A Receipt - Missing IN or OUT parameter at index:: 6 (Doc ID 2341839.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Desktop Rcv/Returns/Correction

When attempting to ,
the following error occurs.

ERROR
-----------------------
 Error Page

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT *
FROM (SELECT PDT.TYPE_NAME ORDER_TYPE, 'PO' ORDER_TYPE_CODE,
POH.PO_HEADER_ID ORDER_ID, TO_CHAR(POH.SEGMENT1) PO_NUMBER,
To_Number(NULL) RELEASE_NUM, TO_CHAR(POH.SEGMENT1) PO_NUM_REL_NUM,
......
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
........
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 6
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Responsibility: iProcurement
2. Home Page > Receiving tab
3. Select ‘Find by order Number’ in ‘Search Attribute’ field , enter ‘Search Value’ and click on ‘Go’ button
3. Select item and add attachments by placing cursor on ‘Add Attachments’ icon
4. After entering details in attachment pop up click ‘Add Another’ button
5. On clicking ‘Add Another’ button page navigates to an error page

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.