My Oracle Support Banner

Error "JBO-27122: SQL Error During Statement Preparation" and performance issues when searching the task (Doc ID 2866567.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Common Applications Calendar - Version 12.2.9 and later
Oracle Sales - Version 12.2.9 and later
Information in this document applies to any platform.


When attempting to search a task, the following error occurs.


"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(
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 7
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(


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.


It is not possible to access/search/update tasks in Oracle Sales.




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

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