My Oracle Support Banner

JTF_TASK_ASSIGNMENTS_PUB.UPDATE_ASSIGNMENT Not Updating Resource_id And Resource_Type_Code (Doc ID 2390445.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


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


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

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