Search

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

MAILHTM2 HTML mail

SUMMARY Plain text summary mail

SUMHTML HTML summary mail

DISABLED Disabled




5 views0 comments

Recent Posts

See All

Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set serveroutput on format wrapped set def off set tab off exec dbms_metad

Cancelled scheduled concurrent requests

This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for identifying scheduled requests that failed to be resubmitted. select

Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_na