My Oracle Support Banner

ORA-12012 / ORA-01031 Errors Related To ORACLE_APEX_MAIL_QUEUE After Database Vault Implementation (Doc ID 2721805.1)

Last updated on FEBRUARY 18, 2021

Applies to:

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

Symptoms

Getting the following errors after Database Vault implementation:

Errors in trace file:
ORA-12012: error on auto execute of job "APEX_190200"."ORACLE_APEX_MAIL_QUEUE"
ORA-01031: insufficient privileges
ORA-06512: at "APEX_190200.WWV_FLOW_PLATFORM", line 195
ORA-06512: at "APEX_190200.WWV_FLOW_PLATFORM", line 223
ORA-06512: at "APEX_190200.WWV_FLOW_MAIL", line 115
ORA-06512: at line 1

No issue/errors if Database Vault is disabled.

Changes

 Enabled Database Vault.

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.