My Oracle Support Banner

ADZDDBCC Shows Violation for Section 19 EBS_UTLFILE_PARAM AND EBS_UTLFILE_PARAM2 UNDER APPS Post Upgrade of 19c EBS DB from 12.1.3 to 12.2.9 (Doc ID 2823792.1)

Last updated on APRIL 19, 2022

Applies to:

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

Symptoms

On : 12.2.10 version with DB 19c , Upgrade related issues

1) Run the $AD_TOP/sql/ADZDDBCC.sql script 


2) adzddbcc.lst has SECTION-19 [full] - Table must be owned by an EBS product schema, not APPS.

The EBS_UTLFILE_PARAM, EBS_UTLFILE_PARAM2 are standard tables which are still listed in the output of the script after performing the post-upgrade-steps

Changes

Upgrading 19c EBS DB from 12.1.3 to 12.2.10, the output of ADZDDBCC.sql shows below tables in SECTION-19 as violation

  EBS_UTLFILE_PARAM

  EBS_UTLFILE_PARAM2

File version of ADZDDBCC.sql  is 120.13.12020000.82 2020/03/17 22:45:53 

Cause

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
Symptoms
Changes
Cause
Solution
References


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