Showing posts with label Oracle Workflow. Show all posts
Showing posts with label Oracle Workflow. Show all posts

Sunday, May 13, 2018

R12 Workflow Notification Mailer Configuration


The main component of the Oracle Workflow Notification Mailer is the executable
WFMAIL. This is a server side program that queries the database for any pending
notifications. It then dispatches these notifications by calling sendmail for UNIX and the MAPI APIs for Microsoft Windows NT. The notification mailer also queries the local inbox for incoming messages. These messages are validated and then passed to the database for response processing. To configure Workflow Notification Mailer we have to do OS level setup (Sendmail) and Application level setup.

1.) Sendmail should be installed by default when you install RedHat Linux. If it is not then you need to install the Sendmail RPM’s with the Red Hat distribution .

2.) we need to configure a means for the user to retrieve any emails that are waiting for them on the server. One of the packages that do this is dovecot, which handles POP and IMAP mailboxes in clear text or with link encryption (POPS and IMAPS); IMAPS is the preferred mail protocol for MUAs.

3.) There are two kinds of Notification Outbound & Inbound in Workflow Mailer
  For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
  For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.

4.) Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer Service, Workflow Agent Listener Service)

5.)Schedule the Workflow Background process, Notification Mailer concurrent requests 

6.) Select Workflow Manager in OAM from pull down menu once you login to OAM.
7.) Click Notification Mailer status icon to navigate to the Service Component page for Notification Mailers. Status of Notification Mailers is down.
8.) Select Workflow Notification Mailer Service component under Service Components page. Click edit to access Notification Mailer Configuration wizard.
9.) Enter the name of the SMTP MAIL SERVER information under Outbound Email Account region.
10.) Select the Inbound Processing parameter in Inbound Mail Email Account (IMAP)region to enable inbound email processing. Enter name of the inbound IMAP mail server, the username and passwd of the email account that the Notification Mailer uses to receive email messages,and the reply-to address of the mail account which receive incoming messages to which notification responses should be sent.
6. Confirm the changes by clicking apply. Now check the status of the Workflow Notification Mailer service component is runing on Service components page

Friday, August 4, 2017

Workflow agent listener

Web Path :
Path to the applications dashboard is 
 System Administrator >Oracle Applications Manager>Workflow Manager









EBS Path :

Here’s the steps to bounce the WF Agent Listener 

1.       Navigate
System Administrator-> Concurrent : Manager -> Administer

2.       Restart Workflow Agent Listener
<F11 Enter Query> -> Query “Workflow Agent Listener Service” -> Click on Restart

3.       Check Restart is completed successfully
Query “Workflow Agent Listener Service” until you both Actual and Target processes are back to “1


  System Administrator ->Concurrent -> Manager ->Adminster
  Query for  ' Workflow% '
Workflow Agent Listener Service
Workflow Mailer Service
Workflow Document Web Services Service

Restart -> To restart the services
Process -> To check the status ( terminated,active,deactivated)



Log file location 

ls -lrt $APPLCSF/$APPLLOG/FNDCPGSC*.txt

/ENV/shared/applcsf/log


Issues :
If see error in log file like below

GenCartCommException: ORA-01403: no data found
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 539
ORA-06512: at line 1

Check the below values in EBS
   Actul and Target : Macth (1,1 or 0,0) - UP
  Actul and Target  :  Mismatch (1,0 ) - Terminate and Activate .



Thursday, June 1, 2017

 Workflow Mailer  & Agent Listener Service

select mail_status, count(*) from apps.wf_notifications
where
--status = 'OPEN'
BEGIN_DATE > sysdate - 1
--and mail_status in ('MAIL','ERROR')
group by mail_status;

there are 43 notifications in mail status.
 ---------------------------------------------------------------
Mail_Status  count(*)
ERROR                  70
FAILED                  17591 
MAIL                     43  --  If its increasing that means issue in sending email 
SENT                      782 ---  It should show increasing trend .
Null                        216

 ----------------------------------------------------------------
Check if any SVC components are down

select COMPONENT_NAME,COMPONENT_STATUS from apps.fnd_svc_components where COMPONENT_STATUS<>'RUNNING'

Fix:

1.)WF Agent listener
2.)WF mailer services .



ORA-06512: at line 1

oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not instantiate GSMSvcComponentContainerStateMachine -> oracle.apps.fnd.cp.gsc.StateMachineException: Could not instantiate GenCartComm with cpid=783178 -> oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01403: no data found
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 539
ORA-06512: at line 1

        at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.initializeStateMachine(GSMSvcComponentContainer.java:221)
        at oracle.apps.fnd.cp.gsc.SvcComponentContainer.start(SvcComponentContainer.java:782)
        at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.main(GSMSvcComponentContainer.java:418)

Restart service manager fixed the issue