A newbie to Oracle Apps might think that a workflow role is nothing but FND_USER itself.
Also being a started, you might think there are merely two different notification types.
In reality though, a workflow role can be any entity with which notification engine can communicate and take responses from.
Also, there are at least six different types of notifications that can be developed using Oracle Workflows.

In this presentation, you will see
            1. Different types of Workflow roles and their relation to business Entities
            2. Different possible type of Workflow Notifications
            3. Step by step instruction for creating pl/sql document type notifications
            4. Step by step instructions for creating OA Framework type notification
            5. Advantages of OA Framework based notification messages
            6. Best practices for Oracle Workflows
            7. Concept and example of Business Events in Oracle Workflows

Please click here to find the presentation that explains the above listed topics.
Different_Types_of_Roles_And_Notifications

Just a note for reference:-
Another point worth making here is that, Roles aren’t merely a mechanism to create recipients of Notifications.
Oracle is moving towards using ROLES to define security.
In fact, in Fusion Apps, there may not be any such thing called a responsibility.

Comments (17)

Subscribe to this comment's feed

Consultant
written by Maran , January 14, 2008

Hi,

Thanks for your excellent work and knowledge sharing. I am tryign to downlaod this Workflow presentation and it is prompting me to enter password to open the pps file.

Can you please provide me

Thanks
Ram

...
written by Anil Passi , January 14, 2008

Hi Ram,

The password restriction is for modification of the document.

When prompted with password, please click on "Read Only"

Thanks
Anil passi

workflow
written by Nikhilesh Singh , January 14, 2008

Hi Anil,
Nice article. I am using document type attribute to get the data from table in tabular format. This is working fine. Now i want to display two text fields as last two columns and these should be editable. Also there should be button ( either at the end of the table or the response buttom in the response section) which when clicked should save the modified data into the table.

Can this be achieved ?

Pl. help

...
written by Anil Passi , January 15, 2008

Hi Nikhilesh,

Sure this can be achieved using OA Framework based notification.

Thanks,
Anil Passi

Good to see you sir
written by Sachin Ahuja , January 15, 2008

Hi Sir,

Good to see you back. Belated wishes for New Year to you.

Regards
Sachin Ahuja

Need a help
written by maddy , January 16, 2008

Hi Anil,

I am a regular reader of your articles on WF. I really apreciate your work.
I am new to oracle WF and currently working on a customization of OM wF.
I have a query in one design where I need to check if all the line status is "Ready for submmital" then I have to set the header status to "REady for submittal". "Ready for submittal" is the custom status for which I will be defining a lookup type and code. I was wondering If there is any OM API which I can use to set the Header Status of the order.
If you have any suggestion on the design then please kindly reply.

Regards,
Maddy

...
written by Nikhilesh Singh , January 16, 2008

Hi Anil,

Other then OA framework

Now i want to display two text fields as last two columns and these should be editable. Also there should be button ( either at the end of the table or the response buttom in the response section) which when clicked should save the modified data into the table.

Is it possible to workout with normal workflow

BR
Nikhilesh

workflow
written by Nikhilesh Singh , January 16, 2008

Hi Anil,

If through, OA frame work does it needs another page/form to open

BR
Nikhilesh

...
written by Anil Passi , January 16, 2008

Hi Nikhilesh

Other way is to make two WF Attributes, one for each field.
These attributes when attached to WD Message will be of type respond.

Hence, user will be able to enter values into these fields.
When user responds, you can capture and validate entered values via post-notification pl/sql

Thanks
Anil Passi

...
written by advait_etc , January 16, 2008

Hi Anil,

Can we hide response type attribute? it should be displayed when required. (Scinario: created 3 response attrib for 3 lines now if there are only 2 lines it should display 2 response attrib).

Cheers,
Advait...

...
written by Anil Passi , January 16, 2008

Hi Advait

You can not dynamically hide those.

However a workaround would be that, you can haev a switch node in WF prior notification. In this, you check the number of lines, and based upon that you branch to different notifications that have different set of attributes attached.
This workaround is not ideal though, which is why OA Fwk option is flexible.


Thanks,
Anil Passi

...
written by advait_etc , January 16, 2008

Many Thanks Anil!

Oracle Apps Developer
written by Ranga , February 08, 2008

Hi Anil,

I have been reading your notes and training meterial for the past 3 weeks and lots of information. I need help from you. Could you please send one customised wft file from HRMS module along with pl/sql code? I am kind of new to WF and need your help. Specially, if employee gets a raise / terminate / transfer, I have to notify to the immediate manager, but also manager to immediate manager. 2 level of approval needed. I think in Oracle, we get one level of approval. Please help me. Thanks, Ranga

I can not open the file
written by Ranga , February 08, 2008

Hi Anil,

I can not open the Different_Types_of_Roles_And_Notifications. There is no choice for rean_only.

Thanks, Ranga

I can open the file.
written by Ranga , February 08, 2008

Anil, I can open the file. thanks, Ranga

...
written by TUAN , February 11, 2008

Hello Anil,
What is the different between these 2 responsibility:
Workflow Administrator Web Applications and Workflow Administrator Web (New)
I am running 11.5.10.2 and currently can not use Workflow Administrator Web (New) responsibility. Error: Workflow Administrator Web (New) is not a valid responsibility for the current user. Please contact your System Administrator. Can you please help

Remove submit button in a "for your information" notification NtfReviewRN
written by Mustapha Fassihi , March 11, 2008

Hi Anil,
I'd like use this standard region from Workflow call in 'for your information' notification:
oracle/apps/per/selfservice/review/webui/NtfReviewRN
I'd like create a specific region cggv/oracle/apps/per/selfservice/review/webui/NtfReviewRN
with this controller: CGGV/oracle/apps/per/selfservice/review/webui/NtfReviewCO.
My aim is to hide one button: the submit button.
I'd like replace this button(Submit button)by an other button(Ok button).
I don't know where to find the solution : in OAF region,controller or workflow?
Thank you for your help.
Regards
Mustapha