Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 11:

When trying to enable maintenance mode it failed to change the profile option value:

Please select an option:

 

   1.    Enable Maintenance Mode

 

   2.    Disable Maintenance Mode

 

   3.    Return to Main Menu

 

 

 

Enter your choice [3] : 1

 

sqlplus -s &un_apps/***** @/u03/dproappl/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE

 

An error occurred while running adsetmmd.sql.

Continue as if it were successful [No] :

 

Solution:

SQL> create table fnd_profile_option_values_bak as select * from fnd_profile_option_values ;

 

Table created.

 

SQL>

 

SQL> select profile_option_id from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME ='APPS_MAINTENANCE_MODE';

 

PROFILE_OPTION_ID

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

                     5791

 

SQL>

 

SQL> col PROFILE_OPTION_VALUE for a25

select APPLICATION_ID,PROFILE_OPTION_ID,PROFILE_OPTION_VALUE from fnd_profile_option_values where profile_option_id='5791';

 

APPLICATION_ID PROFILE_OPTION_ID PROFILE_OPTION_VALUE

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

                     0                             5791 NORMAL

 

SQL> update fnd_profile_option_values set profile_option_value ='MAINT' where profile_option_id='5791';

 

1 row updated.

 

SQL> commit;

 

Commit complete.

 

SQL> select APPLICATION_ID,PROFILE_OPTION_ID,PROFILE_OPTION_VALUE from fnd_profile_option_values where profile_option_id='5791';

 

APPLICATION_ID PROFILE_OPTION_ID PROFILE_OPTION_VALUE

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

                     0                             5791 MAINT

 

SQL>