Change the Home page data refresh frequency

The data on the Home page is refreshed in the background every 15 minutes. If you want to change the data refresh value, you need to run the dmeDashboardSchChg.sql script that came with Oracle DMW.

To run the script and change the refresh frequency value:

1. Copy $APPL_TOP/patch/115/sql/dmeStudyHealthSchChg.sql file from LSH MT Server to Database Server.
2. Log in to SQL*Plus (not SQL Developer) as the APPS database user.
3. To invoke the script, locate the directory with the script. Then enter:
   sqlplus <APPS database user name>/<APPS database user pwd>@<database name>
4. Enter this command to run the script:
   SQL> @dmeDashboardSchChg.sql
5. Enter the following:
   DEFINE Frequency in Minutes = <time in 15 minute intervals, for example 15 (default), 30, 45, 60>