MSCANAPP - Analyze Plan Partition Fails With ORA-8103 or ORA-12801 When Running 24x7 ATP Plan

(Doc ID 427535.1)

Last updated on NOVEMBER 15, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
EXECUTABLE:MSCANAPP - Analyze Plan Partition


Symptoms

11.5.10 in Production


PROBLEM
ORA-8103 error occurs when running
MSCANAPP module: Analyze Plan Partition

Log file shows

+---------------------------------------------------------------------------+

Current system time is 23-MAR-2007 14:22:38

+---------------------------------------------------------------------------+

**Starts**23-MAR-2007 14:22:38
ORACLE error 8103 in FDPSTP

Cause: FDPSTP failed due to ORA-08103: object no longer exists
ORA-06512: at "APPS.FND_STATS", line 1506
ORA-06512: at "APPS.MSC_MANAGE_PLAN_PARTITIONS", line 1433
ORA-06512: at line 1

May also see error as

MSCANAPP module: Analyze Plan Partition
+---------------------------------------------------------------------------+

Current system time is 10-JAN-2013 00:46:29

+---------------------------------------------------------------------------+

**Starts**10-JAN-2013 00:46:29
ORACLE error 12801 in FDPSTP

Cause:  FDPSTP failed due to ORA-12801: error signaled in parallel query server P007
ORA-08103: object no longer exists
ORA-06512: at "APPS.FND_STATS", line 1883
ORA-06512: at "APPS.MSC_MANAGE_PLAN_PARTITIONS", line 1433

 


STEPS TO REPRODUCE
Define two plan partitions
Define one plan as ATP plan
Setup to run 24x7 ATP according to the Users Guide
Set profile MSC: Scope of Analyze Plan Partition = All partitions (NOT the default setting of Plan
Partition only)
Launch the plan

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