Run 'PRC: Delete Historical Workplans and Financial Plans': Historical Published Workplan Version For Publish Failed Or Publish In Progress Projects are Getting Deleted (Doc ID 1953994.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle Project Management - Version 12.1.2 and later
Information in this document applies to any platform.
PRC: Delete Historical Workplans and Financial Plans

Symptoms

For your project, there is unplanned actuals and/or publish which failed in concurrent mode
You submit the "PRC: Delete Historical Workplans and Financial Plans" to delete historical workplan versions or delete the historical workplan versions
You attempt to re-published your workplan: It fails with the following error:

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