How to Enable Maintance Mode In R12 APPS?

How to Enable Maintance Mode In R12 APPS? 

During a patch application the recommended option is to Enable Maintenance node.When adsetmmd.sql runs, it sets the Profile Option ‘Applications Maintenance Mode’ (APPS_MAINTENANCE_MODE) to ‘MAINT’ to Enable ‘Maintenance Mode’ and to ‘NORMAL’ to Disable it.When you Enable or Disable ‘Maintenance Mode’, adadmin will execute the script.

sqlplus -S  apps/*****
@$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

sqlplus -S  apps/*****
@$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

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 has been Enabled and the Users will not be able to Login. If the query returns ‘NORMAL’ then Maintenance Mode has been De-Activated and the Users will be able to use the application.