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.
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.
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'
PL/SQL procedure successfully completed.
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
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
Performing step from note: How To Cleanup Invalid Oracle iSetup (AZ) Tables And Recreate (Doc ID 832459.1)
Data Base was upgraded to 19C
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