ORA-00001: unique constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated When Updating Task Assignments Via API (Doc ID 1588556.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Project Foundation - Version 11.5.10.2 and later
Oracle Project Planning and Control - Version 11.5.10.2 and later
Oracle Project Resource Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Public API pa_task_assignments_pub.update_task_assignments has the following error.

Error mesg ORA-00001: unique constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure add_planning_transactions
Error mesg ORA-00001: unique constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated in Package PA_TASK_ASSIGNMENTS_PUB Procedure update_task_assignments

Users also get the following error when they are trying to delete a resource assignment through Pa_Task_Assignments_Pub.Delete_Task_Assignments API.

Unexpected Error ORA-00001: unique constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated
Unexpected Error:Update_Task_AsgmtsORA-00001: unique constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated
Unexpected Error:Delete_Task_AssignmentsUser-Defined Exception

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