How to Start Notification Mailer ?

[rohanora]

Hi ,
I am trying to Start/ Implement the Notification Mailer for for UNIX Sendmail For the Version of Oracle Workflow Embedded in Oracle Applications.

I created the Configuration File for the Notification Mailer
Wfmail.cfg. , i.e I set the required parameters.

And next I ran the Notification Mailer concurrent program from the command line.
Enter:

WFMAIL apps/pwd 0 Y FILE config_file


Eg : WFMAIL apps/apps 0 Y ./wfmail.cfg

It gave an error , about advanced queue not enabled .
so i used the command to enable it :

execute DBMS_AQADM.start_queue('APPLSYS.WF_SMTP_O_1_QUEUE ',TRUE,TRUE);

And now I again tried to run the command :

WFMAIL apps/apps 0 Y ./wfmail.cfg ,


but it just hangs without showing any Successfully completed prompt.


I am refering the Oracle Apps Workflow document to Start the Notification Mailer.

Does anyone have a better document or solution to my problem ?

In fact , if someone has a prepared a document , about the steps to follow to start the Notification Mailer for UNIX Sendmail For the Version of Oracle Workflow Embedded in Oracle Applications , then pls fwd it to :

rohan_rege@rediffmail.com

or atleast provide some useful tips....


regards,
Rohan