My Oracle Support Banner

FSTP - Create Task (follow Up Task) Button Gives Error In Both Parts Req Page And On Details Page (Doc ID 1623442.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Field Service Engineer Portal

When clicking on button "Create Task" to create a follow up task, the following error appears:


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

ERROR
-----------------------
Error Detail:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (Select t.task_priority_id
  , t.name
  , t.importance_level
From jtf_object_mappings s
  , jtf_task_priorities_vl t
Where object_code = 'JTF_TASK_PRIORITY'
And source_object_code = :1
And to_char(t.task_priority_id) = s.object_id
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_priority_id
  ,t.name
  ,t.importance_level
From jtf_task_priorities_vl t
Where NOT exists (select 1 from jtf_object_mappings
  where object_code='JTF_TASK_PRIORITY'
  and source_object_code = :2)
And sysdate between NVL(t.start_date_active,sysdate)
  and NVL(t.end_date_active,sysdate)
UNION
Select t.task_priority_id
  , t.name
  , t.importance_level
From jtf_object_mappings s
  , jtf_task_priorities_vl t
Where object_code = 'JTF_TASK_PRIORITY'
And source_object_code = :3
And to_char(t.task_priority_id) = s.object_id
And sysdate between NVL(t.start_date_active,sysdate)
  and NVL(t.end_date_active,sysdate)
  and nvl(s.end_date, sysdate) >= sysdate
and t.task_priority_id = :4
UNION
Select t.task_priority_id
  , t.name
  , t.importance_level
From jtf_task_priorities_vl t
where t.task_priority_id = 8) QRSLT ORDER BY importance_level
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3260)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3055)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. open FSTP
2. on the dashboard click on icon to update task
3. click on button Create task (on upper right corner)
The error appears.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.