Dear All,
In this post will share couple of Workflow mailer related information as part of Oracle Apps DBA Job.
1 Set
Override Address
Set the Override Address to the required address:
Run the following script @$FND_TOP/sql/afsvcpup.sql
from sqlplus as apps user
SQL> @$FND_TOP/sql/afsvcpup.sql
Component Id Component Name Component Status Type Containe
------------ ------------------------------ ----------------
--------------- --------
10000 ECX Inbound Agent
Listener STOPPED WF_AGENT_LISTEN GSM
10001 ECX Transaction
Agent Listener STOPPED
WF_AGENT_LISTEN GSM
10002 Workflow Deferred
Agent Listen STOPPED
WF_AGENT_LISTEN GSM
10003 Workflow Deferred
Notification STOPPED
WF_AGENT_LISTEN GSM
10004 Workflow Error
Agent Listener STOPPED WF_AGENT_LISTEN GSM
10005 Workflow Inbound
Notifications STOPPED
WF_AGENT_LISTEN GSM
10006 Workflow Notification
Mailer DEACTIVATED_SYST WF_MAILER GSM
10020 Web Services IN
Agent STOPPED WF_JAVA_AGENT_L GSM
10021 Web Services OUT
Agent STOPPED WF_DOCUMENT_WEB GSM
10022 Workflow Java
Deferred Agent L STOPPED
WF_JAVA_AGENT_L GSM
10023 Workflow Java
Error Agent List STOPPED
WF_JAVA_AGENT_L GSM
10040 WF_JMS_IN
Listener(M4U) STOPPED WF_JAVA_AGENT_L GSM
10041 Workflow Inbound
JMS Agent Lis STOPPED
WF_AGENT_LISTEN GSM
Enter Component Id: enter id corresponds to
Workflow Notification Mailer
Enter Component Id: 10006
For prompt Enter the Comp Parameter Id to
update enter id corresponds to “Test Address”
Comp Param Id Parameter Name Default Value Value Req
Reload
-------------------------------------------------------------------------------------
10093 Test
Address NONE N
Y
Enter the Comp Param Id to update : 10093
You have selected parameter : Test Address
Current value of parameter :
Enter the desired test email address at the
next prompt, for example:
Enter a value for the parameter
: RACSINFOTECH@gmail.com
Gmail account details:
User - RACSINFOTECH@gmail.com
Password – racsinfo12
1.2Update
existing notifications
Update the notifications in the
WF_NOTIFICATIONS table so they are not sent from the cloned environment:
update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status =
'MAIL';
1.3Rebuild
the WF_NOTIFICATION_OUT queue
Purge the WF_NOTIFICATION_OUT queue and
rebuild it with data currently in the WF_NOTIFICATIONS table:
@$FND_TOP/patch/115/sql/wfntfqup.sql
1.4Update
Mailer Settings
1.1.5Known
Problem - Workflow Services problem
This has happened a couple of times. If the
Services don’t start up it will be worth performing the below steps:
Unable to start the following Service
Instances for Generic Service Component Container:
-Workflow Agent Listener Service
-Workflow Document Web Services Service
-Workflow Mailer Service
Error Codes:
Could not start Service Component Container ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: BES system could not
establish connection to the control queue after 180 seconds
The cause of your issue is that queue wf_control is corrupt, and WF
Services can't read data from it.
To resolve the issue, proceed with steps below :
1- Stop the Conc Managers
2- Drop/Recreate queeu wf_control :
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfctqrec.sql APPLSYS apps
3- Start the Conc Managers
4- Verify the issue
Thanks,
Srini
No comments:
Post a Comment
No one has ever become poor by giving