Is there any table where Oracle APEX usage log is stored

Question

I was just wondering if there is any standard table , where we can see which user has accessed which report in Oracle APEX, based on date and time. Basically the audit history ?

I can do it by inserting the needed data in a custom table but, is there any standard way, where we have all this information?

Regards,

Abha

Answer 1

Oracle APEX has indeed internal tables where it stores all of this information. The name of the view to have insight into this data is apex_workspace_activity_log.

select s.workspace,
       s.apex_user,
       s.application_id,
       s.application_name,
       s.page_id,
       s.page_name,
       s.view_date,
       s.apex_session_id
from   apex_workspace_activity_log s
/

Here you can see WHO accessed a page, WHAT page has been accessed and WHEN that page has been accessed (date and time). This is not on individual report level, as you asked for, but at least you can see it on page level.

Use following views to see what report exists on which page and join that information as you like.

apex_application_page_rpt
apex_application_page_ir
apex_appl_page_igs