Java.sql.SQLException: Missing IN Or OUT Parameter At Index:: 6 IProc/RCV When Search By Order (Doc ID 1931916.1)

Last updated on OCTOBER 10, 2022

Applies to:

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

Symptoms

In iProcurement/Receiving - if you search by Order number the app throws a java error when attempting to sort any of the columns in the list of items to receive.
Sorting throws error in iProcurement if search by Order Number):

iProcurement Receiving search
Enter PO # and click Go
Results:

Click on any field (description, etc) and throws error:

Error Details:
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,

....................

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 6

This works if you search by Requisition Number or Supplier.