My Oracle Support Banner

azhSelSetSchema.sql fail when DataBase is 19C (Doc ID 2816670.1)

Last updated on OCTOBER 28, 2021

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 version, Upgrade related issues

On : 12.2 version, Upgrade related issues

When attempting to apply 12.2.0 upgrade driver patch,
the following error occurs.

ERROR
-----------------------
Start time for file is: Fri Oct 22 2021 18:37:56

sqlplus -s <APPS_USER>/<APPS_PWD> @$AD_TOP/patch/115/sql/adsqlwrapper.sql '@$AZ_TOP/patch/115/sql/azhSelSetSchema.sql &systempwd'
Connected.

PL/SQL procedure successfully completed.

Connected.
declare
*
ERROR at line 1:
ORA-20101: Exception occurred in Selection Set Schema Registration procedure
:ORA-64479: element 'AZ_SELSETS_V' is missing 'SQLType' annotation; schema
cannot be registered by common users
ORA-06512: at line 92



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply the newly merged 12.2.0 upgrade driver

$ adpatch options=nocopyportion,nogenerateportion

OR
Performing step from note: How To Cleanup Invalid Oracle iSetup (AZ) Tables And Recreate (Doc ID 832459.1)

Changes

 Data Base was upgraded to 19C

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.