Find Workflow Notification Mailer

SQL> SELECT email_address,name, nvl(WF_PREF.get_pref(name, 'MAILTYPE'),notification_preference)FROM wf_rolesWHERE name like upper('%xxx%');

SQL> select NOTIFICATION_ID,STATUS,MAIL_STATUS from WF_NOTIFICATIONS where TO_USER='UserName';

SQL> SELECT status,mail_status,MESSAGE_TYPE,MESSAGE_NAME,ITEM_KEY from WF_NOTIFICATIONS WHERE notification_id='2732013';

SQL> select mail_status,count(*) from WF_NOTIFICATIONS group by mail_status;


COLUMN CORRID FORMAT A55;
COLUMN STATE FORMAT A14;
SELECT CORRID,DECODE(STATE, 0, '0 = READY', 1, '1 = DELAYED', 2, '2 = PROCESSED', 3, '3 = EXCEPTION',TO_CHAR(STATE)) STATE, COUNT(*) COUNT
FROM WF_DEFERRED
GROUP BY CORRID, STATE;


SET LINES 150
COLUMN CORRID FORMAT A55;
COLUMN STATE FORMAT A14;
SELECT CORRID,DECODE(STATE, 0, '0 = READY', 1, '1 = DELAYED', 2, '2 = PROCESSED', 3, '3 =
EXCEPTION',TO_CHAR(STATE)) STATE, COUNT(*) COUNT
FROM WF_NOTIFICATION_OUT
GROUP BY CORRID, STATE;


COL COMPONENT_NAME FORMAT A60
COL COMPONENT_STATUS FORMAT A20
COL STARTUP_MODE FORMAT A20
SET LINES 120
SET PAGES 1000
SELECT COMPONENT_NAME, COMPONENT_STATUS, STARTUP_MODE FROM FND_SVC_COMPONENTS;


SET LINES 160
COL COMPONENT_NAME FORMAT A30
COL PARAMETER_NAME FORMAT A40
COL PARAMETER_VALUE FORMAT A40
SELECT A.COMPONENT_ID, A.COMPONENT_NAME, B.PARAMETER_ID, C.PARAMETER_NAME, B.PARAMETER_VALUE
FROM FND_SVC_COMPONENTS A, FND_SVC_COMP_PARAM_VALS B, FND_SVC_COMP_PARAMS_B C
WHERE A.COMPONENT_ID = B.COMPONENT_ID AND B.PARAMETER_ID = C.PARAMETER_ID
AND UPPER(A.COMPONENT_NAME) LIKE '%MAILER%'
ORDER BY A.COMPONENT_ID, A.COMPONENT_NAME, C.PARAMETER_NAME;

11 comments:

Bhaskara Bangaru said...

Dear Ramesh,

good information sharing.
thanks for that.
I have one question.
we upgraded 10.2.0.3 to 10.2.0.4 (RAC). But in OEM showing version 10.2.0.3

Regards
Bhaskara

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

flowers to india said...

We can deliver flowers,cakes,chocolates and gift items to over
32 countries worldwide on the same day. Our wide network of florists,
quality assurance and timely delivery ensure that our
customers are satisfied. Having serviced over a million customers worldwide,
our company gives a customer the power to express their emotions through flowers.



http://www.flowersfloristsgifts.com
http://www.flowersnfloristsindia.com
http://www.flowersnflorists.com/
http://www.floristonlineindia.com/
http://www.onlinefloristindia.com
http://www.indiafloristshop.com/
http://www.giftgiftstoindia.com
http://www.floristindianetwork.com/
http://www.bloomonlineindia.com/
http://www.indiacakesonline.com
http://www.giftflowersindia.com
http://www.flowerstochennai.com
http://www.indiaflowerwala.com
http://www.bangaloregiftsflower.com
http://www.sendflowerspunjab.com
http://www.sendfreshflowersindia.com/
http://www.allindiagift.com
http://www.indiachocolatedelivery.com/
http://www.keralaflorist.com
http://www.indiafloristonline.com
http://www.globalflowerdelivery.com
http://www.indianonlineflorist.com
http://www.giftsvalentine.com
http://www.mumbaigiftsflowers.com
http://www.chennaigiftsflowers.com
http://www.hyderabadgiftsflowers.com
http://www.punegiftsflowers.com
http://www.floristbangalore.com
http://www.delhiflorists.com
http://puneflowerdelivery.com
http://www.goaflorist.com
http://www.delhigiftsflowers.com
http://www.delhiflorists.com
http://www.indianonlineflorist.com
http://www.indiacakedelivery.com
http://www.giftsvalentine.com
http://www.puneflowerdelivery.com
http://www.goaflorist.com

Flowers N Wishes said...

Send Flowers to Chandigarh

Send Flowers to Chennai

Send Flowers to Ludhiana


Send Flowers to Kolkata

Send Flowers to Jalandhar
Send Flowers to Jaipur


Send Flowers to Hyderabad

Send Flowers to Gurgoan

Send Flowers to Delhi
Send Flowers to Mumbai

Send Valentine Gifts to India

rupinder said...

Send Cakes to India
Flowers N Wishes offers delicious, appealing and tempting cakes & chocolates for all occasions and in various shapes and sizes. Online cakes & chocolates to India have never been so easy. With our online ordering system cakes & chocolates can be delivered in all the cities in India. Simply order your cake & chocolates online and we will deliver Cakes & Chocolates to your loved ones in all the cities in India.

rightshopping86 said...

The visit was useful. Content was really very informative. From www.rightshopping.in

chennaicakesdelivery said...

This is great blog keep it up.Thanks for sharing.
from - chennaicakesdelivery.com

http://www.chennaiflowers.com said...

Flowers to Chennai delivery are free, safe and secured with www.chennaiflowers.com. We being Local Flower Shop are cheaper than other florists in Chennai. We deliver fresh Flowers, Cakes, Sweets and other gifts on door, you can order online to send flowers to Chennai .

Puneflowersdelivery said...

Send flowers to Pune, flowers to Pune delivery,flowers to Pune,Pune flowers delivery, flowers Pune, Online flowers to Pune.

Flowersbangalore said...

Flowers to Bangalore, send flowers online to Bangalore, buy fresh flowers on Birthday, get delivered Wedding flowers, Anniversary flowers, Condolence flowers, send same day flowers to Bangalore online with us.

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.