PAXSUDSI: Unable to Save Implementation Options Form in Projects Due to ORA-01400: cannot insert NULL into ("PA"."PA_IMPLEMENTATIONS_ALL"."CC_EXP_ORG_STRUCTURE_ID") (Doc ID 2049055.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When trying to save the Project's Implementation Options form, the following error is received:

ORA-01400: cannot insert NULL into ("PA"."PA_IMPLEMENTATIONS_ALL"."CC_EXP_ORG_STRUCTURE_ID")

Details button shows:

ORA-01400: cannot insert NULL into ("PA"."PA_IMPLEMENTATIONS_ALL"."CC_EXP_ORG_STRUCTURE_ID")

FRM-40508: ORACLE error unable to INSERT record

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