My Oracle Support Banner

R12: OIE: Getting JBO-27122 Unexpected Error when Trying to Create an Expense Report (Doc ID 2510526.1)

Last updated on OCTOBER 03, 2024

Applies to:

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

Symptoms

When attempting to create an expense report, the users of a particular country are getting the following error:

 


ERROR
---------
"You have encountered an unexpected error. Please contact the system Administrator"

 

Error Stack:
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
 ------------------------------------------------
1. 1.Detail 0 ##
 java.sql.SQLException: Missing IN or OUT parameter at index:: 1



 

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.