My Oracle Support Banner

Purge Plan Is Not Setting Free_flag In Msc_plan_partitions. Plan create screen, error on save 'there is an error while getting plan id. no free partitions available (Doc ID 1304299.1)

Last updated on JANUARY 03, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Aug-2014***

Symptoms

Run Purge Plan process and expect that msc_plan_partitions will have free_flag set to 1 (free) for this partition when the process finishes.

Observe that the process does not set the Free_flag = 1 so this partition can be used again, it remains at 2 and partition is therefore used and cannot be re-used when defining a new plan.

Error on save:

there is an error while getting plan id. no free partitions available


STEPS
--------
Run Purge Plan process and then observe the results.

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


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