OWBSYS Objects Become Invalid After Repository Optimization in 12.1.0.X Database (Doc ID 2080004.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The following OWBSYS objects become invalid after 'Optimize Repository' is executed from the OWB 11.2 Design Center:

OBJECT_NAME                            OBJECT_TYPE
------------------------------ -----------------------
OWBDELETION                           PACKAGE BODY
WB_WORKSPACE_MANAGEMENT PACKAGE BODY
WB_ENV_UTIL                            PACKAGE BODY

 

Same behavior observed after execution of Maintenance window

Changes

 Database was upgraded from 11.2 to 12.1.0.2

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