Oracle Application Express (MOSC)

MOSC Banner

ORA-20001: COMPILE FAILURE: PACKAGE BODY SYS.WWV_FLOW_KEY after install APEX 5.1.4

edited Sep 27, 2021 4:34PM in Oracle Application Express (MOSC) 2 commentsAnswered ✓
Hi everyone,

I installed APEX 5.1.4 on my database 12.1.0.2 and i got this error after validating:

...(11:25:37) Starting validate_apex for APEX_050100
...(11:25:38) Checking missing sys privileges
...(11:25:38) Recompiling SYS
...(11:25:43) Checking for objects that are still invalid
ORA-20001: COMPILE FAILURE: PACKAGE BODY SYS.WWV_FLOW_KEY
...1/30     PL/SQL: Item ignored
...1/30     PLS-00305: previous use of 'G_KEY' (at line 1) conflicts with this
use
...(11:25:43) Key object existence check
ORA-20001: FAILED status check for SYS.WWV_FLOW_KEY: INVALID
...(11:25:43) Setting DBMS registry for APEX to INVALID
...(11:25:44) Exiting validate_apex

PL/SQL procedure successfully completed.

-----------------------------

If I validate the APEX schema, it is shown as invalid

SQL> select comp_id,version,status,schema from dba_registry where comp_id='APEX';
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center