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
