Thursday, July 26, 2007

How to determine Workflow Mailer status without using OAM

I had an interesting question from my friend the other day.

How can you determine the availability of WF Mailer without using OAM?

The following query provides the status, eliminating the need to use OAM.

SELECT Component_name, Component_Status
FROM FND_SVC_COMPONENTS
WHERE component_type = 'WF_MAILER'

Reference: Metalink Doc: 316352.1

No comments: