11i/R12: OIE:Creating Expense Report Errors with java.sql.SQLException: Missing IN or OUT parameter at index:: 1
(Doc ID 971666.1)
Last updated on OCTOBER 07, 2024
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
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
Symptoms |
Cause |
Solution |
Still have Questions? |