My Oracle Support Banner

12.2 E-Business Suite Upgrade Tool Database Compliance Checker (ADZDDBCC.sql) Reports Invalid Objects After the Online Patching Enablement Patch (13543062:R12.AD.C) Is Applied At The 12.2.0 Level (Doc ID 2389640.1)

Last updated on APRIL 26, 2018

Applies to:

Oracle Inventory Management - Version 12.2 to 12.2 [Release 12.2]
Oracle Shipping Execution - Version 12.2 to 12.2 [Release 12.2]
Oracle Purchasing - Version 12.2 to 12.2 [Release 12.2]
Oracle iSupplier Portal - Version 12.2 to 12.2 [Release 12.2]
Oracle Warehouse Management - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Goal

E-Business Suite 12.2 Applications DBA, Online Patching ADOP Utilities related issues

 

 

 

 

 

 

 

After an instance upgrade from 12.1.3 to 12.2.0 and the installation of Online Patching Enablement patch (13543062:R12.AD.C), the Database Compliance Checker (ADZDDBCC.sql) shows invalid objects in different functional E-Business Suite products (INV, WMS, OM, WSH, PO...):

OWNER           OBJECT_NAME
---------------- -----------------------------
APPS              CZ_IMP_SINGLE
APPS              EAM_FORECAST_PVT
APPS              EAM_PROCESS_FAILURE_ENTRY_PVT
APPS              INV_CALCULATE_EXP_DATE
APPS              INV_LOT_API_PKG
APPS              INV_LOT_TRX_VALIDATION_PUB
APPS              INV_PHY_INV_LOVS
APPS              INV_REPLENISH_DETAIL_PUB
APPS              INV_RESERVATION_AVAIL_PVT
APPS              INV_RESERVATION_FORM_PKG
APPS              INV_RESERVATION_PVT
APPS              MSC_DRP_UTIL
APPS              MSC_PQ_UTILS
APPS              MSC_UI_PEG_UTIL
APPS              OE_RELATED_ITEMS_PVT
APPS              POS_SUPP_APPR
APPS              PO_CHANGE_RESPONSE_PVT
APPS              PO_CONTROL_ACTION_VALIDATIONS
APPS              PO_CONTROL_ACTION_VALIDATIONS
APPS              PO_DIFF_SUMMARY_PKG
APPS              PO_DOCUMENT_ACTION_AUTH
APPS              PO_DOCUMENT_CONTROL_PUB
APPS              PO_DOCUMENT_REVISION_GRP
APPS              PO_DOCUMENT_UPDATE_GRP
APPS              PO_INQ_SV
APPS              PO_PDOI_DISTRIBUTIONS_SV3
APPS              PO_REQAPPROVAL_FINDAPPRV1
APPS              PO_UOM_S
APPS              PO_VAL_DISTRIBUTIONS2
APPS              WMS_RETURN_SV
APPS              WMS_TASK_DISPATCH_LOV
APPS              WSH_U_CSPV
APPS              WSH_U_GTT
APPS              WSH_U_RASS
APPS              WSH_U_TRACK
APPS              WSH_WV_UTILS

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!


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