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

Last updated on JANUARY 29, 2020

Applies to:

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

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