Oracle Workflows - All Articles
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

Fusion Apps Linkedin  |  Like us on Facebook  |  Get notified for our new articles  |  Twitter  | Linkedin Page | YouTube

 

User Rating: 5 / 5

Star activeStar activeStar activeStar activeStar active
 
This article presents the first and the most basic training/demo to design & build Oracle Worklfows
This specific Audio-Visual Oracle Workflow Training lesson will be the pre-requisite for the next stream of lessons on Oracle Workflows Training.

Please note that Oracle Workflow is a copyright product from Oracle Corp. This training session is for educational purposes only.

Following steps will be covered in the first lesson of Oracle Workflow Training:-
1. How to design & create a Workflow using Oracle Workflow Builder
2. How to start the Oracle Workflow process from pl/sql
3. How to integrate Oracle Workflow with pl/sql for validation and DML etc.
4. How to build Oracle Workflow Notifications
5. How to attach roles/people to notifications in Oracle Workflow

For this Oracle Workflow Training session, lets assume that the requirement is to initiate a workflow, validate it within Oracle Workflow & PL/SQL and then to send a notification.

A Purchase Order  will be created in table xxxx_po_headers.  After inserting a record in this table we will initiate Oracle Workflow. Validation step will set PO_STATUS to VALIDATED.


Please click here for the Audio-Visual Lesson 1 in Oracle Workflows Training
This may take a couple of minutes to load, depending upon your internet speed.

Click here for the pl/sql Source Code used for this training lesson

Click here for the wft file created for this Oracle Workflow Training Session

Click here for the wft file WFSTD.wft as delivered by Oracle

 

Comments   

0 #1 Syed rahman 2006-10-26 00:00
Just went through the workflow tutorial. I must say its a very good tutorial and very helpful. I would like to congratulate you on your lucid explanation. I have to practice the steps you have shown. Please do not mind if I come back to you with any questions.
Quote
0 #2 Anil Passi 2006-10-27 00:00
Hi Syed,

You are most welcome to ask questions.

T hanks,
Anil Passi
Quote
0 #3 Mohammed Abdur Rahman 2006-11-05 00:00
Amazing and Excellent!!!! This is not an exaggerated statement. Even on WORLD WIDE WEB you wont find much training material on oracle workflow and here we have a very, very good material for beginners. Simply, its a pioneering work.

Cons- The speed of the CBT is fast and its better if it can be controlled by user.
Quote
0 #4 ajay singh 2006-11-12 00:00
hai i m ajay singh . i m new for oracle apps 11i can you suggest me by that i can improve my self
ajay
Quote
0 #5 ajay singh 2006-11-12 00:00
hai i m ajay singh . i m new for oracle apps 11i can you suggest me by that i can improve my self
ajay
Quote
0 #6 Anil Passi 2006-11-15 00:00
Thanks Mahommad, I do acknowledge that the Screen go out of sync with my vocals...Hence I will have my future articles based on screenshots..

Ajay:- To improve yourself..all you need to do...is to know what you want to do...and to get started with it..or at least prepare to get started with it...
Quote
0 #7 Anil Passi 2006-11-15 00:00
Thanks Mahommad, I do acknowledge that the Screen go out of sync with my vocals...Hence I will have my future articles based on screenshots..

Ajay:- To improve yourself..all you need to do...is to know what you want to do...and to get started with it..or at least prepare to get started with it...
Quote
0 #8 Dharam 2006-11-16 00:00
Excellent training material for beginners on WF.
Quote
0 #9 Dharam 2006-11-16 00:00
Excellent training material for beginners on WF.
Quote
0 #10 CT 2006-11-21 00:00
Very cool except the noise disturbance. I am wondering is this the same as the one in OWB.
Quote
0 #11 Workflow 2006-11-21 00:00
Hi Anil

This is a really good hub for beginners in workflow.thanks a lot for sharing your experiences.it will be helpful for many Apps users ,if you can explain one standard workflow(debugg ing).

Thank you
Sasidhar.P
Quote
0 #12 Anil Passi 2006-11-21 00:00
Hi Dharam
This is not the same as OWB.
OWB is a different tool altogether.

Hi Sasidhar,

Th ats a good idea. I will write something on debugging tricks of Oracle Workflows.

T hanks both,
Anil Passi
Quote
0 #13 CT 2006-11-21 00:00
Very cool except the noise disturbance. I am wondering is this the same as the one in OWB.
Quote
0 #14 Workflow 2006-11-21 00:00
Hi Anil

This is a really good hub for beginners in workflow.thanks a lot for sharing your experiences.it will be helpful for many Apps users ,if you can explain one standard workflow(debugg ing).

Thank you
Sasidhar.P
Quote
0 #15 Anil Passi 2006-11-21 00:00
Hi Dharam
This is not the same as OWB.
OWB is a different tool altogether.

Hi Sasidhar,

Th ats a good idea. I will write something on debugging tricks of Oracle Workflows.

T hanks both,
Anil Passi
Quote
0 #16 Uri Kimchi 2006-11-22 00:00
U did a great job.
10x a lot.
Quote
0 #17 Uri Kimchi 2006-11-22 00:00
U did a great job.
10x a lot.
Quote
0 #18 Mckan Colaco 2006-11-23 00:00
hi Anil..Your workflow lesson 1 was very helpfull. one problem how do i edit the links with yes/no options.. on the diagram
Quote
0 #19 Anil Passi 2006-11-23 00:00
Hi Mckan

Right click on the link/line that joins the two function activities in wf diagram. You will see Results as an option after right click. Simply change the result.

