Oracle Workflows Training
Written by Anil Passi   
Thursday, 21 December 2006
Please find a sequential list of training articles on Oracle Workflows.

Oracle Workflow Training

Oracle Workflows Training Lesson 1

Oracle Workflows Training Lesson 2

Oracle Workflows Training Lesson 3

How to define Business events in Oracle Workflows :- And Subscribe a PL/SQL[with working example]

Oracle Workflows Business Events - How to create and raise Event with XML Payload
Oracle Workflows Business Events - How to parse XML Payload, via Workflow Events Subscription 
Testing Oracle Workflow Business Event with XML Payload
Transfer Workflows business events

Oracle Workflows Account Generator Example

Oracle Workflows : Attach documents to Notifications

Adjust Notification Timeouts to include bank holidays and weekends

How to override Email Address : Send all notifications to a single Email Id

Basics of Oracle Workflows Engine 

Oracle Workflows Access Protection Concepts 

Preserve Customizations to Oracle Workflows - A Presentation

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

Comments (42)add
...
written by Sreenivasa Rao Ramuni , December 28, 2006
Thanks a lot Anil. Its very helpfull for the people who is learning the Workflow
...
written by Sreenivasa Rao Ramuni , December 28, 2006
Thanks a lot Anil. Its very helpfull for the people who is learning the Workflow
...
written by Anil Passi , December 29, 2006
.
.
.
.
Which Schema are you connecting to Nimish?
You need to be in apps schema. Alternately, you must give appropriate grants from apps schema to the schema in which your development happens.

IMPORTANT NOTE: Oracle recommends all packages to be created in apps schema itself.
.
.
.
.
.
...
written by Nimish , December 29, 2006
thanks Anil for your help. I thought so but wanted to try and avoid going to DBA for creating stuff in Apps schema. Anyways I will check with them.

Regards!
...
written by Anil Passi , December 29, 2006
.
.
.
.
Which Schema are you connecting to Nimish?
You need to be in apps schema. Alternately, you must give appropriate grants from apps schema to the schema in which your development happens.

IMPORTANT NOTE: Oracle recommends all packages to be created in apps schema itself.
.
.
.
.
.
...
written by Nimish , December 29, 2006
thanks Anil for your help. I thought so but wanted to try and avoid going to DBA for creating stuff in Apps schema. Anyways I will check with them.

Regards!
...
written by Ranjeev Singh , February 19, 2007
Hi Anil,
I want to send the e-mail for the approval to the approver email ID using Workflow how do i do this..... PLease hepl me in this regard....
...
written by shahnawaz , May 16, 2007
was gud, but better if you do it bit slow and explain properly.
...
written by Aloy , June 05, 2007
Hi Anil,

Excellent site, easy to follow steps better than Oracle֒s doc.

Is there an easy way to stop e-mailing FYI Purchase Order notifications in 11.5.10CUP2?

I will appreciate very much of your suggestion.

Thanks.
Aloy
...
written by Anil Passi , June 05, 2007
Hi Aloy,

Simply remove that FYI notification activity from the workflow.

Thanks,
Anil Passi
...
written by Joydeep , June 18, 2007
Sir,
Is there no link for Order management and inventory. It will be great hep for the manufacturing people.

Thanks,
Joydeep
...
written by Munish Thukrela , June 18, 2007
Thanks a lot Anil. Indeed, its very helpfull for the people who want to learn the Workflow. And pls guide me what should I do to learn more about workflow because I am very new for oracle workflow.

Regards,
Munish
...
written by Anil Passi , June 19, 2007
Hi Munish,

To practice workflows further, you can try to integrate workflows with Business Events.

You may also try sending out notifications of type DOCUMENT i.e. CLOB,BLOB, OAF etc.

Thanks,
Anil
...
written by Uttam , June 20, 2007
Anil,
I am really surprised/amazed to find your patient replies to lots n lots of queries floating around.
Hats off to your effort.
Keep up the good work..

