Workflow Different Roles, Types of notifications, Events and Workflows Best Practices

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.

Set as favorite

Bookmark

Email This

Comments (22)

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

report abuse

vote down

vote up

Votes: +0

...
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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +1

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

Hi Nikhilesh,

Sure this can be achieved using OA Framework based notification.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

...
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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

...
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

report abuse

vote down

vote up

Votes: +0

...
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...

report abuse

vote down

vote up

Votes: +0

...
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

report abuse

vote down

vote up

Votes: +0

...
written by advait_etc , January 16, 2008

Many Thanks Anil!

report abuse

vote down

vote up

Votes: -1

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

Anil, I can open the file. thanks, Ranga

report abuse

vote down

vote up

Votes: +0

...
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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

OA Framework Personalization Disable Option
written by S Zubair , May 28, 2008

Hi Anil

I want to know what is the API to disable Personalization in OAF. without Using Profile Option.

Regards

S Zubair

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , May 28, 2008

Dear S Zubair

There is no pl/sql api that I can think off to disable a specific personalization.
However you can use functional administrator to disable the desired personalization

Thanks
Anil

report abuse

vote down

vote up

Votes: +0

OF framework type notification
written by Sangeeta Verma , July 24, 2008

Hi Anil,
Great articles! I have a question.
I am trying to pull information in one of the approval notification(Change Pay) where I want to put OA framework type notification from Education & Qualification function.
What I mean is, user want to approve new salary based on the Education & Qualification, On the same approval notification where Current and proposed Salary is displayed, i want to display Education & Qualification section(OA Framework) on the same notification under different section.

Thanks,
Sangeeta

report abuse

vote down

vote up

Votes: +0

how to call the oracle position hierarchy in workflow...
written by Sameer , August 06, 2008

Hi Anil,

I have cretaed a position hierarchy in the Purchasing responsibilty---> setup----> position hierarchy
in tht position hierarchy there is one position with name: RAO.1050.AC1 (Deputy Director Role) and there are 7 holders attach to it
and other position is RAO.1050.AC2 (Director Role) and there are 17 holders attach to it...
now my requirement is i have to call this position hierarchy in my workflow...so wat should i hav to do for tht.....
can u pls help me....

Thanks,
Sameer

report abuse

vote down

vote up

Votes: +0

Approval Notifications
written by pavan , March 08, 2009

Hi Anil,

First of all i really want to appreciate your nice work. I see lot of good examples relating to workflow in your training but i think the approval notificaitons workflow is missing. I mean to route the approvals between the supervisors and to goto the next level if they approve and return back if they reject etc. Please provide us a simple workflow which explains this.

Thanks a lot once again.
Pavan

report abuse

vote down

vote up

Votes: +1

Write comment

Name

Title

Comment