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.
Wikitechie 