Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, August 28, 2011

Designing Simple Master/Deatil Oracle workflow

When you spawn a detail process from a master process in Oracle Workflow, you are
in effect creating a separate process with its own unique item type and item key. Oracle Workflow engine has provided an API SetItemParent API” to define a master/detail relationship between the two processess. This APIshould be called after we called the CreateProcess API for the DETAIL process, BUT before a call has made toStartprocess API for detail process.

In the workflow we have two activities (one will be define in master and other in detail) to coordinate flow between master and detail process. As explained below,
One activity lets you pause a process and the other signals the halted process to continue. To use these activities, you place one activity in the master process and the other in each detail process.


These activities are
  1. Wait for Flow Activity
  2. Continue Flow Activity
Both activities contain two activity attributes that you use to identify the coordinating
activity in the other process(es).

Wait for Flow Activity – This activity can be in master /Detail and will pause the flow until the corresponding detail/master process completes for this activity. pl/sql procedure for Wait for Flow activity isWF_STANDARD.WAITFORFLOW.
Based on our business requirements we can have any number of Wait for Flow activities in the same workflowprocess.One very Important thing that should be keep in consideration when we design Mater /Detail relationship, If we have ONE master and ONE detail process, but MASTER process wait for the DETAIL process at multiple stages of its (master) flow, in that case master process should have separate Wait for Flow activity node for each time it wait for detail process. Similarly DETAIL process should have separate Continue Flow Activity corresponding to each Wait for Flow activity in Master process.


Wait for Flow activity contains 2 activity level attributes

Continuation Flow - specify whether this activity is waiting for a corresponding
"Master" or "Detail" process to complete.
  • Continuation Activity - specify the label of the activity node that must complete in
    the corresponding process before the current process continues. The default value isCONTINUEFLOW.
  • Continue Flow Activity

    Use this activity to mark the position in the corresponding detail or master process
    where, upon completion, you want the halted process to continue. This activity calls a
    PL/SQL procedure named WF_STANDARD.CONTINUEFLOW.
    When a Continue Flow activity is executed, the WF_STANDARD.CONTINUEFLOW
    procedure checks whether the corresponding Wait for Flow activity is associated with
    any other processes that have not yet completed their Continue Flow activities. If so, the
    waiting process keeps waiting for those other processes. If the Wait for Flow activity
    is not waiting for any other processes, then the WF_STANDARD.CONTINUEFLOW
    procedure completes the Wait for Flow activity so that the process that was waiting
    now continues to the next activity.


    Activity Attributes
    The Continue Flow activity contains two activity attributes:

    1. Waiting Flow - specify whether the halted process that is waiting for this activity to
      complete is a "Master" or "Detail" flow.
    2. Waiting Activity - specify the label of the activity node in the halted process that
      is waiting for this activity to complete.
    Below is example for how to call the master/detail workflow from pl/sql


    Master Workflow (Calling Detail Flow with "Waiting Activity Label = Name of Child Activity waiting for this master to complete)




    Master Workflow (received call from Detail activity with Continutation Activity Label = Name of Child Activity, that this Master is waiting in Order to progress further.)





    Detail Flow (Received Call from master flow with "Continutation Activity Label = Name of Parent Activity that this Detail is waiting in Order to progress further)

    Detail Workflow (Calling master flow with "Waiting Activity Label = Name of Parent Activity Waiting for this Child activity to complete)



    declare

    l_ckey varchar2(10) :='615';
    l_pkey varchar2(10) :=l_key; --(can be any value)
    l_ptype varchar2(10) :='SR_TYPE'; -- Parent type
    l_ctype varchar2(10) :=’SR_INTER’; -- Child type
    l_pprocess varchar2(100) := 'SR_PROCESS'; -- Parent process
    l_cprocess varchar2(100) := 'SR_INT_PROCESS'; -- Child process
    l_url varchar2(300);
    begin
    wf_engine.createprocess(l_ptype,l_pkey, l_pprocess,NULL,NULL);
    wf_engine.createprocess(l_ctype,l_pkey, , l_cprocess,NULL,NULL);
    wf_engine.SetItemParent(l_ctype,l_ckey,l_ptype,l_pkey,NULL,TRUE);
    wf_engine.startprocess(l_ptype,l_pkey);
    wf_engine.startprocess(l_ctype,l_ckey);

    l_url:=wf_engine.getitemAttrText(l_ptype,l_pkey,'RECEIVER',TRUE);
    dbms_output.put_line(l_url);

    end;

    No comments:

    Post a Comment

    If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
    Best Blogger TipsGet Flower Effect