My Oracle Support Banner

Error While Opening/updating a Service Request in Service Desk (CS HTML) (Doc ID 1491824.1)

Last updated on JULY 14, 2020

Applies to:

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

Goal

When updating a Service Request, why does the following error appear:

Error

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)
?
 

Solution

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
Goal
Solution
References


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