MSCCRPAR: Create APS Partitions - Has Error In Log - FDPSTP failed due to ORA-02149: Specified partition does not exist (Doc ID 2862274.1)

Last updated on APRIL 12, 2022

Applies to:

Symptoms

Running MSCCRPAR: Create APS Partitions throws this error:

ERROR
-----------------------
**Starts**29-OCT-2021 18:31:26
**SQL error and free**29-OCT-2021 18:31:27
ORACLE error 2149 in FDPSTP

Cause: FDPSTP failed due to ORA-02149: Specified partition does not exist
ORA-06512: at "SYSTEM.AD_DDL", line 210
ORA-06512: at "APPS.MSC_MANAGE_PLAN_PARTITIONS", line 399
ORA-14501: object is not partitioned
ORA-06512: at "AP29-OCT-2021 18:31:27
+---------------------------------------------------------------------------+

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain Planner
2. Navigation: Other > Requests > Submit a New Request
3. From the list of values, select Create APS Partitions program
4. Enter the following parameters:
- Plan partition count = 1
- Instance partition count = 0
5. Select OK
6. Select Submit

Cause

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