Error "JBO-27122: SQL Error During Statement Preparation" and performance issues when searching the task
(Doc ID 2866567.1)
Last updated on AUGUST 12, 2024
Applies to:
Oracle Sales - Version 12.2.9 and laterOracle Common Applications Calendar - Version 12.2.9 and later
Information in this document applies to any platform.
Symptoms
When attempting to search a task, the following error occurs.
ERROR
"You have encountered an unexpected error. Please contact your System Administrator for assistance."
Exception Details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT task_status_id, name FROM jtf_task_statuses_vl WHERE task_status_id IN
(SELECT * FROM TABLE(CAST(jtf_task_utl.Get_Valid_Task_Statuses( :7, :8, :9) AS JTF_NUMBER_TABLE))) or ( 1=:1
and 2=:2
and 3=:3
and 4=:4
and 5=:5
and 6=:6)
at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)
.
.
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 7
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1937)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
STEPS
The issue can be reproduced at will with the following steps:
1. Navigate to (R) Supplier Data Librarian Super User > Suppliers > Tasks
2. In the Task search Page, click on Go Button without entering subject and task number.
3. Select any task from results table and click on pencil button (update).
4. Update any field and save the task. (or) Not updating any details and click on Cancel Button to come back to the previous search page.
5. Click on Go Button without entering Subject and Task Number in the Task search page (In user's case, the page keeps loading)
6. In the status field, receiving the mentioned error.
OTHER SYMPTOMS
It is not possible to access/search/update tasks in Oracle Sales.
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 |