How to Start a workflow from OAF Page!

How To Integrating Workflow and OAF

It's quite common requirement to call or initiate  oracle workflow from an OAF page. To facilitate this requirement class oracle.apps.fnd.framework.webui.OANavigation provides Java wrappers for Oracle Workflow Engine’s PL/SQL APIs.

 It is very simple to invoke Workflow using OAF. There are two options first using Java wrappers and second through calling PL/SQL procedures but the later approach can be used where all the code for Workflow is already ready and tested. If  if it is new workflow then always better to use Java wrappers:

 Following piece of code invokes the Workflow from OAF:

 import oracle.apps.fnd.framework.webui.OANavigation;

 public void launchWorkFlowFromOAF(OAPageContext pageContext)

{

String wfItemType = “‘XXSR'”;

String wfProcess = “‘SR_MAIN_PROCESS'”;

OADBTransaction transaction = getOADBTransaction();

String Sr_No ;

String wfItemKey = ” “;

Sr_No = pageContext.getParameter(“sr_no”);

wfItemKey = Sr_No+ transaction.getSequenceValue(“xxsr_key_s.NEXTVAL”).toString();

OANavigation wfClass = new OANavigation();

// Create Workflow Process

wfClass.createProcess(pageContext, wfItemType, wfProcess, wfItemKey);

// Set Number Attribute: SR_NO

wfClass.setItemAttrNumber( pageContext,

                                       wfItemType,

                                       wfItemKey,

                                       “SR_NO”,

                                       Sr_No      );

// Start Workflow Process

wfClass.startProcess(pageContext, wfItemType, wfProcess, wfItemKey);

}

If you want to invoke this workflow using callable statement then you have to write code like this:

OAF code:

 if(pageContext.getParameter(“btnSubmit”)!=null)

{
String sql = "BEGIN xx_sr_notf_pkg.invoke_wf (:1); END;";
String status = null;
OracleCallableStatement cs = (OracleCallableStatement)
am.getOADBTransaction().createCallableStatement(sql,1);
try
{
cs.setString(1,srNo);
cs.execute();
cs.close();
}
catch (Exception ex)
{
throw new OAException(ex.getMessage().toString(),
OAException.ERROR);
}
throw new OAException("SR "+srNo+" has been submitted",
OAException.CONFIRMATION);
} 
PL/SQL Code to Invoke Workflow:
   PROCEDURE invoke_wf (p_sr_doc_number IN VARCHAR2)
   IS
      l_item_key             VARCHAR2 (50);
   BEGIN
        SELECT p_sr_doc_number ||  xxegasr_key_s.NEXTVAL
        INTO l_item_key
        FROM DUAL;
wf_engine.createprocess ('XXSR', l_item_key, 'SR_MAIN_PROCESS');
wf_engine.setitemattrnumber(itemtype      => 'XXSR',
                            itemkey       => l_item_key,
                            aname         => 'P_SR_DOC_NO',
                            avalue        => p_sr_doc_number
                           );      
      wf_engine.startprocess ('XXSR', l_item_key);
      COMMIT;
   END invoke_wf;