If you want a different result set for activity then you should define your own lookup type and lookup codes and assign that lookup type to function activity.


Thanks
Anil Passi
Quote
0 #20 Mckan Colaco 2006-11-23 00:00
hi Anil..Your workflow lesson 1 was very helpfull. one problem how do i edit the links with yes/no options.. on the diagram
Quote
0 #21 Anil Passi 2006-11-23 00:00
Hi Mckan

Right click on the link/line that joins the two function activities in wf diagram. You will see Results as an option after right click. Simply change the result.

If you want a different result set for activity then you should define your own lookup type and lookup codes and assign that lookup type to function activity.


Thanks
Anil Passi
Quote
0 #22 Prabhat Jha 2006-11-30 00:00
Hi Anil,
Thanks For Such A nice Article.
Its tremendous for beginners.
Tha nks once again.
Prabhat Jha
Quote
0 #23 Prabhat Jha 2006-11-30 00:00
Hi Anil,
Thanks For Such A nice Article.
Its tremendous for beginners.
Tha nks once again.
Prabhat Jha
Quote
0 #24 Anil PAssi 2006-12-06 00:00
I know this software sucks, I had my fingers burnt too when replying to questions.

T o help this matter:-
1. I have made Email Optional
2. I have removed Preview Functionality

Replacing this software will mean loosing all the Q & A in comments thus far, unless I work out how to migrate those comments. That will take time.

Hope the user experience is better after the changes I have done today.

Thank s
Anil
Quote
0 #25 Anil PAssi 2006-12-06 00:00
I know this software sucks, I had my fingers burnt too when replying to questions.

T o help this matter:-
1. I have made Email Optional
2. I have removed Preview Functionality

Replacing this software will mean loosing all the Q & A in comments thus far, unless I work out how to migrate those comments. That will take time.

Hope the user experience is better after the changes I have done today.

Thank s
Anil
Quote
0 #26 Ashish Arora 2006-12-15 00:00
Hi Anil ,

The way you tried to explain the things are very fantastic. I can never expect the same on any learning side.Please be continue to provide us the same help and comeout with some white paper on workflow events and debugging details. also if possible can u provide us the interview questions specific to Work flow

Thanks
Ashish
Quote
0 #27 Anil Passi 2006-12-15 00:00
Hi Ashish,

I will cover workflow event in detail, with examples within next weeks timeframe.

E vents are important, as they fit into Fusion strategy too.

Thanks,
Anil Passi
Quote
0 #28 Ashish Arora 2006-12-15 00:00
Hi Anil ,

The way you tried to explain the things are very fantastic. I can never expect the same on any learning side.Please be continue to provide us the same help and comeout with some white paper on workflow events and debugging details. also if possible can u provide us the interview questions specific to Work flow

Thanks
Ashish
Quote
0 #29 Anil Passi 2006-12-15 00:00
Hi Ashish,

I will cover workflow event in detail, with examples within next weeks timeframe.

E vents are important, as they fit into Fusion strategy too.

Thanks,
Anil Passi
Quote
0 #30 SATHEESH KUMAR 2006-12-17 00:00
Hi Anil,

First time I seen a good and easily undestandable workflow explanation, the way you made it more helpful for beginners to advanced users. We are very much thankfull for your effort.

Regards
Sa theesh Kumar
Quote
0 #31 SATHEESH KUMAR 2006-12-17 00:00
Hi Anil,

First time I seen a good and easily undestandable workflow explanation, the way you made it more helpful for beginners to advanced users. We are very much thankfull for your effort.

Regards
Sa theesh Kumar
Quote
0 #32 Anil Passi 2006-12-21 00:00
Hi Ravi, The Zip File does not contain the PL/SQL Code where you are creating and starting the process.

Ple ase can you include all the scripts.

Tha nks,
Anil
Quote
0 #33 Anil Passi 2006-12-21 00:00
Hi Ravi, The Zip File does not contain the PL/SQL Code where you are creating and starting the process.

Ple ase can you include all the scripts.

Tha nks,
Anil
Quote
0 #34 Anil Passi 2006-12-23 00:00
Hi Ravi

It works at my end. Are you not doing a COMMIT after starting the workflow? Do let me know.

Have a look
http://scripts4oracle.blogspot.com/2006/12/testing-workflow.html

....
http://photos1.blogger.com/x/blogger/2204/1007/1600/688452/ravi.gif
Quote
0 #35 ravi 2006-12-23 00:00
http://www.bobshare.com/file.php?file=3c0540b9d21fc78e924f6c0fdd66593a

The script file along with screenshots.

Thanks and regards
ravi
Quote
0 #36 Anil Passi 2006-12-23 00:00
Hi Ravi

It works at my end. Are you not doing a COMMIT after starting the workflow? Do let me know.

Have a look
http://scripts4oracle.blogspot.com/2006/12/testing-workflow.html

....
http://photos1.blogger.com/x/blogger/2204/1007/1600/688452/ravi.gif
Quote
0 #37 ravi 2006-12-23 00:00
http://www.bobshare.com/file.php?file=3c0540b9d21fc78e924f6c0fdd66593a

The script file along with screenshots.

Thanks and regards
ravi
Quote
0 #38 Vidyasagar Kulkarni 2006-12-25 00:00
Hi Anil,
Thanx a lot for such a Lucid explaination on Workflow.

It has been a very good start for me on this, hope to read more on the site.

Thanks once again and Pls. dont mind, If I bother you with questions.

T hanks and Regards
Kulkar ni
Quote
0 #39 Vidyasagar Kulkarni 2006-12-25 00:00
Hi Anil,
Thanx a lot for such a Lucid explaination on Workflow.

It has been a very good start for me on this, hope to read more on the site.

Thanks once again and Pls. dont mind, If I bother you with questions.

T hanks and Regards
Kulkar ni
Quote
0 #40 Anil Passi 2007-01-02 00:00
Hi Ahmer,

All the errors listed by you pertain to WFSTD. This could be because the access level[as per help menu] at which i saved wft file is higher than that of the components within WFSTD.

You can either bring down your access level in WF Builder via Help menu
OR
You do not save the wft file into database. Instead you should follow step by step instruction to build that wft file yourself.

Th anks
Anil Passi
Quote
0 #41 Anil Passi 2007-01-02 00:00
Hi Ahmer,

All the errors listed by you pertain to WFSTD. This could be because the access level[as per help menu] at which i saved wft file is higher than that of the components within WFSTD.

You can either bring down your access level in WF Builder via Help menu
OR
You do not save the wft file into database. Instead you should follow step by step instruction to build that wft file yourself.

Th anks
Anil Passi
Quote
0 #42 Anil Passi 2007-01-03 00:00
.
.
.
Set the Checkbos to Yes, and Access Level to 0 and try to save. See if that works, but do not attempt this on Production.

I still suggest, you follow step by step instructions in this tutorial rather than save the wft file into database.

Th anks,
Anil Passi
.
.
.
Quote
0 #43 Ahmer 2007-01-03 00:00
Dear Anil,
I have found the access field & a check box in Help menu but I have no idea what to do.
Quote
0 #44 Anil Passi 2007-01-03 00:00
.
.
.
Set the Checkbos to Yes, and Access Level to 0 and try to save. See if that works, but do not attempt this on Production.

I still suggest, you follow step by step instructions in this tutorial rather than save the wft file into database.

Th anks,
Anil Passi
.
.
.
Quote
0 #45 Ahmer 2007-01-03 00:00
Dear Anil,
I have found the access field & a check box in Help menu but I have no idea what to do.
Quote
0 #46 Anil Passi 2007-01-18 00:00
Hi Sri,
Sorry to hear this happened.

Al though I did warn in FNDLOAD article TO BE CAREFUL when moving around GL Value Sets.
This was stated in http://www.google.com/search?q=site:apps2fusion.com+oracle-fndload-script-examples-2
See note 2 [excerpt below2. Be very careful when downloading flexfields that reference value sets with independent values for GL Segment Codes.
By doing so, you will download and extract all the test data in GL Codes that might not be applicable for production.

What you need to do is to download conc program excluding the parameter with GL Values. THere are partial download options in FNDLOAD[though i am yet to try those in practice]. In real world, one must never move GL codes from one environment to another using FNDLOAD.

Tha nks,
Anil Passi
Quote
0 #47 Anil Passi 2007-01-18 00:00
Hi Sri,
Sorry to hear this happened.

Al though I did warn in FNDLOAD article TO BE CAREFUL when moving around GL Value Sets.
This was stated in http://www.google.com/search?q=site:apps2fusion.com+oracle-fndload-script-examples-2
See note 2 [excerpt below2. Be very careful when downloading flexfields that reference value sets with independent values for GL Segment Codes.
By doing so, you will download and extract all the test data in GL Codes that might not be applicable for production.

What you need to do is to download conc program excluding the parameter with GL Values. THere are partial download options in FNDLOAD[though i am yet to try those in practice]. In real world, one must never move GL codes from one environment to another using FNDLOAD.

Tha nks,
Anil Passi
Quote
0 #48 Sandeep Somvanshi 2007-01-29 00:00
Hello Anil,

Can you please give me some idea about the retention period of any Workflow.

Th anks and Regards,
Sande ep Somvanshi
Quote
0 #49 vineet 2007-02-07 00:00
Good work Anil!
Quote
0 #50 Mrunalini 2007-02-14 00:00
Hi Anil,
I am new to oracle Workflow and your tutorial is a real help.

I tried doing the demo given on site. I had overcome initial hiccups and went through most of the comments posted. But unfortunately, my workflow does not send any notifications and Iam unable to monitor it on Status-monitor tab either.

Plea se help.

Regard s,
Mrunalini
Quote
0 #51 imran 2007-03-19 00:00
Hello Anil.

My question to you is that...where do you invoke the SFM_CALL_PROCES S_ORDER from? (display name: invoke service fulfillment manager, icon: DB_INS.ICO, XDP_SFM_SR_WF.C ALL_PROCESS_ORD ER).

are these standard? i.e already part of the workflow. I do not see this on my Workflow builder with 9i as backend. I have it installed on my system as a standalone(i.e I do not have apps installed on my system). Would it still work..please advice? I am referring to lesson1

Than ks
Quote
0 #52 Anil Passi 2007-04-02 00:00
Thanks Kishore.
Quote
0 #53 amit 2007-04-03 00:00
This is article is fantastic for beginners like us in Work flow. Could you please release this lesson step by step with screen shots if possible.

Th anks in advance,

Ami t
Quote
0 #54 Muralidhar 2007-04-26 00:00
Hi Anil

Thanks for the wonderful Session in Workflow. I am new to Workflow and started Learning it.I have Question for You. Where does all the .wft files located in UNIX box.

Thanx
Mura li
Quote
0 #55 Anil Passi 2007-04-26 00:00
Hi Murali

Its usually in $MODULE_TOP/pat ch/115/import/U S

However you can always do this command on $MODULE_TOP
fi nd . -name *.wft -print


Tha nks
Anil Passi
Quote
0 #56 Munaz 2007-05-15 00:00
Hi Anil,
This a very fantastic site and very useful for beignners like me.I created a workflow as per your tutorial, everything went fine except one thing i am not able to see the worflow activity in front end even after the work flow has been initialized. When i check the table the status has changed from initial to validated. Even the email was sent. Please let me know if i am missing something here. Thanking you in advance...

Regards
Mu naz
Quote
0 #57 anil 2007-05-15 00:00
what parameters are you passing to check the status?
Quote
0 #58 Munaz 2007-05-15 00:00
Hi Anil,
I researched a little bit and found that i was looking under the wrong owner of the workflow.Thanks anyways and i really appreciate your work.

Regard s
Munaz
Quote
0 #59 sundar 2007-05-17 00:00
Hi Anil,
Thanks for your superb lesson. I have one doubt. I did all the things what u told. i am not able to see the workflow status monitor in workflow administrator. It shows XX Training Workflow but no process displayed and in xxx_po_headers table po_status is validated. Where i made mistake?
Thank s
Sundar
Quote
0 #60 Anil Passi 2007-05-17 00:00
Hi Sundar

What parameters are you passing for Status Monitor screen?

Plea se do a select on table WF_ITEMS, and you should find and entry there.

Thank s,
Annil
Quote
0 #61 Anil Passi 2007-05-18 00:00
Hi Sundar

Thank s for sharing this with everyone.

Ch eers,
Anil
Quote
0 #62 diwakar 2007-05-29 00:00
Hi Anil,

Can you provide more documents on trouble shooting existing workflows?

T hanking You
Quote
0 #63 Anil Passi 2007-06-20 00:00
Hi Diwakar

Ther e are various ways of troubleshooting Workflows

1. Adding Debug Messages to its pl/sql activities
2. Checking status monitor screen

But above all, you should try to learn the core tables used by Workflows

Th anks,
Anil Passi
Quote
0 #64 sambit 2007-07-09 12:37
Thankx a ton for your WF.

I have one issue with me.
I am able to submit the concurrent Program Through Work Flow.
But My Issue is How to submit the Request Set through Work Flow.
Please help me.

Thank U
Sambit
Quote
0 #65 Anil Passi 2007-07-09 20:24
Hi Sambit

Please use FND_SUBMIT API to submit request sets

It has following APIs

fnd_submi t.set_mode
fnd_ submit.set_nls_ options
fnd_sub mit.set_repeat_ options
fnd_sub mit.set_rel_cla ss_options
fnd_ submit.set_prin t_options
fnd_s ubmit.add_print er
fnd_submit.a dd_notification
fnd_submit.set _request_set
fn d_submit.submit _program
fnd_su bmit.submit_set


Search on Metalink for FND_SUBMIT and you will find the some sample code

Thanks
An il Passi
Quote
0 #66 SAMBIT 2007-07-10 05:37
Thank's For your Advise .
I will try it still if i have any issue i Will come to you.



thanks
Sambit
Quote
0 #67 Gajapati 2007-07-11 11:18
Hi Anil,

I dont know anything about Work Flow.
Can You please let me know how can i start learning the same.
Where should i start.

Regards ,
Gajapati.
Quote
0 #68 SAMBIT 2007-07-12 08:42
Hi Anil,
It's ok after your suggestion.
I have another issue.
Actually FNF_CONCURRENT_ PROGRAMS table contain all the concurrent program.
My issue is i have to submit the first 10 request that are present in this table.
I have to use Work Flow for submiting the request.
please help me?

Thank U
Sambit
Quote
0 #69 Anil Passi 2007-07-12 08:51
Hi Sambit

You can use fnd_request.sub mit_request from pl/sql to submit requuests
This pl/sql can be called from workflow activity

Thank s,
Anil
Quote
0 #70 sambit 2007-07-12 11:44
Thank's for your suggestion

by using this i am able to submit one request .
but for other program that are present in that table is not subimiting.
ple ase help me
Quote
0 #71 ARR2K4 2007-07-13 16:12
Hi,

I find the articles here very much useful.
Thanks and Hats off to your effort & help to users on WWW.

I am looking for an information with respect to customizations to Standard workflows.
Can you please give me details on how to customize the standard workflows.

My understanding on the same are as follows:

1. Standard WF objects are created in access level 0
2. Customizations should be done only at level 100
3. Hence, if we try to create some activities at access level 100 and place it in standard process (which will be protected at level 0), it will not allow that to be done.
Hence, can you please suggest how to achieve this??

Appreci ate & would be really great if you could reply me at the mail id given.
Or, would you mind to give me your mail id so that we can discuss on lots of advance & rarely used concepts in oracle workflow which might help both of us to learn more..

Thanks.
Quote
0 #72 Anil Passi 2007-07-13 19:46
Hi Arrk24

You are right, customers are supposed to work at access levels of 100 or above.

You can go to help menu in WF Builder to reduce your level down to say 20 [1 to 19 is used by WF product development team].
But any changes done herewith by reducing your level can be lost by Oracle patches.

Thank s
Anil
Quote
0 #73 RajeshKhatri 2007-07-29 18:43
Hi Anil,

I have created a custom workflow based on this training and implemented in Oracle Applications 11.5.10.2. the Notifications are working fine but i am not able to see the notifications in the worklist ( open notifications). Can you please help me with this. when i query wf_notification s, from_user columns is not populated and to_user has the email address.

Rajesh
Quote
0 #74 Anil Passi 2007-07-30 09:34
Hi Raj

Please check the value in column RECIPIENT_ROLE, in wf_notification s.
Once you have that value, examine wf_local_roles to see which user/person that role points to.

Thanks,
An il Passi
Quote
0 #75 Soma 2007-08-07 21:59
Hi Anil,

Training materials is really helpful. thanks for your effort.

I have one question.

As you said access level 1 to 19 used by product development team. If I use 20 instead of 100 or above changes to the workflow lost while oracle patching?.

Tha nks in Advance...

Tha nks & Regards,
Soma
Quote
0 #76 Soma 2007-08-07 22:01
Hi Anil,

Training materials is really helpful. thanks for your effort.

I have one question.

As you said access level 1 to 19 used by product development team. If I use 20 instead of 100 or above changes to the workflow lost while oracle patching?.

Tha nks in Advance...

Tha nks & Regards,
Soma
Quote
0 #77 Anil Passi 2007-08-08 05:17
Hi Soma

Yes, your changes will be lost, because you are simulating a scenario whereby "Second Oracle WF Patch" overrides the changes done by "First Oracle WF patch"

Also, even if you Check preserve customizations, that will only restrict 1-19 range from modifying. However 1-19 range is not applicable to business related changes to WF
Thanks,
Anil Passi
Quote
0 #78 Balaji gopalakrishnan 2007-08-16 10:08
hi all,
can someone tell me how to get the workflow details for an organization(pa rty).
Thanks
Quote
0 #79 Sankar.B 2007-08-16 13:53
Hi Anil,

I'm new to Workflow and I'd like to practice on workflow builder.
Plz suggest me the easy and right steps to start.Soon I will be required to
work on Workflow.And here our project schedule is very busy.Can u suggest me
and assist me to get some idea.

--Sankar ,
AP,India
Quote
0 #80 Anil Passi 2007-08-19 08:49
Hi Sankar

Simply install the 10g Client on your PC, that comes with Workflow Builder.

Once done that, you can replicate the workflow tutorial 1 at your end.

Thanks,
A nil Passi
Quote
0 #81 praneeth 2007-08-24 12:37
HI Anil

Its great we had good Idea about the oracle workflow, i am a production support person in T.Rowe price for Oracle financials, as the client needs some personalization of notification email we have change the HTML body, you didn't clearly explain how to create the HTMl body you would be very helpful for explaining this issue elobarated.
Quote
0 #82 Anil Passi 2007-08-24 12:57
Hi Praneeth

First ly you need to find out how the notification body was formed.
Usually , there are three methods:-
Optio n 1. Check the notification message, and there might be hardcoded HTML Message Text[with reference to some WF Variables]. This option is used for sending small messages, that have mainly static components

Opt ion 2. Check whether WF Notification Message, uses a WF Attribute of type Document
The value of the WF Attribute could be the name of pl/sql package procedure that spits out HTML
In this case, you need to modify that pl/sql package....[not ideal]

Option 3
Check whether WF Notification Message, uses a WF Attribute of type Document that points to a OAF Page. The value of WF Attribute at runtime would begin with OA.jsp?/oracle/ ....webui/..RN& param=xx
In this case, you can simply personalize/ext end the OAFwk region upon which WF Message is based

Thanks,
Anil Passi
Quote
0 #83 praneeth 2007-08-24 16:44
Hi anil

Thankyou very much for the cases but I am unable to relocate them properly
but I can provide you what that I have in text body as below

&PO_REQ_ APPROVE_MSG

&R EQ_LINES_DETAIL S

&ACTION_HIST ORY

so can you analyse the things and reply me back, its only problem that we have no documentation
Quote
0 #84 praneeth 2007-08-24 16:51
Hi anil

thanks for previous replies can you explain how do we import data into notifications from tables,
is it just palcing a sql query in text body or HTML body
Quote
0 #85 chowreddy 2007-08-25 07:01
Hi Anil,
Is there any way out to get the screenshots of Lesson 1, workflow?

Regards,
Saji th
Quote
0 #86 Anil Passi 2007-08-25 07:10
Hi Sajith

If you scroll down, on the tutorial, you will be able to pause/resume the tutorial and take screenshots.

T Hanks,
Anil
Quote
0 #87 Sharmila Mahapatra 2007-08-29 05:10
Hi Anil,

We have a client requirement to set the from clause in the notification to '' so that all users/employees will recieve notification from this email address.

We have custom workflow and have created a custom notification mailer attached to our custom workflow[using correlationid]. In the Message generation,Send , from clause we have specified this email address .
But all our notifications from this workflow are coming with from_user not being populated.

Regards,
Shar mila.
Quote
0 #88 Anil Passi 2007-08-30 05:55
Hi Sharmila

You can attach attributes similar to #FROM_ROLE to change the role.
This will be attached to the Notification/me ssage in WF builder.
Search for # in the dev guide, you will find the list of possible # that can be used to achieve this.

Thanks,
Anil Passi
Quote
0 #89 Arup Dutta 2007-08-31 12:07
Hi Anil,

The material is too good for Work Flow Developers. It would be better if you could please send me the links to download the material so that I can run it offline also.

Thanks & Regards,
Arup
Quote
0 #90 Anil Passi 2007-09-01 16:27
Hi Arup

Sorry this is available in online mode only

Thanks,
A nil
Quote
0 #91 hello 2007-09-04 10:08
why in the wf notificaitons table with the status of ERROR

how can i track this problem.could u please help me.
Quote
0 #92 Adipudi 2007-09-10 16:24
Thanks for these Articles, it would help a lot to the Learners, Job seekers and those on the project. Appreciate very much to share your knowledge to others
Quote
0 #93 Santhosh ND 2007-09-19 14:53
Dear Anil,
I am new to Oracle WorkFlow. I need one help from u.
Whenever the Employee is applying for a leave, the manager also able to view the net balance of that employee's Leave for which he applied. So Hw to customize the workflow and hw to identify the workflow and Notifications.. .
Thanks
Santho sh
Quote
0 #94 Santhosh ND 2007-09-20 14:00
Dear Anil
This is w.r.t. your reply to Praneeth earlier on 24,Aug 2007.
We arefacing a similar situation... Our Message Attribute is of this type:-
'JSP:/OA _HTML/OA.jsp?OA Func=-&HR_EMBED DED_REGION-&Ntf Id=-&#NID-'

Ho w do we go about personalising this WF message body and include additional details eg. Employees Current Leave Balance details???

Reg ards
Santhosh


>>>

Your reply to Praneeth earlier....was as below
written by Anil Passi , August 24, 2007
Hi Praneeth
Option 3
Check whether WF Notification Message, uses a WF Attribute of type Document that points to a OAF Page. The value of WF Attribute at runtime would begin with OA.jsp?/oracle/ ....webui/..RN& param=xx
In this case, you can simply personalize/ext end the OAFwk region upon which WF Message is based :) :)
Quote
0 #95 Mayuri 2007-09-21 13:48
Hi Anil,

