Assignments could not be sent through MSP (Doc ID 2258766.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When trying to send assignments from MSP to OP the following errors are displayed:

ERRORS:
ORA-00001 Unique Constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure add_planning_transactions
ORA-00001 Unique Constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated in Package PA_TASK_ASSIGNMENTS_PUB Procedure update_task_assignments
User-Defined Exception in Package PA_TASK_ASSIGNMENTS_PUB Procedure EXECUTE_UPDATE_TASK_ASGMTS

STEPS:
1. See Microsoft Project Integration Preferences
Send Work Breakdown Structure = All Task Levels
Assign Oracle Projects 'Task Number' field = Column 'Text5'

2. Enter Task information

3. Send to Oracle Projects > Project data

4. Choose a responsibility: Project Super User

5. Choose Project Template > Click Next

6. Enter Project Information > Finish
Message: Your project plan has been successfully created in Oracle Projects

7. Go to File > Oracle Projects > Project Information
Message: The project has not been created in Oracle Projects

8. Create new MSP file from PA project created above
Select Project Destination : Project Number from step 6 > Next
Include: Work Breakdown Structure ; Resources ; Task Numbers > Finish

9. Add resources to task

10. Re-send to Projects
Send: Work Breakdown Structure and Dates > Next > Finish
Publish Workplan: No
Message: Your project plan has been updated successfully in Oracle Projects
Assignment sent successfully

11. Add new task and add resource from resource list

12. Send to Projects
Send: Work Breakdown Structure and Dates > Next > Finish
Publish Workplan: No

Message: Your project plan has been updated successfully in Oracle Projects
Assignment could not be sent
ORA-00001 Unique Constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure add_planning_transactions
ORA-00001 Unique Constraint (PA.PA_RESOURCE_ASSIGNMENTS_U2) violated in Package PA_TASK_ASSIGNMENTS_PUB Procedure update_task_assignments
User-Defined Exception in Package PA_TASK_ASSIGNMENTS_PUB Procedure EXECUTE_UPDATE_TASK_ASGMTS

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