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:

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.

Cause

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