Its a great training for beginners like me. Thanks for putting this together. I faced issue that audio streaming was not in sync with video straming. Can you upload it on youtube?
Quote
0 #96 Dabeyva 2007-09-29 16:45
this time a have a easy question
i wan to create a notification with from_role but i dont know why has a probrem
chek ...
is the first notification = peticion
messag e = redactarSolicit ud...
this is a error:


ORA-06 502: PL/SQL: numeric or value error: character string buffer too small
Error Stack
Wf_initia te.SetAttribute (BOXCHICA, 72, #FROM_ROLE#ROLE #, HR, HR)
Wf_Initiate .SubmitWorkflow (BOXCHICA, 72)


PLEASE HELP ME
Quote
0 #97 AK 2007-09-29 20:01
Hi Anil,
can we kick off payables Invoice approval workflow without distribution information(acc ount to charge)?
one of the requirement is to customize the payables invoice approval workflow to request the requestor for cost code(by workflow email)if the invoice doesn't have one.Then AP personnel will put in the cost code(manual process) and validate and resubmit the invoice for approval.but this time it will go through the invoice approval process as it contains a cost code/project code.
thanks for your help. much appreciated
Kum ar
Quote
0 #98 Anil Passi 2007-09-29 20:14
Hi AK,

Perhaps i haven't fully followed this question, but one thing is clear that your users want a facility to enter Cost Code within the email notification.

You can embed a OA Framework region that contains the relevant cost centres from LOV.
Effectivel y by embedding a OA Fwk region, you can make the users enter data via notification, just like they do so from screens.

Thank s,
Anil Passi
Quote
0 #99 Nimish 2007-10-05 10:24
Hi Anil,
Is it possible to view statuses of other users from status monitor without log in as sys admin. B'caz I have assigned myself resposibility but it just allows me to check statuses of WF owner by me.

Thanks,
Ni mish
Quote
0 #100 Anil Passi 2007-10-05 11:10
Hi Nimish

Please use the SQL below

update wf_resources set text = '*' where name = 'WF_ADMIN_ROLE' ;
commit;

Do not run this on production environment

Th anks,
Anil Passi
Quote
0 #101 PrasadRaj 2007-10-17 14:30
Hi Anil,
Your tarining sessions are exellent. I created sample you gave in the session1,nut after running the workflow i did not get e-mail notification. Can you please clarify any server(SMTP) configaration required.

Than ks,
Prasad
Quote
0 #102 Anil Passi 2007-10-18 05:11
Hi Prasad

Perhaps your notification mailer service is not running. Pls check with your DBA's

Also, ensure that you have followed the steps listed in www.google.com/search?q=site:apps2fusion.com+workflow-notifications-override-email-address-for-all-notifications-2 ,in case you are trying this on a non-production environment.

T hanks,
Anil Passi
Quote
0 #103 Zafar Sadiq 2007-10-23 11:44
Hi Anil
This Material has helped me a lot , Thanks :)
Quote
0 #104 Zafar Sadiq 2007-10-25 04:49
hi every one ,
I am new to this technology , I followed all the steps , but i unable to follow some of the last steps (i.e, Where can i find STATUS MONITOR PAGE) and how to observe the output
Quote
0 #105 ved 2007-11-12 21:09
Hi Anil,
it is amazing blog. i really need this kind of blog. i appreciate you.
i need help in workflow. can you send more documentation from basic to my email.
i am in learniing stage of apps, i am not able to run. i learn something after completing lesson 1st, but not able find the result. it is not able send me mail to my address.

