Why Exceptions Occur In The 12.2 Online Patching Database Compliance Checker Report For An Upgrade
(Doc ID 1940816.1)
Last updated on FEBRUARY 16, 2023
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
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 |
| References |