Call OAF Region in Oracle Workflow

1) Create Stand alone OAF Region
2) Deploy Region

3) Create Workflow Attribute of Type Document in Workflow

4) Create Workflow Message Component and add Message Attribute , Refer above attribute in it.

5) Refer Embedded Region in Message Body

6) Refer Message in your Workflow Notification

7) Register OAF region in Oracle EBS

 
 

8) Set value of embedded region in your workflow PL/SQL package in DB

 
   V_URL VARCHAR2(2000);

  V_URL :='JSP:/OA_HTML/OA.jsp?OAFunc=XXWORKFLOW_REGION_FUNC&pParam='||P_PARAMETER;

        

         WF_ENGINE.SETITEMATTRTEXT(              ITEMTYPE =>  V_ITEMTYPE,

                                                 ITEMKEY  =>  V_ITEMKEY ,

                                                 ANAME    => 'XX_EMBEDED_REGION',

                                                 AVALUE   =>  V_URL

                                  );


  In above XXWORKFLOW_REGION_FUNC  is Region fuction name 

                    P_PARAMETER is any parameter you want to pass in region




  In Case want to call Oracle Form then use below , where below MY_FORM attribute will   be of type FORM instead of Document.

    l_open_form := 'XXFORM_FUNCTION:P_PARAM1="' ||l_paramval ;

   

    wf_engine.setitemattrtext(itemtype => p_itemtype,

                              itemkey  => p_itemkey,

                              aname    => 'MY_FORM', 

                              avalue   => l_open_form);

9) Restart Apache and OACore Services on server 

     Check Workflow Background process is scheduled

     Clear Cache if needed

10) Trigger New Workflow  and View Notification