My Oracle Support Banner

R12: 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 JULY 21, 2020

Applies to:

Oracle Project Planning and Control - 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

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.