Maintenance Mode in Oracle EBS R12.1.3

 

How to Enable/DISABLE Maintenance Mode in Oracle EBS R12.1.3

Login with Application OS user.

Conn  with apps.

$ sqlplus apps/****

$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE 

$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

sending the parameter 'ENABLE' or 'DISABLE'

How to verify Enable/DISABLE Maintenance Mode

 $ sqlplus apps/****

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual; 

     FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')

    ----------------------------------------------------------------------------

     NORMAL

The above query will return MAINT (maintenance mode is ENABLE) 

The above query will return NORMAL (maintenance mode is DISABLE)