ORA-20000 APPS_DDL/APPS_ARRAY_DDL Package(s) Missing Or Invalid In Schema CTXSYS

When attempting to apply a Patch the following error occurs:

sqlplus -s APPS/***** @$AD_TOP/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_icx ICX

User altered.

ERROR at line 1:
ORA-20000: APPS_DDL/APPS_ARRAY_DDL package(s) missing or invalid in schema
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 19

The issue is caused by the missing AD_DLL object in the Database. Please execute following script, to verif

sqlplus apps/<pwd>

SELECT owner, object_name FROM all_objects
WHERE object_name= 'AD_CTX_DDL'
AND object_type = 'PACKAGE';

select owner,SYNONYM_NAME from dba_synonyms
where table_owner='CTXSYS' and TABLE_NAME='AD_CTX_DDL';


To implement the solution, please execute the following steps :

1. Execute the script adctxpkg.sql located under the $AD_TOP/patch/115/sql directory to create the AD_CTX_DDL package:

sqlplus APPS/<Password> @adctxpkg.sql <SYSTEM Password> CTXSYS APPS

If you like please follow and comment