My Oracle Support Banner

MSCANAPP: Analyze Plan Partition Is Failing With ORA-12801: Error Signaled In Parallel Query Server (Doc ID 2805359.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.


Analyze Plan Partition is failing with ORA-12801: error signaled in parallel query server

This started happening on daily basis since last week


MSCANAPP: Analyze Plan Partition


**SQL error and free**18-AUG-2021 09:04:10
ORACLE error 12801 in FDPSTP

Cause: FDPSTP failed due to ORA-12801: error signaled in parallel query server P006, instance xashe1p-vgtgc2:vcpprod2 (2)
ORA-08103: object no longer exists
ORA-06512: at "APPS.FND_STATS", line 2919
ORA-06512: at "APPS.MSC_MA18-AUG-2021 09:04:10

The issue can be reproduced at will with the following steps:
NAV: ASCP / Supply Chain Plan / Launch - pick plan name and submit
Analyze plan partition is one of the last requests in the set 



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

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