Creating Expense Report Errors with java.sql.SQLException: Missing IN or OUT parameter at index:: 1 (Doc ID 971666.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Expenses - Version 11.5.10.2 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to enter an Expense Report the following error occurs.

ERROR
-----------------------

You have encountered an unexpected error. Please contact the System Administrator for assistance.

Full error stack:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (/* This query will exclude terminated contingent workers and terminated employees who became contingent workers to avoid duplicate rows. Otherwise 2 rows for the same person could be possible. */

SELECT
h.employee_id,
h.full_name,
h.employee_num,
h.organization_id,
'E' assignment_type,
h.inactive_date termination_date
FROM per_employees_x h,
ak_web_user_sec_attr_values a,
per_periods_of_service_v s
WHERE h.employee_id = a.number_value
AND a.attribute_code = :1
AND a.web_user_id = :2
AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id) = 'N'
AND h.employee_id = s.person_id (+)
AND trunc(sysdate) <= trunc(nvl(s.final_process_date, sysdate))
UNION ALL
SELECT h.person_id employee_id,
h.full_name,
h.npw_number employee_num,
h.organization_id,
'C' assignment_type,
h.termination_date
FROM per_cont_workers_current_x h,
ak_web_user_sec_attr_values a
WHERE h.person_id = a.number_value
AND a.attribute_code = :3
AND a.web_user_id = :4) QRSLT ORDER BY UPPER(full_name)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:612)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)

.....

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow


Same error occurs when attempting to save an Internet Expenses Payments search

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