Your Doorstep to the Temple of Oracle

Oracle EBS

Failed to Enable Maintinence Mode

Posted by appsdba11i on January 2, 2012

Hi Folks

I recently got the issue. I am Failed to enable the maintaince mode in R12.
I got this error when i am trying

aiimToggleMaintenanceMode():Error while calling aiucm3().

or

declare
*
ERROR at line 1:
ORA-20000: ORA-24033: no recipients for messageFailed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling maintenance mode.
ORA-06512: at line 38

Solution
========
1)Take the Backup of fnd_profile_options

create table fnd_profile_option_values_bak as select * from fnd_profile_option_values ;


2. Identify the PROFILE_OPTION_ID That need to be updated

select profile_option_id from FND_PROFILE_OPTIONS
where PROFILE_OPTION_NAME =’APPS_MAINTENANCE_MODE’;

ex:

SQL> select profile_option_id from fnd_profile_options where profile_option_name =
‘APPS_MAINTENANCE_MODE’;
2
PROFILE_OPTION_ID
—————–
5791

3. Update the table FND_PROFILE_OPTION_VALUES via following update statement :

update FND_PROFILE_OPTION_VALUES set PROFILE_OPTION_VALUE = ‘MAINT’
where PROFILE_OPTION_ID=;

Ex: SQL> update fnd_profile_option_values set profile_option_value =’MAINT’ where
profile_option_id=’5791′;

1 row updated.

SQL> Commit;

Commit complete.

This Resolved the issue.

Other things That Needto Check
===============================
1) Compile Invalids (utrp & manually)
2) Try to swith to maintaincence mode

    Ref Notes: (Doc ID 376758.1)

Thanks
Reddy

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: