java.sql.SQLException: Missing IN or OUT parameter at index:: 2 on Action Check (Doc ID 836348.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Freight Payment, Billing, and Claims - Version 5.5.05.03 to 6.2.7 [Release 5.5 to 6.2]
Oracle Transportation Management - Version 5.5.05.03 to 6.2.7 [Release 5.5 to 6.2]
Information in this document applies to any platform.
***Checked for relevance on 13-May-2014***

Symptoms

A  user assigned "Action Checks" when edit an invoice
allow condition :

select invoice_gid from invoice where invoice_source='I'
and invoice_number=substr(substr(invoice_gid, instr(invoice_gid,'.')+1),5) and invoice_gid=:gid
UNION select invoice_gid from invoice where invoice_source IN ('M','G') and invoice_gid=:gid

When Query on invoice (invoice source = I) and open in edit mode to modify the invoice number (for example), the following error is seen:

java.sql.SQLException: Missing IN or OUT parameter at index:: 2

java.sql.SQLException: Missing IN or OUT parameter at index:: 2
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1735
.

.

.

 

If one removes the union clause then the standard action check message is presented (as expected, since failing the allow condition).


-- Steps To Reproduce:


1. Assign a user "Action Checks" option by following the following navigation :
Configuration and Administration > User Configuration > Manage User Access.
In the User Access Type field, select the option Action Checks, then click finished.


2. Query on invoice (with invoice source = I), and in edit screen attempt
to modify the invoice number, the following error is seen when click on finished:

java.sql.SQLException: Missing IN or OUT parameter at index:: 2

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