Training Lesson 2 For Oracle WorkflowsLesson 2 of Oracle workflows training is now available. Thanks to all those who responded with their feedback for Workflow Training Lesson 1 (Audio Visual)In this lesson we are going to learn:- 1. How to create new lookups in workflow. 2. How to provide a drop down list in notification to user. User will be select the response(approve or reject) from drop down list. 3. How to make a user enter rejection reason in free text response field within notification. 4. Validate that the value of rejection reason is not null, if user selects rejected. Effectivley this will train you on how to do validations on notification responses using pl/sql. To access the second Lesson of Oracle Workflows Training please visit Oracle Workflow Training Lesson 2 Please feel free to either leave a comment or shoot an email to me. Kindly note that this lesson is in draft version, hence I am happy to add further explanations if need be. Upcoming future lessons: Workflow training Lesson 3. How to make a generic step in oracle workflow, by passing parameters. This can be useful when you wish to display progress in some screen. This also happens to be a widely used concept in account genrators. Workflow training lesson 4. Raise event to execute an Oracle Workflow Process. Workflow training lesson 5. How to generate notifications from servlet styled pl/sql If you would like to learn some other aspect of Oracle Workflow in Apps, please feel free to contact me. |
About Me
- Name: Anil Passi
- Location: United Kingdom
The desire to be extraordinary is a very ordinary desire. To relax and to be ordinary is really extraordinary
Previous Posts
- Oracle GL Interface API General LedgerPlease find ...
- Account Generator Workflow Example This article...
- Apps Technical Interview QuestionsPlease note that...
- Training Lesson 1 for Oracle WorkflowsPlease find ...
- Forms Personalization in Oracle Apps 11.5.10>My fi...
- ReBuild Account in Oracle iProcurementNote: If usi...
- Oracle AR Receipt APIBack in year 2002, when worki...
- Oracle Read Only APPS Database SchemaIn this artic...
- Blob as Oracle Workflow AttachmentPlease find a 4 ...
- Create FND_USER with System AdministratorIf you ha...
Comments on ""
My viewpoints:
The audio-visual sessions are good. They are able to provide more info is less time. They make us learn quickly and also, all steps are seen without missing any. They seem exhaustive.
-Amrut
Hi Amrut,
Thanks for your response. Given the mized opinion I have received, my future strategy is going to be, to have Audio-Visuals for bits that are complicated to understand. For the medium complexity training sessions, I will stick to Screenshots.
Thanks,
Anil Passi
Hello Anil ,
Thank you very much for your workflow tutorials . They are informative for a beginner like me.
I have one doubt. The notification you created in lesson 1 is based on role(on the fly role :)), created through email address(anilpassi@gmail.com).
Then how come a notification is received on Oracle Apps in Lesson 2.
Thank you,
Srikanth
Hi Sri
the notification in lesson 2 requires a response.
first lesson notification was FYI
thanks
anil
hi,Anil ur doing a fantabulous job.the work flow training session was great.
my question is how to compile the workflow,do we need to place the .wft file in the databse.after compiling when we go to wf builder and say browse from the data base can we get our customized .wft.have u got any relevant data in regards with that.
Regards
sritha
When you save a workflow file in workflow builder, you will get errors and warnings if there are errors.
To load into database using script, use the script named WFLOAD
Thanks
Anil
Hi Anil, I want to block certain mails into workflow notification mailer like the mails which are having 'Out of office' as subject. Please let me know how can I acheive this.
Pls. reply ASAP as this has become a show stopper.
Thanks & Regards,
Vamsi.
Hi Vamsi,
I beleive you need to setup such rules within the mail server itself.
Otherwise, for each role you will have to set re-direction rules which isn't certainly ideal.
Thanks,
Anil Passi
@ Anil,
I have a requirement. consider that am receiving FYI e-mail notification. I need to respond from the e-mail and raise a event to launch a workflow. is there anyway i could respond from FYI notification and handle it on server side. I dont want to use response type notification bcos it always prompts for a response, but i need optional response.
Hi Sir.
This is Manojit.
I am very new in Oracle Apps.
I am unable to understand what'context_nid' procedure done?
l_nid := wf_engine.context_nid
Hi Sir.
This is Manojit.
I am very new in Oracle Apps.
I am unable to understand what'context_nid' procedure done?
l_nid := wf_engine.context_nid
Hi Sir.
This is Manojit.
I am very new in Oracle Apps.
I am unable to understand what'context_nid' procedure done?
l_nid := wf_engine.context_nid
Hi,
Once,we create Attributes(Attributes are acts like global variables),why should we drag and drop in messages?. The scope of Attribute is Item_type.
regards
srinu
Hi,
Once,we create Attributes(Attributes are acts like global variables),why should we drag and drop in messages?. The scope of Attribute is Item_type.
regards
srinu
Hi Anil,
I did SQL, PL/SQL Certification,
I have some knowledge about Oracle Forms and Reports 10g.
I am searching the job.I don't have experience of sql, plsql project.
Now planing to do Oralce Apps.
before doing oracle apps what things, technology should I know?
I am very confused to do or not.
Plz suggest as soon as possible.
hiiiiii iam new for oracle apps workflow pls explain about workflow basics means purpose of workflow
Hiiiii
im new for oracle apps workflow can u explain purpose of workflow basics.......pls