Changing Maintanence Windows in R12 for Patching

How to Enable Maintance Mode In R12 APPS? E-Business Suite 11i & R12, 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.

Reference Link http://myappsdba.com/how-to-enable-maintance-mode-in-r12-apps/ http://khurramlogix.blogspot.com/2012/01/ebs-r12-maintenance-mode-adadmin-by.html