Regards,
Uttam
-- An enthusiastic new entrant to OWF
...
written by Chirag , July 30, 2007
Hi Anil,

I have a workflow called 'OM Order Line'. Now according to the requirements i need to advance the workflow for the selected lines of the sales Order from one activity 'Branch on Form Selection' to 'Schedule Line'.
I need to create a concurrent request with the parameters
1)Sales Order number
2) line numbers of the sales orders ( like 1-3,5 )
So if i am not wrong i need to call the workflow manually to advance from one activity from another.
Please provide some information regarding that. Is there any standard API to do that?
I found API, wf.engine.startprocess. But it actually starts from the start if i am not wrong. I need to advance the workflow in between form one activity to another.
Please help.

Regards,
Chirag.
...
written by Anil Passi , July 30, 2007
Hi Chirag

Have a look at FND_WF_STANDARD.submitconcprogram and FND_WF_STANDARD.waitforconcprogram

This WF API has provision to submit request. After the request is completed, the API will push the workflow forward.

Search on these APIs within documentation.
You will need to define wait activity just after the executeconcprogram.

If you want other alternatives, then simply define a loop onto the activity, and set the cost of that activity to say 60. This activity will be after the submit request activity, and will be only run in background mode[cost is more than threshold]

The choice is yours, but try to use the FND API's instead within the WF flow

Thanks,
Anil Passi
...
written by Chirag , July 31, 2007
Hi Anil,

Thanks a lot for ur answer.
Yuor site is really helpful for people.

I will search on the APIs you have mentioned and let you know abt the proceedings.

And I have found out nice whitepaper while searching on my problem.
check this information on the site workflowfaq.com
Go to blog and search ''Moving / Jumping Around Processes''

I think this will provide a solution for me. Its a really nice whitepaper.
Worth going through it.
Thanks once again.

Regards,
Chirag
...
written by Sajith , August 25, 2007
Hi Anil,

Appreciate ur commendable effort.

It will be very helpful, if the workflow training lessons are downloadable. I there any way out to download.

Regards,
Sajith
...
written by Ananth , August 26, 2007
Hi Anil,

Very good info. thanks for your info.I have a doubt. When do we have to go for a workflow ?? as far as my knowledge goes we can go for it when i have to send workflow mails/notifications, if any approval based thing is required. let us say i have a requirement where in i have to update some tables as per some conditions and i have to send mails using UTL_SMTP can i go for a workflow ?? when i can design the same with PL/SQL too.

Regards
Ananth
...
written by Mohummad Fahad , August 27, 2007
Hi Anil,

I really find the documnetation helpful.
I need ur help to handle one scenario.

I have craeted a customized workflow which have five levels of approval.
When the user submit the request,it will go to first level of approval.The approver will be able to see the details in the Action History table as Num,Action,From,To,Details..etc. on notification.
Once approved request will go to second level approval.On notification he'll be able to see the Action History of the last transaction.
My requirement is i need to show the action history form submission of request means the approver should be able to see the action history of all the previous approvals right from submission of request.

i'll really appreciate ur help Anil.

Thanks
Fahad
...
written by Mohummad Fahad , August 30, 2007
Hi Anil,

Could u please answer my above specified query?Really need ur help.
Thanks in Advance.

Fahad
...
written by Basava.S , September 07, 2007
Hi Anil ,
I am new to this site.first of this is damm good and the info provided here is very helpful.
Actually I'm new to workflow.I got a requirement to work on it.So I want to learn it.
I have gone thru the training sessions you have provided with audio.
Can i get those audio training sessions as downloads?
Please help me in this...

Basava
Vijayawada,AP.

...
written by Anil Passi , September 07, 2007
Hi Basava,

I am afraid that currently it isn't possible to download these.
But the site is up and running 24x7. Feel free to learn online

