R12: OIE: When Creating an Expense Report the Following Error Occurs: "JBO-27122: SQL error during statement preparation"
(Doc ID 3065059.1)
Last updated on DECEMBER 24, 2024
Applies to:
Oracle Internet Expenses - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to create an expense report,
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
-----------------------
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
....
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1821)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4568)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:696)
at oracle.jbo.server.ViewRowSetImpl.getRowCount(ViewRowSetImpl.java:1940)
at oracle.jbo.server.ViewObjectImpl.getRowCount(ViewObjectImpl.java:6050)
at oracle.apps.ap.oie.webui.HeaderCO.processRequest(HeaderCO.java:279)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:620)
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1821)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4568)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:696)
at oracle.jbo.server.ViewRowSetImpl.getRowCount(ViewRowSetImpl.java:1940)
at oracle.jbo.server.ViewObjectImpl.getRowCount(ViewObjectImpl.java:6050)
at oracle.apps.ap.oie.webui.HeaderCO.processRequest(HeaderCO.java:279)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:620)
The issue can be reproduced at will with the following steps:
1. Navigate to an iExpenses responsibility
2. Click on Create Expense Report
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 |
| References |