SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS
where COMPONENT_ID=10006;
Related Posts for Workflow
- Oracle Workflow Notification Mailer
- Workflow Notification Mailer Setup in Oracle Apps R12/12i
- Oracle Workflow Notification Mailer Outbound Processing
- How to update Workflow Administrator Role in Oracle Applications 11i/R12
- SQL to monitor (check status) of Workflow Notification Mailer (Java)
Popularity: 7% [?]
Download R12 VMware Documentation
Good hands-on exercises (installation, patching, cloning), very experienced trainer worth for Money 
3 users commented in " SQL to monitor (check status) of Workflow Notification Mailer (Java) "
Follow-up comment rss or Leave a TrackbackHi,
how i know in my server workflow notification mailer confugured or not
regards
raghu
SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS
where COMPONENT_ID=10006;
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.
Leave A Reply