Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Steps to start/stop Workflow Notification Mailer from sqlplus

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Steps to start/stop Workflow Notification Mailer from sqlplus

    Steps to start/stop Workflow Notification Mailer

    Step 1. Check workflow mailer service current status
    sqlplus apps/<apps password>
    select running_processes from fnd_concurrent_queues
    where concurrent_queue_name = 'WFMLRSVC';
    Please Note : Number of running processes should be greater than 0

    Step 2. Find current mailer status

    To check the status of notification mailer, we need to do the following.

    sqlplus apps/<apps password>

    select component_status
    from fnd_svc_components
    where component_id =
    (select component_id
    from fnd_svc_components
    where component_name = 'Workflow Notification Mailer');

    Possible values are :
    RUNNING
    STARTING
    STOPPED_ERROR
    DEACTIVATED_USER
    DEACTIVATED_SYSTEM

    Step 3. Stop notification mailer

    To stop notification mailer , we need to execute the following.

    sqlplus apps/<apps password>

    declare
    p_retcode number;
    p_errbuf varchar2(100);
    m_mailerid fnd_svc_components.component_id%TYPE;
    begin
    -- Find mailer Id
    ------------------------------
    select component_id into m_mailerid from fnd_svc_components
    where component_name = 'Workflow Notification Mailer';
    -- Stop Mailer
    ------------------------
    fnd_svc_component.stop_component(m_mailerid, p_retcode, p_errbuf);
    commit;
    end;
    /

    Step 4. Start notification mailer

    To start notification mailer, we need to execute the following.

    sqlplus apps/<apps password>

    declare
    p_retcode number;
    p_errbuf varchar2(100);
    m_mailerid fnd_svc_components.component_id%TYPE;
    begin
    -- Find mailer Id
    -----------------
    select component_id
    into m_mailerid
    from fnd_svc_components
    where component_name = 'Workflow Notification Mailer';
    --------------
    -- Start Mailer
    -----------------
    fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);
    commit;
    end;
    /
    Last edited by Hemant; 12-14-2011 at 11:55 PM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Thanks Amit for this Wonderful Post , on how we can start the Workflow Nitification Mailer manually from Sqlplus

+ Reply to Thread

Similar Threads

  1. How to test SMTP and IMAP for the Workflow Notification Mailer
    By Hemant in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 07-04-2012, 12:43 AM
  2. can anyone provide me script to know the pending notification in oracle wf mailer
    By deviilm17 in forum SCRIPTS : Concurrent Manager and Workflow
    Replies: 2
    Last Post: 11-12-2011, 04:38 PM
  3. Sequence to Start and Stop RAC Services
    By Hemant in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-04-2011, 06:07 PM
  4. Start ,Stop,Enable,Disable Clusterware Processes / Daemons in Oracle RAC
    By Hemant in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-04-2011, 01:01 PM
  5. Retrieve the log file of active workflow mailer and workflow agent listener Container
    By Hemant in forum SCRIPTS : Concurrent Manager and Workflow
    Replies: 0
    Last Post: 11-01-2011, 09:47 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics