jbo-27122: Sql Error During Statement Preparation.error After Patch 26915873 While Updating Task From Agent Dashboard

(Doc ID 2331179.1)

Last updated on NOVEMBER 22, 2017

Applies to:

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

Symptoms

From Agent Dashboard, When attempting to update any task after applying <Patch:26915873>:R12.CSZ.C ,see the following error
jbo-27122: sql error during statement preparation.error after patch 26915873

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.
 Click here for exception details.

  Upon clicking here see
  Exception Details.
  oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select
  t.task_type_id
  ,t.name
  ,schedule_flag
  ,t.rule
  ,planned_effort,planned_effort_uom
  From jtf_object_mappings s
  ,jtf_task_types_vl t
  Where object_code = 'JTF_TASK_TYPE'
  And source_object_code = :1
  And nvl(APPLICATION_ID,fnd_global.RESP_APPL_ID) = fnd_global.RESP_APPL_ID
  And to_char(t.task_type_id) = s.object_id
  And task_type_id <> 22
  And sysdate between NVL(t.start_date_active,sysdate)
  And NVL(t.end_date_active,sysdate)
  And nvl(s.end_date, sysdate) >= sysdate
  UNION ALL
  Select t.task_type_id
  ,t.name
  ,schedule_flag
  ,t.rule
  ,planned_effort,planned_effort_uom
  From jtf_task_types_vl t
  Where NOT EXISTS ( select 1
  from jtf_object_mappings
  where object_code = 'JTF_TASK_TYPE'
  and source_object_code = :2)
  And sysdate between NVL(t.start_date_active,sysdate)
  and NVL(t.end_date_active,sysdate)
  And task_type_id <> 22
  UNION
  Select task_type_id, name ,schedule_flag, rule
  ,planned_effort,planned_effort_uom
  From jtf_task_types_vl
  Where task_type_id = :3
  Order by 2
  at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)



STEPS
1.Apply patch "26915873:R12.CSZ.C"
2.Login to APPS using above details:
3.Navigate to customer support specialist
4.Navigate to queue work selection--->Agent Dashboard Page.
5.Search for any Service Request which has tasks
6.Navigate to Resolution and Wrap up tab
7.Click on Update pencil icon on any of the existing tasks

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