Nis
26
2016

Start WF Components Script

Merhabalar,

Sistem yöneticisi iş akışlarında Agent listener bileşenlerini aşağıdaki script ile Start veya Stop edebilirsiniz.

DECLARE

p_retcode    NUMBER;

p_errbuf     VARCHAR2 (100);

m_mailerid   fnd_svc_components.component_id%TYPE;

BEGIN

 

SELECT   component_id

INTO   m_mailerid

FROM   fnd_svc_components

WHERE   component_name = ‘Workflow Inbound Notifications Agent Listener’;

 

 

fnd_svc_component.start_component (m_mailerid, p_retcode, p_errbuf);

 

COMMIT;

DBMS_OUTPUT.put_line (p_retcode);

DBMS_OUTPUT.put_line (p_errbuf);

END;

 

–************************************************************

 

DECLARE

p_retcode    NUMBER;

p_errbuf     VARCHAR2 (100);

m_mailerid   fnd_svc_components.component_id%TYPE;

BEGIN

 

SELECT   component_id

INTO   m_mailerid

FROM   fnd_svc_components

WHERE   component_name = ‘Workflow Inbound Notifications Agent Listener’;

 

 

fnd_svc_component.stop_component (m_mailerid, p_retcode, p_errbuf);

 

COMMIT;

DBMS_OUTPUT.put_line (p_retcode);

DBMS_OUTPUT.put_line (p_errbuf);

END;

Erkan Erkişi
Latest posts by Erkan Erkişi (see all)


Yorum yapın

*