thank s
ved
Quote
0 #106 Dheeraj Vernekar 2007-11-22 21:49
Dear Anil,

This is one of the best tutorial I ever seen in my life. I would like to suggest one thing for next tutorial. Please show the steps bit slower than what you showed now.

Regards
D heeraj
Quote
0 #107 Dheeraj Vernekar 2007-11-24 09:38
Dear Anil,

I am not able to find the code you written for below procedures
is_po_valid
se t_wf_approver_r ole
set_wf_stat us_to_validated
start_training _wf. This is very imp for Workflow begineers. Please update the same online or mail me across.

Thanks and Regards
Dheeraj
Quote
0 #108 Dheeraj Vernekar 2007-11-24 09:49
Dear Anil,

Apology for above comment. I have not checked code properly.

Than ks
Dheeraj
Quote
0 #109 Anil Passi 2007-12-07 15:22
No worries Dheeraj
Quote
0 #110 Sachin Ahuja 2007-12-10 07:08
Hi Anil,

I know it's very late to come and ask something on this Training Part. But I guess I've no other option too...

I've done the steps and all is working fine.

My question is we've defined attrbute send_to_email and are assigning email address to it and same is the case for role. Not which part in workflow will actually send the notification to my Role. As we've just defined the role and I'm not getting which api is sending the notification actually. Suppose instead of send_to_email I define attribute send and will assign my email address to it. Now which api will send the notification.

