My Oracle Support Banner

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

Last updated on JULY 11, 2022

Applies to:

Oracle Project Foundation - 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

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
Symptoms
Cause
Solution
References


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