Start workflow services from backend

Get the component id from below command

col component_name for a20;
col COMPONENT_STATUS for a20;
select COMPONENT_NAME, COMPONENT_STATUS,Component_Id from fnd_svc_components;

To start the services from back end – connect to apps user

declare
l_Component_Id number :=Component id; –Enter workflow Component_Id which needs to be started
l_errcode number;
l_errstr varchar2(4000);
begin
FND_SVC_COMPONENT.Start_Component(l_Component_Id, l_errcode, l_errstr);
commit;
end;
/

  • June 30, 2019 | 20 views
  • Comments