How to send fyi notification in oracle workflow

How to send fyi notification in oracle workflow

In this post , we will be do How to send fyi notification in oracle workflow. FYI notification means that in which the recipient does not do any actions , this is just an acknowledgement email for Information purpose so the receiver doesn't have rights to do any action on this . In Oracle apps , We sent notification to Users through Workflow Builder. In workflow builder , We design the Notifications and the complete workflow to send these notifications in the system. Here in this Post, I will be try to create one Test case for How to send fyi notification in oracle workflow.

 

 

Steps to  send fyi notification in oracle workflow

 

Step1:- Create Message Body for FYI Notification in workflow Builder

 

 

Step2: Enter the Subject which you want to show in the FYI Notifications.

 

 

Step3:- Now Create the FYI Notification Function as below.

 

 

 

 

Step4:- Select the FYI_Message created in the last step in this Notification Function.

 

 

 

 

Step5:-

lets suppose we pass the approver user_name in varialbe send_to_email;

first we find the approver user_id  like cmd --- 1234

then we find its user_name from fnd_users
where user_id=1234(approver_id);

to send notification to any user id one thing  necessary is that they have must register in table wf_local_roles.

so we in workflow we create a function like name 'set role' in back end we check it in table wf_local_roles there is any record for this user name.
if it is exists then ok other wise we create role.

 v_role_email := upper(wf_engine.getitemattrtext(itemtype => itemtype
                                                   ,itemkey  => itemkey
                                                   ,aname    => 'SEND_TO_EMAIL'));
    SELECT COUNT(*)
    INTO   n_ctr
    FROM   wf_local_roles
    WHERE  NAME = v_role_email;
if n_ctr=0 then we create role

wf_directory.createadhocrole(role_name               => v_role_email
                                  ,role_display_name       => v_role_email
                                  ,role_description        => v_role_email

,notification_preference => 'MAILHTML

,email_address           => v_role_email

                                  ,status                  => 'ACTIVE'
                                  ,expiration_date         => NULL);
end;
wf_engine.setitemattrtext(itemtype => itemtype
                             ,itemkey  => itemkey
                             ,aname    => 'SEND_TO_ROLE'
                             ,avalue   => v_role_email);
    RESULT := 'COMPLETE:Y';
    RESULT := 'COMPLETE:Y';

 end;