Value Chain Planning Demantra Missing Local Partition for a Database Object ORA-02149 ORA-06512 ORA-00959 Tablespace Index
(Doc ID 1439081.1)
Last updated on OCTOBER 27, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 188.8.131.52 and later
Information in this document applies to any platform.
I would like to use 2 level planning using MPS to feed MRP. I need an additional plan partition
There is also a requirement to create a separate plan for a 5 year planning as there are some vendors that need orders as early as 3 years in advance so they, the vendor, can convert their lands for organic farming that needs a minimum time of 3 years for the affect of chemical to be removed etc.
The issue is in production and the absence of these processes is impacting the overall planning processes.
All of this cannot be done without this issue being resolved.
This was working fine in 12.1.1, I have 6 plans that are running in production.
For those 6 plans I had to create plan partitions in 12.1..
Now after the upgrade when they want to add another plan is when they are encountering this issue.
After I upgraded from 12.1.1 to 12.1.3 I have started getting an error when trying to create APS plan partition. I am specifying plan partition = 1, instance partition = 0 in parameters of create APS partion program.
The MSCCRPAR module: Create APS Partitions program gets the following error:
ORACLE error 2149 in FDPSTP
Cause: FDPSTP failed due to ORA-02149: Specified partition does not exist
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at "APPS.MSC_MANAGE_PLAN_PARTITIONS", line 362
ORA-00959: tablespace '_$deleted$382$0' does not exist
From the provided trace file: "APSDEV_ora_7696_CR3605735.trc", we see
the following error:
PARSE ERROR #47248931892792:len=78 dep=3 uid=80 oct=26 lid=80
LOCK TABLE "MSC_VISITS" PARTITION ("VISITS_4021") IN EXCLUSIVE MODE NOWAIT
Summary: 24X7 ATP Supply Chain Plan failed due to No Free Plan Partition when Plan Partition
is available in
Description: Request had failed with error ORA-20000: User-Defined Exception: No Free partition
Error Message: error ORA-20000: User-Defined Exception: No Free partition
Upgraded from 12.1.1 to 12.1.3
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