SQL to monitor (check status) of Workflow Notification Mailer (Java)

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS
where COMPONENT_ID=10006;


 

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

5 comments
raghu says March 19, 2009

Hi,

how i know in my server workflow notification mailer confugured or not

regards

raghu

Reply
satheesh says July 5, 2009

SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS
where COMPONENT_ID=10006;

Reply
Swetha jammy says January 28, 2010

Hi,

I have a issue regarding notification mails in oracle iexpense.User’s email address,SMTP mapping and settings in iexpense everything looks fine.But, the user is not receiving the approval email when the expense report is approved. In the workflow notification, the mail status is showing as ‘FAILED’.
Note: To verify, I have send an test mailer and it worked fine.

Could you please help me with your thoughts on this and any sort of clue ismuch appreciable.

Thanks in advance,
Swetha Jammy.

Reply
Rene says January 27, 2011

select component_status from fnd_svc_components where component_name = ‘Workflow Notification Mailer’;

component_id has changed in my enviroment (=10010).

Reply
kakarla says April 12, 2011

what is mean by launch process plz to explain and another one how to add work flow process to front end in oracle apps plz to expain with screen shots

Reply
Add Your Reply

Not found