My Oracle Support Banner

Manual Task Creation Using Task Type Is Failing In Support Specialist Responsibility (Doc ID 2633631.1)

Last updated on JANUARY 29, 2020

Applies to:

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

Symptoms


Manual Task Creation using Task Type is failing in Support Specialist Responsibility with the below error


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


EXCEPTION DETAILS
-----------------------------
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT TaskAssigneeEO.TASK_ASSIGNMENT_ID,
  TaskAssigneeEO.OBJECT_VERSION_NUMBER,
  TaskAssigneeEO.TASK_ID,
  TaskAssigneeEO.RESOURCE_TYPE_CODE,
  TaskAssigneeEO.RESOURCE_ID,
  TaskAssigneeEO.ASSIGNMENT_STATUS_ID,
  TaskAssigneeEO.ATTRIBUTE1,
  TaskAssigneeEO.ATTRIBUTE2,
  TaskAssigneeEO.ATTRIBUTE3,
  TaskAssigneeEO.ATTRIBUTE4,
  TaskAssigneeEO.ATTRIBUTE5,
  TaskAssigneeEO.ATTRIBUTE6,
  TaskAssigneeEO.ATTRIBUTE7,
  TaskAssigneeEO.ATTRIBUTE8,
  TaskAssigneeEO.ATTRIBUTE9,
  TaskAssigneeEO.ATTRIBUTE10,
  TaskAssigneeEO.ATTRIBUTE11,
  TaskAssigneeEO.ATTRIBUTE12,
  TaskAssigneeEO.ATTRIBUTE13,
  TaskAssigneeEO.ATTRIBUTE14,
  TaskAssigneeEO.ATTRIBUTE15,
  TaskAssigneeEO.ATTRIBUTE_CATEGORY,
  TaskAssigneeEO.ASSIGNEE_ROLE,
jtf_task_utl.get_owner(
  TaskAssigneeEO.RESOURCE_TYPE_CODE,
  TaskAssigneeEO.RESOURCE_ID) AS RESOURCE_NAME,
  Extns.source_phone,
  Extns.source_job_title,
  Extns.source_email,
  'ResourceTypeEnabled' as Type_Switcher,
  'ResourceEnabled' as Name_Switcher,
  'AssigStatusEnabled' as Assgn_Status_Switcher
FROM jtf_task_all_assignments TaskAssigneeEO,
  jtf_rs_resource_extns Extns
WHERE TaskAssigneeEO.RESOURCE_ID = EXTNS.RESOURCE_ID(+)
  AND SUBSTR(TaskAssigneeEO.RESOURCE_TYPE_CODE, 4) = EXTNS.CATEGORY (+)) QRSLT WHERE TASK_ID = :1 ORDER BY ASSIGNEE_ROLE_MEANING ASC


# Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "ASSIGNEE_ROLE_MEANING": invalid identifier




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to E business Application
2. Go to Support Specialist responsibility
3. Navigate to Agent Dashboard >Create Service Request >Resolution and Wrap up tab
4. Select a task type from the Task type List Of Values and click on GO button to create Task.
Observe the above error



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.