Fusion Blog

EBS Blog


Contact Us

Oracle Workflows - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

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.


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.

Anil Passi


0 #1 Maran 2008-01-14 13:18

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

0 #2 Anil Passi 2008-01-14 13:26
Hi Ram,

The password restriction is for modification of the document.

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

A nil passi
0 #3 Nikhilesh Singh 2008-01-14 23:25
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
0 #4 Anil Passi 2008-01-15 01:03
Hi Nikhilesh,

Sur e this can be achieved using OA Framework based notification.

Anil Passi
0 #5 Sachin Ahuja 2008-01-15 03:11
Hi Sir,

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

S achin Ahuja
0 #6 maddy 2008-01-16 01:57
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 ,
0 #7 Nikhilesh Singh 2008-01-16 06:01
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

0 #8 Nikhilesh Singh 2008-01-16 06:04
Hi Anil,

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

Nikhil esh
0 #9 Anil Passi 2008-01-16 06:11
Hi Nikhilesh

Othe r 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-notificati on pl/sql

Anil Passi
0 #10 advait_etc 2008-01-16 11:30
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).

Cheer s,
0 #11 Anil Passi 2008-01-16 11:35
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.

Tha nks,
Anil Passi
0 #12 advait_etc 2008-01-16 12:20
Many Thanks Anil!
0 #13 Ranga 2008-02-08 17:26
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
0 #14 Ranga 2008-02-08 18:15
Hi Anil,

I can not open the Different_Types _of_Roles_And_N otifications. There is no choice for rean_only.

Thanks, Ranga
0 #15 Ranga 2008-02-08 18:36
Anil, I can open the file. thanks, Ranga
0 #16 Valeria 2008-02-11 14:54
Hello Anil,
What is the different between these 2 responsibility:
Workflow Administrator Web Applications and Workflow Administrator Web (New)
I am running 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
0 #17 Tarun Sharma 2008-03-11 09:46
Hi Anil,
I'd like use this standard region from Workflow call in 'for your information' notification:
o racle/apps/per/ selfservice/rev iew/webui/NtfRe viewRN
I'd like create a specific region cggv/oracle/app s/per/selfservi ce/review/webui /NtfReviewRN
wi th this controller: CGGV/oracle/app s/per/selfservi ce/review/webui /NtfReviewCO.
M y 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,controll er or workflow?
Thank you for your help.
M ustapha
0 #18 S Zubair 2008-05-28 06:58
Hi Anil

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

Regard s

S Zubair
0 #19 Anil Passi 2008-05-28 07:36
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

0 #20 Sangeeta Verma 2008-07-24 10:19
Hi Anil,
Great articles! I have a question.
I am trying to pull information in one of the approval notification(Ch ange 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.

Thank s,
0 #21 Sameer 2008-08-06 07:59
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....

0 #22 Ayoob 2009-03-08 18:12
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.

Add comment

Security code

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner