My Oracle Support Banner

How To Remove Data From MSC Tables For Disabled Organizations? (Doc ID 1572391.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Goal

Information in MSC_SYSTEM_ITEMS table is still visible on Collection (Plan_id = -1) for organizations that were disabled.  Users require that item information on MSC_SYSTEM_ITEMS gets clean up for all organization that have been removed from Collections
(Menu Admin -> Instances -> Organization -> Search Org -> Uncheck Enabled)  Is there an standard process to remove the information for those organizations?
 

Solution

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.