No Free Partitions Available When Trying To Run Plan In 24x7 ATP Mode (Doc ID 802349.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 10.7 to 12.0.4 [Release 10.7 to 12]
Information in this document applies to any platform.
***Checked for relevance on 20-JUL-2015***

Symptoms

On 12.0.4 in Test: We are running our main plan in 24x7 ATP mode.
We start out with a total of 3 partitions and 2 plans (main and test plan).
The following SQL shows 3 partitions with 1 of them being available (free_flag = 1).

SELECT plan_id, plan_name, free_flag, partition_number
FROM msc_plan_partitions

When running the test plan (not ATP enabled) all is fine.
When running the ATP plan for the first time all is fine.
When trying to run the ATP plan a second time, the concurrent request fails and we get the ORA-20000 error.
We then look at the results of the same query above and there is no partition available with
free_flag of 1.

The only way we can get another ATP run to complete is by dropping the "not named" partition via
drop partition cc (partition number / plan = yes), re-compile hundreds of invalid objects, and
re-create an APS partition.

It then starts all over again.

ERROR:

MSCSLPPR5 module: Launch Supply Chain Planning Process

ORA-20000: User-Defined Exception:No Free partitions available. Contact DBA to create
partitions.p_source_plan_id1025 p_dest_plan_name1025 p_dest_plan_descGLOBAL p_dest_plan_type1
p_dest_atp2 p_dest_production1 p_dest_notifications2 p_dest_inactive_on p_organization_id82
p_sr_instance_id2021


.

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