I hope I am clear in stating where I'm confused. If not please let me know I will write in more detail.

Regard s
Sachin Ahuja
Quote
0 #111 Sachin Ahuja 2007-12-10 10:41
Hi Anil,

I got it. This we are acheiving thru Setting attribute under Node tab of Notification.

Well now I am stuck at one more place

I am working on sending notification from workflow and want to access somewhat below kind of information from table

Order Item salesrep prodmgr
______________ __________
1 1 X P1
1 2 X P2
1 3 Y P1


Now I want to send notification to salesrep and prodmgr seperately based on order number. So below will be some notifications which I'll be sending


Notification 1
SalesRep X
1 1 X P1
1 2 X P2

Notification2
SalesRep Y
1 3 Y P1

Notification3
P1
1 1 X P1
1 3 Y P1

Notification4
P2
1 2 X P2


I am having prob at Notification1 & Notification3 where I have multiple records to be send in single notification and I am stuck at how I can achive this.

Thanks in advance for your kind help.

Regards
Sachin Ahuja
Quote
0 #112 Soham K 2008-01-16 22:43
Hi,
Presentatio n is not working.

Regar ds,
Soham
Quote
0 #113 Pradeep_B 2008-02-04 16:27
Hi Anil,

This is an excellent material for beginners like me. I have one question, after i have customized a workflow and stored it in the database, what are the various methods in which i can initiate my workflow. Is it possible to write a procedure in a database trigger which initiates a workflow or is there any special method to invoke it.
Please help.....

Rega rds,
Pradeep B
Quote
0 #114 SumitBansal 2008-02-11 17:16
This is something called Amazing..I haven't seen such a wonderful training from a layman perspective on workflow. I'hv heard your name a lot but now I am a admirer..
Rock it like this in all future presentation.
Quote
0 #115 ar jabir 2008-02-20 11:09
Hi Anil,
thank you very much for the great tutorial... is there command lines for me to control workflow processes (start and stop, monitor) after I build it using the workflow builder?
thanks in advance.
rgds

ar jabir
Quote
0 #116 VENKATA RAMANA 2008-02-26 11:49
Hi Anil,

I had gone through u r tutorials and they are simply superb.

I want one help from u r side like i want a link in Purchase order approval where i can go through the requisition details.

Can u please tell me how we can acheive.
My basic idea is i need to send description as www.google.com so when a person is approving purchase order he should click the description(In our case www.google.com),and he should be able to see google.com.


P lease tell me .........Thanks in Advance
Quote
0 #117 mythili 2008-02-28 08:12
Hi,

I like to know what are all the ways i can trigger the workflow.
one way is th'gh database trigger
Another way is th'gh Alert.
What else ways are there to trigger a workflow.Can u give me some example?

Is the Human Resource self-service pages works with workflow?
Thank s,
Mythili
Quote
0 #118 sai krishna aravapalli 2008-03-15 23:26
HI anil,
wonderful no one ever in worldwide web we couldn't find any materail for workflow but u did it it will be a lot helpful for beginners.
coul d suggest me a way of approach in learning oracle apps sepcially financials
Thanks & Regards
krishna
Quote
0 #119 Raja c 2008-03-19 19:55
Hi Anil, It is very nice tutorial. Appreciate your effort in placing such a nice one on the net for starters.
regar ds
raja
Quote
0 #120 Basavanagowd 2008-05-07 13:24
Hi Anil,
Thank u so much,
Requires to customize the Purchase Requisition Approval Notification,ne ed to display the additinal information like Onhand Quantity ,Quantity on Order ,Quantity in Requisition against the respective Item Code in the Approval Notification Page.
So, Please let me know how to achive this requirement.

T hanks a lot

Regards,

B.Gowda
Quote
0 #121 V Kumar 2008-07-18 01:25
Hi Anil,
Your articles are really very good.
I have downloaded Workflow on my laptop, and configured with the database. I do not have oracle ebs, can I run my workflow processes without having EBS, if yes how.
Thanking you in advance.
v kumar
Quote
0 #122 Anil Passi 2008-07-30 16:43
You can but thats not an ideal approach.
You will require access to Oracle Apps Database, otherwise you will have to install standalone workflow patches on plain Oracle DB[which is not unsupported]

T hanks,
Anil
Quote
0 #123 Sameer 2008-08-06 03:04
Hi Anil,

my requirement is to call the oracle approval hierarchy in the workflow.. can u please guide me in this...

Thanks ,
Sameer
Quote
0 #124 Tony 2008-08-12 08:14
Hi Anil,

I ran the example workflow and i have some issues on this

