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 JUNE 28, 2017

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

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