R12: PA: Error When Publishing Workplan ORA-01400 (Doc ID 2203213.1)

Last updated on NOVEMBER 13, 2016

Applies to:

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

Symptoms

When the user is trying to republish the workplan for the project, receives error message.

"An error occurred during publication. Please re-publish the workplan by clicking the button Republish on Maintain Versions page."

When trying to delete the current working version and copy it from the correct version, only REPUBLISH button was available and not the delete button.

Also, the PAWPUWBS module: PRC: Process Structure Updates process errors with,

ORA-01400: cannot insert NULL into ("PJI"."PJI_FM_EXTR_PLAN_LINES"."RESOURCE_CLASS_CODE")

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