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.
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!