11i: OIE: Unexpected Error JBO-27122, ORA-01008 When Create New Expense Report (Doc ID 415169.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to choose the Create Expense Report button when creating an Internet Expense Report,
the following error occurs.

Excerpts from 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
WHERE h.employee_id IN (SELECT a.number_value
FROM ak_web_user_sec_attr_values a
WHERE a.attribute_code = :1
AND a.web_user_id = :2)
AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='N'
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
WHERE h.person_id IN (SELECT a.number_value

...

## Detail 0 ##
java.sql.SQLException: ORA-01008: not all variables bound

...

Changes

Cause