Why Exceptions Occur In The 12.2 Online Patching Database Compliance Checker Report For An Upgrade (Doc ID 1940816.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2.3 [Release 12.2Cloud]
Information in this document applies to any platform.

Goal

Why the Online Patching Database Compliance Checker report lists exceptions for the following seeded E-Business Suite (EBS) database objects for an upgrade?


>  SECTION-25
>  **********
>  
>  "Column Type should not be ROWID"
OWNER            TABLE_NAME                                COLUMN_NAME      DATA_TYPE
---------------- -----------------------------              --------------  -----------------
CS                CS_SYSTEMS_ALL_B_TEMP                 ROW_ID           ROWID
INV               MTL_MOQD_BACKUP                         ROW_ID           ROWID
OPI              EDW_MTL_UOMD_UOM_LSTG              ROW_ID           ROWID



>  SECTION-32
>  **********

>  "Seed Data Table must have a unique index"
OWNER            TABLE_NAME
---------------- ------------------------------
HR               IRC_ALL_RECRUITING_SITES
IEX              IEX_XML_QUERIES
PA               PA_PAY_REJECTION_PRIORITY
PO               PO_DIFF_CONFIG
XTR              XTR_LAYOUT_WHERE_CLAUSE



>  SECTION-37
>  **********
>  "Index Key Size should be less than 3215"
:
OWNER            INDEX_NAME                                     TABLE_NAME                     I                 NDEX_KEY_LENGTH
---------------- ----------------------------------------------------------------------------------------------------------------------
CSM             CSM_DASHBOARD_SEARCH_COLS_U1  CSM_DASHBOARD_SEARCH_COLS        4032
EGO             EGO_PUB_BAT_HDR_B_U2                    EGO_PUB_BAT_HDR_B                         4001
PO               PO_LINES_ALL_EXT_B_N1                     PO_LINES_ALL_EXT_B                          4001
PO               PO_LINES_ALL_EXT_B_N2                     PO_LINES_ALL_EXT_B                          4001
PO               PO_LINES_ALL_EXT_B_N3                     PO_LINES_ALL_EXT_B                          4001
PO               PO_LINES_ALL_EXT_B_N4                     PO_LINES_ALL_EXT_B                          4001
PO               PO_LINES_ALL_EXT_B_N5                     PO_LINES_ALL_EXT_B                          4001





 

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