1. when the role is a Fnd_user i am getting a Notification
2. But I am not getting a e-mail notification
3. My mailer is up
4. In wf_notification table the mail_status='FA ILED' status='closed'

Pls give a solution

Thanks
Tony
Quote
0 #125 Shiau Chin, Teo 2008-12-14 21:12
hi, my name is shiau chin.
i am facing problem in HR workflow. i would like to include the absence details (embedded region) into FYI notification.
c an you kindly advise me.
thks.
Quote
0 #126 XYZ 2009-01-10 00:47
Hello all, congrats to every one for going through this presentation.
Quote
0 #127 srinivasan dhanabal 2009-01-27 09:02
I need to send a notification to all the FND users,How can i send the notification to all the users .
If i creating a role and adding all the users to that role its fine. but the problem is ,if a new user has created later,that particular user will not be in the role . So the notification will not go the new user created .

Please help me in this ASAP.Its very Urgent.

Thanks in Advance

Sriniv asan.D
Quote
0 #128 Anil Passi--- 2009-01-28 05:08
Hi Srivini

You can subscribe to business event oracle.apps.fnd .user.insert
In the pl/sql subscription, simply add the new fnd_user to the existing global role.

Thanks,
Anil Passi
Quote
0 #129 srinivasan dhanabal 2009-01-29 01:07
Thanks a lot for ur valuabale solution anil.

Thanks &Regards
Srinivasan.D
Quote
0 #130 srinivasan dhanabal 2009-01-30 06:21
Hi Anil,

In my custom workflow ,in notification ,From user is not coming ,how can i show the From user in the notification page and it is not updating in wf_notification s/From _user column also .

Wat i have to do for this .Can u please help me in this.
Quote
0 #131 srinivasan dhanabal 2009-02-01 01:41
Dear Anil,

Please help me in this.

In my custom workflow ,in notification ,From user is not coming ,how can i show the From user in the notification page and it is not updating in wf_notification s/From _user column also .

Thanks in Advance.
Quote
0 #132 Anil Passi-- 2009-02-01 02:45 Quote
0 #133 shishu paul 2011-04-25 03:08
Dear Anil,
I downloaded the source and upload the WFT file to my database. Created table, package and inserted the data in the table and executed this process throgh TOAD and verfified from backend that there is an data for these process (WF_ITEM_ACTIVI TY_STATUSES, WF_ACTIVITIES). But not received any email on any email id.

Thanks & Regards,
Shishu Paul
Quote
0 #134 Jithinraj 2011-08-07 04:32
Dear Anil,

Thank you for such a wonderful tutorial....

T hanks & Regards

Jithin raj
Quote
0 #135 JayaRam Choudary 2012-02-25 09:50
Really..Really. ...Superb...... .......
Thank u very much for ur extra-ordinary material....... ............... .........
Quote
0 #136 umair aslam 2012-04-30 02:23
Dear Anil,

I want to add a column from Requisition Lines to standard notification which is called by the following function."JSP:/ OA_HTML/OA.jsp? OAFunc=ICX_POR_ REQLINES_NTFN&r eqHdrId=-&DOCUM ENT_ID-&contReq Flag=-&CONTRACT OR_REQUISITION_ FLAG-&funcCurr= -&FUNCTIONAL_CU RRENCY-&contSta tus=-&CONTRACTO R_STATUS-&suppl EmailNotAvail=- &IS_SUPPLIER_EM AIL_NOT_AVAIL-& vendor=-&VENDOR _DISPLAY_NAME-& contAssignReqd= -&CONTRACTOR_AS SIGNMENT_REQD-" ,

Please assist in this regards.

umair
Quote
0 #137 RajuNN 2012-05-01 15:01
Dear Anil,

I am not able to open 'workflow training lesson1'.
Would you please send it to my mail id.

Thanks,
NN Raju
Quote
0 #138 NNRaju 2012-05-01 15:07
Dear Anil,

I am not able to open 'workflow training lesson1'.
When I click link it is showing error : 404 not found.
Remainin g workflow lessons opening fine.
Would you please send it to my mail id:

If any one has 'workflow lesson1', please send it to me.

Thanks,
NN Raju
Quote
0 #139 Ritu Singh 2012-05-24 06:37
Hi Anil,
I am new to Workflow. I have made the workflow similar one as given in this lesson.
I am able to search the workflow type which i have created but after clicking GO, it shows no workflows found.
Please help.
Quote
0 #140 Syed Ali Shah 2012-07-03 06:13
Hi Anil,
I get the below error, intermittently, when some manager tries to approve SSHR requests. the error is

Attriute HR_NTF_EMBEDDED _REGION with value JSP:/OA_HTML/OA .jsp?OAFunc=-&H R_EMBEDDED_REGI ON-&NtfId=-&#NI D- refers invalid framework URL

Please have your say on how to sort this issues?

Thanks ,
Syed Ali
Quote
0 #141 Rohini 2012-11-30 05:14
Hi Anil,

Unable to get any of the material off of the links specified at the end of the Wqorkflow Lesson 1 page.
Would you please email those to me?

Thanks

Ro hini
Quote

Add comment


Security code
Refresh

Search Trainings


Enquire For Training

Related Items

LOGIN

About Apps2Fusion

Apps2Fusion are passionate about training. Trainnig is our core business and we have been doing this for many many years. We thrive to meet expectations of our trainees. We work hard to ensure trainees get the right courses sold to them, with advise for their career paths. We have helped many consultants in past with training & mentoring and  we have helped them achieve great heights. We could help you as well. Get in touch with us.