My Oracle Support Banner

R12: Publishing Workplan Failing With Error ORA-0001: unique constraint (PA.PA_PROGRESS_ROLLUP_U2) violated in Package PA_PROGRESS_PUB Procedure APPLY_LP_PROG_ON_CWV (Doc ID 2523773.1)

Last updated on DECEMBER 20, 2019

Applies to:

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

Symptoms

When publishing Workplan Failing with Error

Workplan publishing for project is failing with Error, tried deleting the current working version and re-create the working version from the published version, but it still fails with the same error.

ERROR
-----------------------

1. ORA-0001: unique constraint (PA.PA_PROGRESS_ROLLUP_U2) violated in Package PA_PROGRESS_PUB Procedure APPLY_LP_PROG_ON_CWV
2. ORA-0001: unique constraint (PA.PA_PROGRESS_ROLLUP_U2) violated in Package PA_PROJ_TASK_STRUC_PUB Procedure PROCESS_WBS_UPDATES
3. ORA-0001: unique constraint (PA.PA_PROGRESS_ROLLUP_U2) violated in Package PA_PROJ_TASK_STRUC_PUB Procedure PROCESS_WBS_UPDATES_WRP
4. ORA-0001: unique constraint (PA.PA_PROGRESS_ROLLUP_U2) violated in Package PA_PROGRESS_PUB Procedure APPLY_LP_PROG_ON_CWV_WRP


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


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