R12 OIE : Can't Create Expense Report - JBO-27122 WrapperException

(Doc ID 2328034.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Oracle Internet Expenses - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Expenses Administration Utils

When attempting to create expense report button on the expenses home page in iExpenses responsibility,
the following error occurs.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT lookup_code lookup_code, meaning description
FROM fnd_lookup_values_vl
WHERE lookup_type = 'HOME_OFFICE'
AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(:1) = 'N'
UNION
SELECT TO_CHAR(vendor_site_id) lookup_code, vendor_site_code description
FROM ap_supplier_sites
WHERE SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1)
AND NVL(pay_site_flag,'N')='Y'
and vendor_id is not null
AND vendor_id =
 (SELECT paaf.vendor_id
 FROM per_all_assignments_f paaf
 WHERE paaf.person_id = :2
 AND paaf.primary_flag = 'Y'
 AND trunc(fnd_date.canonical_to_date((:3))) BETWEEN trunc(paaf.effective_start_date ) AND trunc(paaf.effective_end_date )
 AND paaf.vendor_id IS NOT NULL
 )) QRSLT ORDER BY description
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:647)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
...
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using iExpenses responsiblity Go to Expenses home page

2. Click on Create expense report button

3. Receive error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create expense report

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