Error "JBO-27122: SQL Error During Statement Preparation" When Searching The Task
(Doc ID 2866567.1)
Last updated on MAY 02, 2022
Applies to:
Oracle Common Applications Calendar - Version 12.2.9 and laterInformation 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.
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 |