Core Workflow - EBS (MOSC)

MOSC Banner

stop start workflow mailer by script

edited Jun 6, 2023 1:59PM in Core Workflow - EBS (MOSC) 3 commentsAnswered ✓

Hi,

On e-business 11.5.10 DB 11.2.04 on AIX

I want to stop start Workflow mailer by the following script. But:

If it is already started , the script stops it without starting.

If it is stopped it starts it.

Any idea?

Here is my script:


#!/bin/sh -u

sqlplus -s apps/mypwd << EOF

spool /u/logs/SC_stop_WF_$USER.log

whenever sqlerror exit sql.sqlcode;

set echo off

--set heading off

declare

    p_retcode number;

    p_errbuf varchar2(100);

    m_mailerid fnd_svc_components.component_id%TYPE;

 begin

fnd_svc_component.stop_component(10006, p_retcode, p_errbuf);

    commit;

fnd_svc_component.start_component(10006, p_retcode, p_errbuf);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center