How To Deselect Greyed Out OWB Locations in a Control Center (Doc ID 886293.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Goal

Before dropping a Control Center, all Locations that are member of the Control Center should be unregistered else the OWB Design Client will not allow to drop a Control Center.

After having unregistered all Locations, it might happen that users still find some Locations greyed out in the Control Center. In this situation OWB Design Client will still not allow to drop a Control Center.

This note explains how to remove such greyed out locations from "Available Locations" in a Control Center.

Note: The script in this note should only be used when "unregister" of the Location from the Control Center Manager does not help.

Solution

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