‘8. Workflow Mailer’

Workflow Mailer Script to start notification mailer

Workflow Mailer Script to start notification mailer sqlplus apps/apps_pwd 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; /

March 27, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 8. Workflow Mailer

Workflow Mailer Script to stop notification mailer

Workflow Mailer Script to stop notification mailer sqlplus apps/apps_wpd 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; /

March 27, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 8. Workflow Mailer

Workflow Mailer Script to check mailer status

Workflow Mailer Script to check mailer status sqlplus apps/apps_pwd 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’); Note: Possible values: RUNNING STARTING STOPPED_ERROR DEACTIVATED_USER DEACTIVATED_SYSTEM

March 27, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 8. Workflow Mailer

Workflow Mailer Script to check service status

Workflow Mailer Script to check service status sqlplus apps/apps_pwd Note: Number of running processes should be greater than 0 select running_processes from apps.fnd_concurrent_queues where concurrent_queue_name = ‘WFMLRSVC’;

March 27, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 8. Workflow Mailer