My Oracle Support Banner

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.


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

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.





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

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