Cannot Publish Workplan Error: ORA-01400: Cannot Insert NULL Into ("PA"."PA_WF_PROCESSES"."ENTITY_KEY1")
(Doc ID 2811407.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Oracle Project Planning and Control - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
When trying to publish a workplan for a project the following error is encountered on the page:
Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance.
Click here for exception details.
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PA"."PA_WF_PROCESSES"."ENTITY_KEY1")
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PUB1", line 2111
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 6480
ORA-06512: at "APPS.PA_PROJ_TASK_STRUC_PUB", line 18835
ORA-06512: at "APPS.PA_PROJ_TASK_STRUC_PUB", line 21584
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PUB1", line 2427
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 14909
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 13692
ORA-06512: at "APPS.PA_WORKFLOW_UTILS", line 185
ORA-06512: at "APPS.PA_WORKFLOW_UTILS", line 143
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 13655
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 6451
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 14848
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PUB1", line 2348
ORA-06512: at "APPS.PA_PROJ_TASK_STRUC_PUB", line 20892
ORA-06512: at "APPS.PA_PROJ_TASK_STRUC_PUB", line 18737
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PVT1", line 6228
ORA-06512: at "APPS.PA_PROJECT_STRUCTURE_PUB1", line 1946
ORA-06512: at line 1
Steps to reproduce:
1. Using a Projects responsibility, navigate to Projects: Delivery-->Project List
2. Select the project number from the Project List page.
3. Select Project-->Setup
Ensure the Workplan Baseline Versioning option is enabled.
4. Select Workplan-->Tasks.
5. Click on Review and Publish
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 |