Instance Partition Corruption - Assigned Instance Partitions that are not in MSC_APPS_INSTANCES
Last updated on MARCH 09, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 22.214.171.124 and later
Information in this document applies to any platform.
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:
select * from MSC_INST_PARTITIONS
where INSTANCE_ID not in (select INSTANCE_ID from MSC_APPS_INSTANCES)
and FREE_FLAG = 2
We would like to clean this up to prevent errors when creating new instance partitions or running Data Collections programs.
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