Monthly Archives: January 2012

Determining if Maintenance Mode is Running

A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this Profile Option as follows: sqlplus apps/apps SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual; If the query returns ‘MAINT’, then Maintenance Mode … Continue reading

Posted in APPS DBA, Patch | Leave a comment