My Oracle Support Banner

How to Address BIS Synonyms Violating SECTION 15 Of Online Patching Readiness Reports After Upgrading to 12.2? (Doc ID 2439346.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle E-Business Intelligence - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Goal

SECTION 15 of the "EBS Online Patching Database Compliance Checker" (ADZDDBCC.sql) shows 102 Synonyms belonging to the Applications BIS product that are violating the following standard:

"Synonym must point to an object."

Need to cleanup these violations so the report has meaningful data going forward.
Examples of Synonyms:

OWNER            SYNONYM_NAME                   TABLE_OWNER      TABLE_NAME
---------------- ------------------------------ ---------------- ------------------------------
APPS             MLOG$_EDW_FLEX_DIM10_L1_LT     BIS              MLOG$_EDW_FLEX_DIM10_L1_LT
APPS             MLOG$_EDW_FLEX_DIM10_L2_LT     BIS              MLOG$_EDW_FLEX_DIM10_L2_LT
APPS             MLOG$_EDW_FLEX_DIM11_L1_LT     BIS              MLOG$_EDW_FLEX_DIM11_L1_LT
APPS             MLOG$_EDW_FLEX_DIM11_L2_LT     BIS              MLOG$_EDW_FLEX_DIM11_L2_LT
APPS             MLOG$_EDW_FLEX_DIM12_L1_LT     BIS              MLOG$_EDW_FLEX_DIM12_L1_LT
APPS             MLOG$_EDW_FLEX_DIM12_L2_LT     BIS              MLOG$_EDW_FLEX_DIM12_L2_LT
APPS             MLOG$_EDW_FLEX_DIM13_L1_LT     BIS              MLOG$_EDW_FLEX_DIM13_L1_LT
APPS             MLOG$_EDW_FLEX_DIM13_L2_LT     BIS              MLOG$_EDW_FLEX_DIM13_L2_LT
APPS             MLOG$_EDW_FLEX_DIM14_L1_LT     BIS              MLOG$_EDW_FLEX_DIM14_L1_LT
APPS             MLOG$_EDW_FLEX_DIM14_L2_LT     BIS              MLOG$_EDW_FLEX_DIM14_L2_LT
APPS             MLOG$_EDW_FLEX_DIM15_L1_LT     BIS              MLOG$_EDW_FLEX_DIM15_L1_LT
APPS             MLOG$_EDW_FLEX_DIM15_L2_LT     BIS              MLOG$_EDW_FLEX_DIM15_L2_LT
APPS             MLOG$_EDW_FLEX_DIM16_L1_LT     BIS              MLOG$_EDW_FLEX_DIM16_L1_LT
APPS             MLOG$_EDW_FLEX_DIM16_L2_LT     BIS              MLOG$_EDW_FLEX_DIM16_L2_LT
APPS             MLOG$_EDW_FLEX_DIM17_L1_LT     BIS              MLOG$_EDW_FLEX_DIM17_L1_LT
APPS             MLOG$_EDW_FLEX_DIM17_L2_LT     BIS              MLOG$_EDW_FLEX_DIM17_L2_LT
APPS             MLOG$_EDW_FLEX_DIM18_L1_LT     BIS              MLOG$_EDW_FLEX_DIM18_L1_LT
...
 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.