My Oracle Support Banner

Cannot Publish Workplan Error: ORA-01400: Cannot Insert NULL Into ("PA"."PA_WF_PROCESSES"."ENTITY_KEY1") (Doc ID 2811407.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Project Planning and Control - Version 12.2.10 and later
Information 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


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