My Oracle Support Banner

APEX - ORA-12012: Error On Auto Execute Of Job "APEX_190200"."ORACLE_APEX_DICTIONARY_CACHE" (Doc ID 2622827.1)

Last updated on DECEMBER 20, 2019

Applies to:

Oracle Application Express (APEX) - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

On : APEX 19.2 version, Administration

Once a day the following error occurs in the Database alert log.

ERROR
-----------------------
ORA-12012: error on auto execute of job "APEX_190200"."ORACLE_APEX_DICTIONARY_CACHE"
ORA-06564: object XXMID_UMR_IMPORT_ARCHIVE does not exist
ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 1709
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 1516
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 2086
....

 

OR the below error when some PSE (from before Dec 18,2019 ) has been applied

ERROR
-----------------------
ORA-12012: error on auto execute of job "APEX_190200"."ORACLE_APEX_DICTIONARY_CACHE"
ORA-00001: unique constraint (APEX_190200.WWV_DICTIONARY_CACHE_OBJ_IDX1) violated
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 2731
ORA-06512: at "APEX_190200.WWV_DICTIONARY_CACHE_DEV", line 3539
...



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade APEX to 19.2
2. Review the DB alert logs next days and subsequent ones

Changes

 Upgrade to APEX 19.2

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


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