Mail Preferences

-- Change user name to whatever you need

update fnd_user_preferences

set preference_value = 'MAILHTM2'

where preference_name = 'MAILTYPE'

and module_name = 'WF'

and user_name = 'SYSADMIN';

If user mail preference does not exist:

-- Change SYSADMIN to whatever you need

insert into fnd_user_preferences (user_name, module_name, preference_name, preference_value) values ('SYSADMIN', 'WF', 'MAILTYPE', 'MAILHTM2');

-- Change role name to whatever you need

update wf_local_roles

set notification_preference = 'MAILHTM2'

where name = 'SYSADMIN';

A list of mail preference values:

QUERY Do not send me mail

MAILTEXT Plain text mail

MAILATTH Plain text mail with HTML attachments

MAILHTML HTML mail with attachments


SUMMARY Plain text summary mail

SUMHTML HTML summary mail


5 views0 comments

Recent Posts

See All

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con

INCLUDE parameter of expdp

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')" -- Export one table expdp user/password include=table:"i

Multiplexing Redo Log and Control files

-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#, members, status from v$log; -- Adding redo log file to a group alter d