In Case Worker or Customer Support Specialist An Exception Occurs While Updating A Task

(Doc ID 2153472.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Customer Support - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Update Service Request

When attempting to update a task for a Case,
the following error occurs.

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT jts_vl.task_status_id ,
 jts_vl.name task_status_name
FROM jtf_task_statuses_vl jts_vl
WHERE jts_vl.task_status_id = nvl(:1,jts_vl.task_status_id)
UNION
SELECT jts_vl.task_status_id ,
 jts_vl.name task_status_name
FROM jtf_task_statuses_vl jts_vl ,
 jtf_state_transitions jst ,
 jtf_state_responsibilities jsr
WHERE jst.final_state_id = jts_vl.task_status_id
AND ( jts_vl.start_date_active <= SYSDATE
OR jts_vl.start_date_active IS NULL )
AND ( jts_vl.end_date_active >= SYSDATE
OR jts_vl.end_date_active IS NULL )
AND jst.rule_id = jsr.rule_id
AND jsr.responsibility_id = fnd_global.resp_id
AND jst.initial_state_id = :2
UNION
SELECT jts_vl.task_status_id ,
 jts_vl.name task_status_name
FROM jtf_task_statuses_vl jts_vl
WHERE ( jts_vl.start_date_active <= SYSDATE
OR jts_vl.start_date_active IS NULL )
AND ( jts_vl.end_date_active >= SYSDATE
OR jts_vl.end_date_active IS NULL )
AND NOT EXISTS(
SELECT jsr.responsibility_id
FROM jtf_task_statuses_vl jts_vl ,
 jtf_state_transitions jst ,
 jtf_state_responsibilities jsr
WHERE jst.final_state_id = jts_vl.task_status_id
AND ( jts_vl.start_date_active <= SYSDATE
OR jts_vl.start_date_active IS NULL )
AND ( jts_vl.end_date_active >= SYSDATE
OR jts_vl.end_date_active IS NULL )
AND jst.rule_id = jsr.rule_id
AND jsr.responsibility_id = fnd_global.resp_id)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
.
.
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Case Worker > query an existing case
2. Go to Tasks and Related Information tab
3. Try to update a Task
4. The reported error occurs.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms