Instance Partition Corruption - Rows in MSC_APPS_INSTANCES that are not in MSC_INST_PARTITIONS

(Doc ID 2374147.1)

Last updated on MARCH 15, 2018

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 rows in the MSC_APPS_INSTANCES that are not in MSC_INST_PARTITIONS table per the following SQL statement:

select * from MSC_APPS_INSTANCES
where INSTANCE_ID not in (select INSTANCE_ID from MSC_INST_PARTITIONS)

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

Changes

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