KU$ Invalid Objects Owned By SYS After Applying April 2017 Critical Patch Update

(Doc ID 2289785.1)

Last updated on MARCH 26, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

KU$ objects remains invalid in SYS schema after applying April 2017 Critical Patch Update:

OWNER OBJECT_NAME OBJECT_TYPE
---------- ------------------------------ ---------------
SYS KU$_M_VIEW_H_VIEW VIEW
SYS KU$_ZM_VIEW_H_VIEW VIEW
SYS KU$_M_VIEW_PH_VIEW VIEW
SYS KU$_ZM_VIEW_PH_VIEW VIEW
SYS KU$_M_VIEW_FH_VIEW VIEW
SYS KU$_ZM_VIEW_FH_VIEW VIEW
SYS KU$_M_VIEW_PFH_VIEW VIEW
SYS KU$_ZM_VIEW_PFH_VIEW VIEW
SYS KU$_M_VIEW_IOT_VIEW VIEW
SYS KU$_ZM_VIEW_IOT_VIEW VIEW
SYS KU$_M_VIEW_PIOT_VIEW VIEW
SYS KU$_ZM_VIEW_PIOT_VIEW VIEW
SYS KU$_M_ZONEMAP_H_VIEW VIEW
SYS KU$_M_ZONEMAP_PH_VIEW VIEW
SYS KU$_M_ZONEMAP_FH_VIEW VIEW
SYS KU$_M_ZONEMAP_PFH_VIEW VIEW
SYS KU$_M_ZONEMAP_IOT_VIEW VIEW
SYS KU$_M_ZONEMAP_PIOT_VIEW VIEW

18 rows selected.

Note: The issue can also be seen after applying other patches, including the OCT 2017 Bundle Patch and the JAN2018 PSU.

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