Main Menu
| Home |
| Technical Articles |
| Training Articles |
| Receive Email for New Articles |
| Contributors |
| Apps Book |
Related Items
- The purpose
- Oracle Workflow Notifications Timeouts with Bank Holidays & Weekends
- Payroll Costing in Oracle
- Audit Trail in Oracle HRMS
- Restart or Bounce Apache in Oracle Apps 11i
- Oracle HRMS Payroll Interview Questions
- Receipt API in Oracle Receivables
- Encumbrance Migration to Oracle Grants for Open Purchase Orders
- Create Oracle FND_USER with System Administrator
- Customization and Development Book
- XMLImporter in Oracle Applications Framework
- Send binary attachments with Notifications in Workflow
- Read Only Schema in Oracle APPS 11i
- iProcurement 11.5.10 ReBuild Charge Account
- Forms Personalization in Oracle HRMS
- Oracle Account Generator Workflow Example
- Technical Interview Questions in Oracle Apps
- Oracle Workflows Training Lesson 2
- Oracle Workflows Training Lesson 3
- Future of TCA - Fusion & Release 12
- A New Custom Form in Oracle Apps
- Install tools for Oracle Apps Development
- Concurrent Programs in Oracle Apps
- Concurrent manager in Oracle Apps
- Value set basics in Oracle Apps
- Lookup Types and Lookup codes in Oracle Apps
- Context Sensitive Descriptive Flexfields
- Descriptive Flexfield Basics in Oracle Apps
- Workflow Notifications - Override Email address for all Notifications
- Forms Customization Steps in Oracle Applications
- FNDLOAD for Oracle Web ADI
- iProcurement Interview Questions In oracle
- Splitting the instance into different Set Of Books
- Oracle HRMS API Employee People Migration
- HRMS Person Address Migration
- Migrate Special Information Types in HRMS
- Basic Concepts - List of useful Oracle Apps Articles
- FND Debug Log - Debugging Oracle Apps code
- Oracle HRMS Profile Options
- Customization of Reports in Oracle Apps
- Audit Trail in Oracle Apps - EBS
- Open Interfaces in APPS EBS - Best Practices
- Java Concurrent Programs in Oracle
- Payroll Elements and Element Links
- Balances in Oracle HRMS Payroll
- Oracle HRMS Payroll Tables
- Oracle HRMS Payroll Training
- Oracle Workflows Training
- Important Payroll Screen
- Workflows [Business Events] Training Lesson 4
- Install VMWare XP for Oracle SOA Suite
- Install SOA Suite Companion CDs
- Validate your SOA Suite Install on PC
- List of Business Events in 11.5.10
- Oracle Workflows Events with Payload-Part 1
- Workflows Events with XML Payload Part 2
- Workflow Business Events XML Test Payload
- OA Framework with Captcha Webservice
- Oracle Payroll Tables
- Oracle HRMS Tables
- Oracle iRecruitment Applicant and Row Level Security
- Transfer Workflows business events
- Scripts for iProcurement - XML Delivery load testing
- Oracle Technical and Apps Functional Demo
- Oracle Workflows Access Protection Concepts
- What is Oracle ESB - Enterprise Service Bus
- Procure to Pay - Order to Cash - End to End Cycle Functional Documents
- Training Seminar in Denmark
- OA Framework Training Tutorial 03
- Network Latency Tests in Oracle EBS
- Oracle ACE
- Invoke Discoverer Report from Oracle Applications
- Basics of Accounting in Oracle ERP/EBS Part II Case Study and Powerpoint Presentation
- Pooled Account in Oracle Payables
- Contingent Worker in Oracle HRMS
- Preserve Customizations to Oracle Workflows
- Debug Forms in Oracle eBusiness Suite
- Audit Changes in Oracle HRMS
- Flow of Accounting in Oracle Applications
- Triggers in Oracle HRMS and Payroll
- Dynamic Triggers in HRMS Payroll - Demo
- Factors effecting SQL Results in Oracle Apps
- Workflow Different Roles, Types of notifications, Events and Workflows Best Practices
- Sample Code and Output- Run WF API
- WF Notification API Install
- Open Source in Oracle Apps - Generic Workflow Notification API
- How to send HTML Based Notification by a mere PL/SQL Call?
- User Productivity Kit in Oracle
- MWA Setup, Testing, Error Logging and Debugging
- Troubleshoot Business Event Subscription Processing
Home 
Technical Articles Oracle Workflows Oracle Workflow Training Lesson 1
Technical Articles Oracle Workflows Oracle Workflow Training Lesson 1 
Also see here fully verifiable feedbacks/testimonials
| Oracle Workflow Training Lesson 1 | | Print | |
| Written by Anil Passi | |
| Tuesday, 12 September 2006 | |
|
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. 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. 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
(119)
 written by Syed rahman , October 26, 2006
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.
written by Anil Passi , October 27, 2006
Hi Syed,
You are most welcome to ask questions. Thanks, Anil Passi written by Mohammed Abdur Rahman , November 05, 2006
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. written by ajay singh , November 12, 2006
hai i m ajay singh . i m new for oracle apps 11i can you suggest me by that i can improve my self
ajay written by ajay singh , November 12, 2006
hai i m ajay singh . i m new for oracle apps 11i can you suggest me by that i can improve my self
ajay written by Anil Passi , November 15, 2006
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... written by Anil Passi , November 15, 2006
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... written by Dharam , November 16, 2006
Excellent training material for beginners on WF.
written by Dharam , November 16, 2006
Excellent training material for beginners on WF.
written by CT , November 21, 2006
Very cool except the noise disturbance. I am wondering is this the same as the one in OWB.
written by Workflow , November 21, 2006
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(debugging). Thank you Sasidhar.P written by Anil Passi , November 21, 2006
Hi Dharam
This is not the same as OWB. OWB is a different tool altogether. Hi Sasidhar, Thats a good idea. I will write something on debugging tricks of Oracle Workflows. Thanks both, Anil Passi written by CT , November 21, 2006
Very cool except the noise disturbance. I am wondering is this the same as the one in OWB.
written by Workflow , November 21, 2006
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(debugging). Thank you Sasidhar.P written by Anil Passi , November 21, 2006
Hi Dharam
This is not the same as OWB. OWB is a different tool altogether. Hi Sasidhar, Thats a good idea. I will write something on debugging tricks of Oracle Workflows. Thanks both, Anil Passi written by Uri Kimchi , November 22, 2006
U did a great job.
10x a lot. written by Uri Kimchi , November 22, 2006
U did a great job.
10x a lot. written by Mckan Colaco , November 23, 2006
hi Anil..Your workflow lesson 1 was very helpfull. one problem how do i edit the links with yes/no options.. on the diagram
written by Anil Passi , November 23, 2006
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 written by Mckan Colaco , November 23, 2006
hi Anil..Your workflow lesson 1 was very helpfull. one problem how do i edit the links with yes/no options.. on the diagram
written by Anil Passi , November 23, 2006
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 written by Prabhat Jha , November 30, 2006
Hi Anil,
Thanks For Such A nice Article. Its tremendous for beginners. Thanks once again. Prabhat Jha written by Prabhat Jha , November 30, 2006
Hi Anil,
Thanks For Such A nice Article. Its tremendous for beginners. Thanks once again. Prabhat Jha written by Anil PAssi , December 06, 2006
I know this software sucks, I had my fingers burnt too when replying to questions.
To 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. Thanks Anil written by Anil PAssi , December 06, 2006
I know this software sucks, I had my fingers burnt too when replying to questions.
To 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. Thanks Anil written by Ashish Arora , December 15, 2006
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 written by Anil Passi , December 15, 2006
Hi Ashish,
I will cover workflow event in detail, with examples within next weeks timeframe. Events are important, as they fit into Fusion strategy too. Thanks, Anil Passi written by Ashish Arora , December 15, 2006
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 written by Anil Passi , December 15, 2006
Hi Ashish,
I will cover workflow event in detail, with examples within next weeks timeframe. Events are important, as they fit into Fusion strategy too. Thanks, Anil Passi written by SATHEESH KUMAR , December 17, 2006
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 Satheesh Kumar written by SATHEESH KUMAR , December 17, 2006
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 Satheesh Kumar written by Anil Passi , December 21, 2006
Hi Ravi, The Zip File does not contain the PL/SQL Code where you are creating and starting the process.
Please can you include all the scripts. Thanks, Anil written by Anil Passi , December 21, 2006
Hi Ravi, The Zip File does not contain the PL/SQL Code where you are creating and starting the process.
Please can you include all the scripts. Thanks, Anil written by Anil Passi , December 23, 2006
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 written by ravi , December 23, 2006
http://www.bobshare.com/file.p...0fdd66593a
The script file along with screenshots. Thanks and regards ravi written by Anil Passi , December 23, 2006
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 written by ravi , December 23, 2006
http://www.bobshare.com/file.p...0fdd66593a
The script file along with screenshots. Thanks and regards ravi written by Vidyasagar Kulkarni , December 25, 2006
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. Thanks and Regards Kulkarni written by Vidyasagar Kulkarni , December 25, 2006
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. Thanks and Regards Kulkarni written by Anil Passi , January 02, 2007
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. Thanks Anil Passi written by Anil Passi , January 02, 2007
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. Thanks Anil Passi written by Anil Passi , January 03, 2007
.
. . 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. Thanks, Anil Passi . . . written by Ahmer , January 03, 2007
Dear Anil,
I have found the access field & a check box in Help menu but I have no idea what to do. written by Anil Passi , January 03, 2007
.
. . 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. Thanks, Anil Passi . . . written by Ahmer , January 03, 2007
Dear Anil,
I have found the access field & a check box in Help menu but I have no idea what to do. written by Anil Passi , January 18, 2007
Hi Sri,
Sorry to hear this happened. Although I did warn in FNDLOAD article TO BE CAREFUL when moving around GL Value Sets. This was stated in http://oracle.anilpassi.com/or...les-2.html 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. Thanks, Anil Passi written by Anil Passi , January 18, 2007
Hi Sri,
Sorry to hear this happened. Although I did warn in FNDLOAD article TO BE CAREFUL when moving around GL Value Sets. This was stated in http://oracle.anilpassi.com/or...les-2.html 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. Thanks, Anil Passi written by Sandeep Somvanshi , January 29, 2007
Hello Anil,
Can you please give me some idea about the retention period of any Workflow. Thanks and Regards, Sandeep Somvanshi written by vineet , February 07, 2007
Good work Anil!
written by Mrunalini , February 14, 2007
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. Please help. Regards, Mrunalini written by imran , March 19, 2007
Hello Anil.
My question to you is that...where do you invoke the SFM_CALL_PROCESS_ORDER from? (display name: invoke service fulfillment manager, icon: DB_INS.ICO, XDP_SFM_SR_WF.CALL_PROCESS_ORDER). 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 Thanks written by Anil Passi , April 02, 2007
Thanks Kishore.
written by amit , April 03, 2007
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.
Thanks in advance, Amit written by Muralidhar , April 26, 2007
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 Murali written by Anil Passi , April 26, 2007
Hi Murali
Its usually in $MODULE_TOP/patch/115/import/US However you can always do this command on $MODULE_TOP find . -name *.wft -print Thanks Anil Passi written by Munaz , May 15, 2007
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 Munaz written by anil , May 15, 2007
what parameters are you passing to check the status?
written by Munaz , May 15, 2007
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. Regards Munaz written by sundar , May 17, 2007
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? Thanks Sundar written by Anil Passi , May 17, 2007
Hi Sundar
What parameters are you passing for Status Monitor screen? Please do a select on table WF_ITEMS, and you should find and entry there. Thanks, Annil written by Anil Passi , May 18, 2007
Hi Sundar
Thanks for sharing this with everyone. Cheers, Anil written by diwakar , May 29, 2007
Hi Anil,
Can you provide more documents on trouble shooting existing workflows? Thanking You written by Anil Passi , June 20, 2007
Hi Diwakar
There 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 Thanks, Anil Passi
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
Hi Sambit
Please use FND_SUBMIT API to submit request sets It has following APIs fnd_submit.set_mode fnd_submit.set_nls_options fnd_submit.set_repeat_options fnd_submit.set_rel_class_options fnd_submit.set_print_options fnd_submit.add_printer fnd_submit.add_notification fnd_submit.set_request_set fnd_submit.submit_program fnd_submit.submit_set Search on Metalink for FND_SUBMIT and you will find the some sample code Thanks Anil Passi
Thank's For your Advise .
I will try it still if i have any issue i Will come to you. thanks Sambit
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.
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
Hi Sambit
You can use fnd_request.submit_request from pl/sql to submit requuests This pl/sql can be called from workflow activity Thanks, Anil
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. please help me
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?? Appreciate & 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.
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. Thanks Anil
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_notifications, from_user columns is not populated and to_user has the email address. Rajesh
Hi Raj
Please check the value in column RECIPIENT_ROLE, in wf_notifications. Once you have that value, examine wf_local_roles to see which user/person that role points to. Thanks, Anil Passi
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?. Thanks in Advance... Thanks & Regards, Soma
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?. Thanks in Advance... Thanks & Regards, Soma
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
hi all,
can someone tell me how to get the workflow details for an organization(party). Thanks
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
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, Anil Passi
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.
Hi Praneeth
Firstly you need to find out how the notification body was formed. Usually, there are three methods:- Option 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 Option 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¶m=xx In this case, you can simply personalize/extend the OAFwk region upon which WF Message is based Thanks, Anil Passi
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 &REQ_LINES_DETAILS &ACTION_HISTORY so can you analyse the things and reply me back, its only problem that we have no documentation
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
Hi Anil,
Is there any way out to get the screenshots of Lesson 1, workflow? Regards, Sajith
Hi Sajith
If you scroll down, on the tutorial, you will be able to pause/resume the tutorial and take screenshots. THanks, Anil
Hi Anil,
We have a client requirement to set the from clause in the notification to 'noreply@clientmail.com' 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, Sharmila.
Hi Sharmila
You can attach attributes similar to #FROM_ROLE to change the role. This will be attached to the Notification/message 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
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
Hi Arup
Sorry this is available in online mode only Thanks, Anil
why in the wf notificaitons table with the status of ERROR
how can i track this problem.could u please help me.
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
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 Santhosh
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?OAFunc=-&HR_EMBEDDED_REGION-&NtfId=-&#NID-' How do we go about personalising this WF message body and include additional details eg. Employees Current Leave Balance details??? Regards 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¶m=xx In this case, you can simply personalize/extend the OAFwk region upon which WF Message is based 
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?
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 message = redactarSolicitud... this is a error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Error Stack Wf_initiate.SetAttribute(BOXCHICA, 72, #FROM_ROLE#ROLE#, HR, HR) Wf_Initiate.SubmitWorkflow(BOXCHICA, 72) PLEASE HELP ME
Hi Anil,
can we kick off payables Invoice approval workflow without distribution information(account 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 Kumar
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. Effectively by embedding a OA Fwk region, you can make the users enter data via notification, just like they do so from screens. Thanks, Anil Passi
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, Nimish
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 Thanks, Anil Passi
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. Thanks, Prasad
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 http://oracle.anilpassi.com/wo...ons-2.html ,in case you are trying this on a non-production environment. Thanks, Anil Passi
Hi Anil
This Material has helped me a lot , Thanks
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
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. thanks ved
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 Dheeraj
Dear Anil,
I am not able to find the code you written for below procedures is_po_valid set_wf_approver_role set_wf_status_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
Dear Anil,
Apology for above comment. I have not checked code properly. Thanks Dheeraj
No worries Dheeraj
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. Regards Sachin Ahuja
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 Notification1 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
Hi,
Presentation is not working. Regards, Soham
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..... Regards, Pradeep B
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.
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
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. Please tell me .........Thanks in Advance
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? Thanks, Mythili  written by sai krishna aravapalli , March 15, 2008
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. could suggest me a way of approach in learning oracle apps sepcially financials Thanks & Regards krishna
Hi Anil, It is very nice tutorial. Appreciate your effort in placing such a nice one on the net for starters.
regards raja You must be logged in to a comment. Please register if you do not have an account yet.
|
Subscribe to this comment's feed