Thanks,
Anil Passi
...
written by Basava.S , September 07, 2007
Hi Anil,
Can you please help me in one doubt ?
In a conc program of Reports type , there 3 parameters.
p-1 contains Yes/No values.
If p-1 is Yes then i need to show p-1 values(10,20,30 etc) and p-2 should be disabled.
If p-1 is No then i need to show p-2 values(100,200,300 etc) and p-1 should be disabled.
How can i handle this?
I tried with table type value sets to attached to those 3 parameters.
It is working but the problem is based on p-1 value other parameter are also highlighting and not getting disabled.
Any help please...

Thanks ,
Basava.

...
written by bhanu_Kamal , September 07, 2007
Hi Anil,
I have a problem related to po requisition workflow customization. i am describing my requirement through an example.


1. Log on as SACHORN create and submit requisition for approval. $300,000
2. Review approval list: BBAKER,DMcIlvin, JSWIFT, JBARRYHAMILTON
3. Log on as BBAKER, approve
4. Log on as DMcIlvin, approve
5. Log on as JSWIFT, change the account number
a. open the requisition via wf notification, select edit requisition
b. select approver checkout
c. continue until you reach Review Charge Accounts, select the account number
d. change the natural account number to 670203
e. continue and approve requisition
6. Log in as SACHORN and review status requisition
a. it is now at BBAKER waiting for approval.

>>> This is where we don't want it going back to the approver for approval. It should
have continued to JBARRYHAMILTON
There is a validation somewhere during the approver checkout process that determines
that the req needs to get reapproved.

How i can customize this workflow REQAPPRV.wft. which package i have to customize and how?
please describe in detail.


Thanks & Regards

Kamal
...
written by Dhritiman Maitra , September 11, 2007
Hi Anil,
I am new in Workflow Development and got help from ur articles.
If u please mail me those links to download those articles (to run it offline)
then it will be more helpful for me.

Thanks
...
written by Dhritiman Maitra , September 11, 2007
Hi Anil,
I am new in Workflow Development and got help from ur articles.
If u please mail me those links to download those articles (to run it offline)
then it will be more helpful for me.

Thanks,
Dhritiman Maitra
...
written by Vijaya , September 11, 2007
Hi,
Your website is great. I got a workflow job browsing your website. Thanks a lot for all your great help. Can you help me on this. Is it advisable to change the standard oracle seeded process (taking the backup) otherwise we have copy the process and change in our own process.
if we are making our own copy where all we should check to change our references to point to new process.

Thanks in advance,
...
written by Anil Passi , September 12, 2007
Hi Vijaya

Ideally you must not modify the seeded workflow, but yet many people do this. I have done this in past myself.
However, you should check the checkbox "Preserve Customizations" so that patches do not override your changes.

If you are modifying an Account Generator workflow, then you can create a new process and then attach that process fo KeyFlexfield setup.
In most other cases, you will end up modifying the actual process itself.

Thanks,
Anil Passi
regarding work flow mailer
written by sudheer kumar , October 01, 2007
Hi anil ,
your lesson's are very good.They helped me alot.Thanks for that and i have one doubt hear.
Do we need workflow notification mailer status in 'RUNNING' mode to send an e-mail notitfication.To multiple members.

which was in the work flow administrator web application (resp)
in that
oracle applications manager (menu)
in that
work flow manager (function)

in the 3rd step we can find the status saying RUNNING.


But in my system it is like this 'SYSTEM DEACTIVATED'
so to change the status of work flow mailer what should i do.??
My requirement is not to send to a single email when i approve the PO the nofication should send to the buyer through e-mail. so buyer will be differ na so for diffrent e-mail's i need to send.
but ur concept is helpful to me.


please replme me
thanks
sudheer G kumar
sudheergbe@gmail.com
Online WF training is marvellous..
written by Zameer , October 02, 2007
Hi Anil,
This online WF training helped me much and helps others too.
Could you please let me know how can i down load as i don't have internet connection at
my home.
Thanks in advance.
Thanks,
Zameer.
workflow notification mailer
written by sudheergbe , October 03, 2007
Hi anil,
I have seen your lessons they really good to understand the work flow from basics.
In one of your lessons u said how to send all the notifications to the single mail.
But my requirement is to send the PO details to the buyer.
so buyer wont be same all the times so to send the e-mail notifications to the diffrent peoples what are the setups i need to do.

