My Oracle Support Banner

Instance Partition Corruption - Assigned Instance Partitions that are not in MSC_APPS_INSTANCES (Doc ID 2371760.1)

Last updated on MARCH 20, 2025

Applies to:

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

Symptoms

We have noticed that there is corrupt instance partition information on our instance.  There are assigned Instance Partitions that do not appear in the MSC_APPS_INSTANCES table per the following SQL statement:

 
We would like to clean this up to prevent errors when creating new instance partitions or running Data Collections programs.

Cause

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
Symptoms
Cause
Solution

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