Java.sql.SQLException: Missing IN Or OUT Parameter At Index:: 6 IProc/RCV When Search By Order
Last updated on OCTOBER 09, 2014
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:
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.
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