My Oracle Support Banner

JBO-27122: Sql Error During Statement Preparation.error After Patch 26915873 While Updating Task From Agent Dashboard (Doc ID 2331179.1)

Last updated on JULY 15, 2020

Applies to:

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


From Agent Dashboard, when attempting to update any task after applying <Patch:26915873>:R12.CSZ.C ,see the following error occurs:

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
  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
  Select t.task_type_id
  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
  Select task_type_id, name ,schedule_flag, rule
  From jtf_task_types_vl
  Where task_type_id = :3
  Order by 2
  at oracle.apps.fnd.framework.OAException.wrapperException(

1.Apply patch "26915873:R12.CSZ.C"
2.Login to eBusiness Suite
3.Select Customer Support Specialist responsibility
4.Navigate to Queue Work Selection > Agent Dashboard.
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
8. The reported error occurs




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.