Error Shows When Click The 'Create Expense Report' Button (Doc ID 1617577.1)

Last updated on MAY 01, 2017

Applies to:

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

Goal

After applying patch 17901794 and click the 'Create Expense Report' button, JBO-27122: SQL error during statement preparation happens.

Detailed error is:

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

 

Solution

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