What is Workflow Notification mailer in R12

Processes that involve multiple users and the routing of data between the users are termed as 'WORKFLOW'.

What are Workflow Components: Workflow typically consist of 4 R’s

Rules : Rules are your company's business practices captured in software. Rules determine what activities are required to process your business data.

Roles : Roles describe how people fit into the workflow. A role is a class of users who perform the same type of work, such as clerks or managers. Your business rules typically specify what user role needs to do a specific activity. Roles allow work to be directed to Types of people than individuals hence allow flexible and easier to manitain Workflows.

Routings : Routings connect the activities in the workflow. They are the system's means of moving information from one place to another, from one step to the next. Routings specify where the information goes and what form it takes—based on results at decision point or responses to email message or completion of activity. Routings bring the flow into workflow. They get the right information to the right people at the right time, enabling users to work together to accomplish the company's goals.

Real Time : Real Time means Workflow should be able escalate an activity to next level action or role in case a certain activity is not executed in specific time, for example if the Department Manager doesn’t approve or reject the leave request within 48 hrs then it should be escalated to VP-HR.

WHAT CAN WORKFLOW DO : · Routes information to various users based on certain rules. · Tracks the responses from the users and takes actions accordingly. · Enables people to receive E-Mail notifications · Allows incorporation of custom packages and procedures · E-Mail integration of choice. · Internet enabled workflow allows you to view Workflow notifications through any Internet browser. · One can also monitor the processes through a browser.

Steps to start/stop notification mailer

1. Check workflow mailer service current status

bash-4.2$ sqlplus

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Apr 16 10:17:16 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: apps
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select running_processes
    from apps.fnd_concurrent_queues
   where concurrent_queue_name = 'WFMLRSVC';  2    3

RUNNING_PROCESSES
-----------------
                1


  Number of running processes should be greater than 0

2. Find current mailer status

  sqlplus apps/<apps password>
  select component_status
    from apps.fnd_svc_components
   where component_id = 
        (select component_id
           from apps.fnd_svc_components
          where component_name = 'Workflow Notification Mailer');

COMPONENT_STATUS ------------------------------ RUNNING  

Possible values:
  RUNNING
  STARTING
  STOPPED_ERROR
  DEACTIVATED_USER
  DEACTIVATED_SYSTEM

2. Stop notification mailer

  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;
  /

3. Start notification mailer

  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;
  /

Log location:-

$APPLCSF

$APPLLOG/FNDCPGSC*.txt

bash-4.2$ pwd

/uo1/oracle/prod/inst/apps/PROD_02/logs/appl/conc/log

bash-4.2$ ls -lrt FNDC*

-rw-r--r--    1
oracle   dba        28710170 Apr 11 08:52
FNDCPGSC167995.txt

-rw-r--r--    1
oracle   dba       779053450 Apr 11 08:52
FNDCPGSC167990.txt

-rw-r--r--    1
oracle   dba        58267057 Apr 11 08:52
FNDCPGSC167989.txt

-rw-r--r--    1
oracle   dba          344758 Apr 11 09:10
FNDCPGSC168589.txt

-rw-r--r--    1
oracle   dba        34715995 Apr 11 09:10
FNDCPGSC168588.txt

-rw-r--r--    1
oracle   dba          296340 Apr 11 09:10
FNDCPGSC168587.txt