JTF_TASK_ASSIGNMENTS_PUB.UPDATE_ASSIGNMENT Not Updating Resource_id And Resource_Type_Code

(Doc ID 2390445.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Common Applications Calendar - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In 12.1.3

JTF_TASK_ASSIGNMENTS_PUB.UPDATE_ASSIGNMENT Not updating Resource_id and Resource_Type_Code

There are around 115+ rows which have incorrect data, the RESOURCE_ID and RESOURCE_TYPE_CODE do not match JTF_TASKS_B table. When trying to update the RESOURCE_ID and RESOURCE_TYPE_CODE the API runs successfully but does not update the rows. This happens when you run the API Twice, On the third and subsequent attempts it produces the error "The record has been changed or deleted by another user" as well as "ORA-2001: Please contact your system administrator".

ORA-2001: Please contact your system administrator / The record has been changed or deleted by another user

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