Oracle Application Express (MOSC)

MOSC Banner

Application Express Reporting Period is only 2 weeks by default. How can I report for more than 2 w

edited May 27, 2014 12:00PM in Oracle Application Express (MOSC) 3 commentsAnswered

Within Application express, I need to do utilization reports and monitor activity that extends over 2 weeks.  It appears the wwv_flow_activity_log2$ table is setup to automatically remove data that is over two weeks.  So if I try to run a report for a month, it only reports data from the past 2 weeks.  Does anyone know if there is an oracle approved way to extend this 2 week period to a month or more? 

As an option I can create another table which contains all the data but this does not allow me to use the oracle apex reports that are setup within the workspace. 

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