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 MARCH 08, 2017

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)
at _OA._jspService(_OA.java:220)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
at _OA._jspService(_OA.java:213)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.eve


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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create followup 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