and one more thing in my system the workflow notification mailer status is not in running mode it is saying that 'SYSTEM DEACTIVATED'.
do we need this status as running to send e-mail notification.(not only to a single mail for diffrent mails also do we need that in running mode).


Thanks
sudheer G
sudheer@smarterpsolutions.com
Remove Forward, Approve and Forward in Requisition Notification
written by Hi Anil, , October 25, 2007
Hi Anil,

I would like to customize the Requisition Notification, say, Notification should not contain Forward and Approve and Forward, which are standard. I have created new lookup type with only two lookup codes Approve and Reject, and this look up type is used as Result for the notification. And the in the Node tab of the notification, i have mentioned time out and
Relative time to e 1 hour. But my notification still contain Timeout link along with Approve and Reject action items.

Any help pls?

Regards
Ram
work flow
written by siddam , October 29, 2007
please send me
work flow video tutorials

Nice Work
written by madhuri desu , November 03, 2007
I know the basic concepts of workflow and how to create attributes, notifications and processes etc but I couldnot understand how to save them to the database and how to run them.
But after working with your example I learned to do it.

Thanks for your Lessons and I hope I could learn more in the further lessons

How To Install WorkFlow on oracle applications
written by Ramakrishna_gottipati , November 26, 2007
Hi Anil,

i have installed the oracle apps 11.5.10. I need to install workflow builder on this. Please provide me the details and matching versions.

Regards,
Ramakrishna.
Oracle Workflow Certification
written by Tamil Selvan , December 18, 2007
Hi Anil,
I would like to do Oracle Workflow Certification.
but i couldn't find study guides for preparing the exam.

Please help in providing the study guides if you have.

Exam Name : 1Z0-231 (Oracle Workflow Certified Expert)

regards
Tamil
Order Line Workflow
written by Neelam , January 25, 2008
Hi,
I am working on OEOL workflow. Trying to customize the Line flow Generic,Bill Only process. Soon as the order is booked the lines using this process go into fulfilled. The requirement is to get let user decide when to fulfill. So i added 'wait to fulfill line' function to the workflow. This lets the user progress order to fulfill. This is working well for everything except split line. If i line A is split into A and B, B errors out giving unexpected error. Can you advice on how to resolve this.Is there anyother function that is more appropriate?

Workflow Schema Issue
written by Manohar Baddam , February 01, 2008
Hi Anil,
I am working on OEOL workflow, have added a new function activity to this flow.This activity references PL/SQL stored procedure compiled in the APPS schema, Instead is it possible to use the PL/SQL stored procedure compiled in another schema while WF function resides in APPS schema.I tried to give schema name in the function attribute but the WF is going into exception.Can you advice on how to resolve this.Is there any other approach where I can use another schema for PL/SQL code.appropriate?

Regards
Manohar

how to change the approval hierarchy in requisition workflow
written by abs.sharma , February 18, 2008
Hi Anil,

Iam new to workflow and I need your advice on one of our business requirements.
Whenever requisition is created it goes to preparer's approval hierarchy whereas business requirement is that requisition should be approved by requestor's approval hierarchy . Pleaselet me know that where should I make the changes to meet this requirement.

thanks
Bhanu


PLS-00201: identifier 'XDP_SFM_SR_WF.CALL_PROCESS_ORDER' must be declared
written by Kishor , February 23, 2008
Hi Anil,

we have getting below error when lauching the wf

ORA-06550: line 1, column 7:
PLS-00201: identifier 'XDP_SFM_SR_WF.CALL_PROCESS_ORDER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored [Error Process Error: 3116: Activity 'WFERROR/SERVEREQ_ERROR' is not a runnable process.]

Regards,
Kishor
'Where to search for .wft files
written by satheesh , March 20, 2008
Hi Anil,

I am very very new to workflow. Can you please guide where to check for the .wft files created.
You must be logged in to a comment. Please register if you do not have an account yet.

busy