APEX Troubleshooting

Status

If status is INVALID...

SELECT text 

  FROM user_source 

 WHERE name = 'VALIDATE_APEX' 

   AND INSTR(text,'select user#') > 0;

Ouptut should be similar to...

select user# into l_owner# from sys.user$ where name = 'APEX_040200';

If you get this instead...

select user# into l_owner# from sys.user$ where name = '^3';

then do this to fix...

cd ${APXDIR}  # Should be set in .profile

sqlplus / as sysdba

set define '^'

@apexvalidate x x APEX_XXXXXX   

(Where APEX_XXXXXX represents the current APEX schema. For example, APEX_040200)

exec validate_apex; 

Workspace Activity Log

The APEX Workspace Activity log is stored in the database as APEX_WORKSPACE_ACTIVITY_LOG.

Number of columns may vary depending on the APEX version. Most important:

Login as SYSTEM:

Bibliography

Application Express App Builder User's Guide https://docs.oracle.com/cd/E71588_01/HTMDB/running-advisor-to-check-application-integrity.htm (Release 5.1 BETA)
APEX Installation Verification Scripthttps://support.oracle.comAPEX Installation Verification Script (Doc ID 1254932.1)