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
Apps2Fusion Articles 
Comments
.
.
.
Whi ch 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.
.
.
.
.
.
Regard s!
.
.
.
Whi ch 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.
.
.
.
.
.
Regard s!
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....
Excell ent 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
Simply remove that FYI notification activity from the workflow.
Th anks,
Anil Passi
Is there no link for Order management and inventory. It will be great hep for the manufacturing people.
Than ks,
Joydeep
Re gards,
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
I am really surprised/amaze d to find your patient replies to lots n lots of queries floating around.
Hats off to your effort.
Keep up the good work..
Regar ds,
Uttam
-- An enthusiastic new entrant to OWF
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.start process. 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.
Have a look at FND_WF_STANDARD .submitconcprog ram and FND_WF_STANDARD .waitforconcpro gram
This WF API has provision to submit request. After the request is completed, the API will push the workflow forward.
Searc h on these APIs within documentation.
You will need to define wait activity just after the executeconcprog ram.
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,
A nil Passi
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.
Wor th going through it.
Thanks once again.
Regards ,
Chirag
Apprecia te ur commendable effort.
It will be very helpful, if the workflow training lessons are downloadable. I there any way out to download.
Rega rds,
Sajith
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/notificat ions, 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
A nanth
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..et c. on notification.
O nce 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
F ahad
Could u please answer my above specified query?Really need ur help.
Thanks in Advance.
Fahad
I am new to this site.first of this is damm good and the info provided here is very helpful.
Actual ly 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?
Plea se help me in this...
Basava
Vijayawada,AP.
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
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...
Than ks ,
Basava.
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.
Thank s & Regards
Kamal
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
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,
Dh ritiman Maitra
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,
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
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.T o 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
sudhe er G kumar
sudheergbe
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.
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'.
d o we need this status as running to send e-mail notification.(n ot only to a single mail for diffrent mails also do we need that in running mode).
Thanks
sudheer G
sudheer
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
R am
work flow video tutorials
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
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.
Rega rds,
Ramakrishn a.
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)
regard s
Tamil
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?
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.appropriat e?
Regards
Manoh ar
Iam new to workflow and I need your advice on one of our business requirements.
W henever 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.
t hanks
Bhanu
we have getting below error when lauching the wf
ORA-06550: line 1, column 7:
PLS-00201: identifier 'XDP_SFM_SR_WF. CALL_PROCESS_OR DER' must be declared
ORA-06 550: line 1, column 7:
PL/SQL: Statement ignored [Error Process Error: 3116: Activity 'WFERROR/SERVER EQ_ERROR' is not a runnable process.]
Rega rds,
Kishor
I am very very new to workflow. Can you please guide where to check for the .wft files created.
Anil
Thanks for your Workflows [Business Events] Training Lesson 4 ,I have done that succecfully.But when I am trying to raise a event by creating an event in
workflow builder.In that event I am calling a Procedure which is inserting value to a custom table.While submitting the item I am getting the error
Error Name: WFSQL_ARGS
Error Message: 3000: Invalid value(s) passed for arguments. #EVENTKEY=
Error Stack: Wf_Engine_Util. Event_Activity( XX_ITEM, 3421, 1100872, RUN)
So can you help me out.
Regards,
Subodh
Thanks for your link, I am able to create and raise a event through event manager.The same thing I want to do by using only workflow builder,by creating a
event activity or give me some link where I can find example of custom build wf multiprocesses, critical decision making processes.
Tha nks
Regards,
sub odh
Could you please let me know what is required for an oracle apps dba to know about workflow?
Than ks in advance
Th anks in advance. Love your tutorials. They were a great help.
As per my workflow requirement, I should send notifications to Multiple Users, so I am creating a AdhocRole,
under the AdhocRole, i am adding my all users. In the Workflow Notification i am sending the AdhocRole Name as Performer.
Now the all users getting Notificatiions with AdhocRole Name.but my users don't want the AdhocRole name in notifications ,
instead of they want users name in Notification.Pl ease tell me , is it possible. if it is possible , tell me how we can do ?
Thanks for developing such a wonderful and handy site.
I have a question regarding Remiinder Notifications for All HR Notification.
Just wanted to know whats the process to send the 1st and 2nd reminder notifications for all the HR notifications which are not addressed in given time.
I have a fare idea about setting timeout in PO approval workflow but have no idea about HRMS.The workflow used here is an Standard workflow.
And the reminder should be sent to all the HR Notification irrespective of category.
Appr eciate your help.
Thanks,
divya
Thanks
Josephin
You ca subscribe a WF to these business events
Search for business events on this website, there are tutorials that explain how this can be done
Thanks,
A nil Passi
i tired this on one of the test instance of my office.
the status shows it is comepete,on the status diagram also it shows everything. the activity history shows all activites between start and end.
does something needs to be enabled on the front end side, so that i receive emails .
i sent an email to ramki
same as your example.
pleas e let me know, if their something which i may missed ot needs to cross check
Thanks,
Ramki
I tried your first example in lesson 1 I am getting the below error message . I created and executed the package in apps schema.
*
ERROR at line 1:
ORA-20002: 3114: Activity 'XXXXPTR/MAIN_T RAINING_PROCESS ' is not a process.
ORA-06 512: at "APPS.WF_ENGINE ", line 3920
ORA-06512: at "APPS.XXXX_PO_W F_TRAINING_PKG" , line 96
ORA-06512: at line 3
Can you please let me know what need to done to fix this.
Thanks
Sr eelesh
I keep getting the same error .
ORA_20002:311 4:Activity'XXXP TR/MAIN_TRAININ G_PROCESS' is not a process.
Please let me know what I have to do to fix this problem.
Thanks
Sreelesh
How to send PO approval mail notification to next person in the Hierarchy when the PO amt exceeds the limit of the person who
has it for approval. Can you please reply asap.
thanks,
P rakash
You can programatically changed the value of the recepient attribute by setting its value to next level in hierarchy
Than ks
Anil
I am in the need of sending mail notifications based on online discussion happens in Oracle sourcing.
Pleas e help me how to do this.
Thanks and Regards
Kirti
Any chance you could convert training lesson 1 into the screenshot style you used in training lesson 2? Loved the first few minutes but lost it when it started getting out of synch.
I just stared as beginner in apps and now your site has made to learn OAF stuffs and work flow stuffs. Now I am working with real project of this combination(OAF +Work flow).
For anybody it always difficult to start with any technology. But you have made it easy ... real time easy.
Thanks a lot !!!!!!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!!!!!!!!!!! !!! :)
Sureshbabu
I use a business event oracle.apps.inv .itemUpdate to update another system with item information. (I use BPEL to subscribe to the event) My problem is that I only need to integrate about 5 fields, but there are about 50 fields the business event fires on. I don't want to send a message to another system every time the data is updated even if none of their fields needs to be updated in the second system. Is there a way I can check the values of the fields before and after the update? (Almost like a before update trigger) And then to only send an integration message if the correct fields changed?
I have certain requirement ,
For example : i have an approved PO to which iam applying the contract terms from Terms & Conditions window.
When iam doing this status of the PO is getting changed to "Requires Reprroval", i dont want this to happen.
The status PO should remain as it is (i.e Approved).
In which workflow i have to make change , so it doesnot affect the status of the PO.
Thanks
Sy ed
I like to know how this workflow is intiated and how it is selecting the data when sending the payment notification to employee about their payment .
Please assist or direct me to how to do that .
Thanks and Regards
Balkris hna
did not reach the following recipient(s):
Subject: Request 10360260 (aaaa Publish Routing Codes) has completed with status Normal
xyz
The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address.
I am new to workflow customization. I have a requirement to change the REQAPPRV workflow. When we create a requisition, it follows the preparer approval hierarchy. Business wants it to follow the approval hierarchy of the requester, mentioned in the first line of the requisition. I have gone through the package. But it is so big that I am getting confused on where to start and what exactly we should modify.
Could you please help me in this regard.
Thanks ,
Ratnesh
I am beginner to the workflows.
I had a requirement where i need to develop a API to Approve /reject a notification. Is there any seeded API to set the response to a notification and trigger the further actions in the workflow process.
Pleas e let me know.
I need to custmized the "INV:Move Order Approval Workflow", I want to disable the line level approva.
One Notifiaction will come to MO approver with all list line details, so the approvar can direct approve all the line at a time.
No need to approve line by line.
Any help Appreaciate.
Thanks & Regards
Braja
I am a beginnerr, Can any One Help ou wit this... :(
Tha nk you
-- Sid
I went through your tutorial for "How to define Business events in Oracle Workflows". I added a subscription to a standard business event and ran the subscription pl/sql program to insert a new record to my staging table. It worked fine and data is loaded. However the same business event is not getting fired when a create a new employee in the front end of
Oracle Application.
A ny help would be apprreciated.
Thanks
Arun
I have done all the set up, created procedures, tables but still data is not getting inserted into the temporary table.
I must say there is something wrong in my database.
Can anyone tell me what needs to be done if I want to make the workflow notification mails language independent?
Thank,
Kaushik
Regards
Zubair Ali
Pakistan
I am facing the problem with oracle workflow custom pl/sql code. I am using packaged procedure to execute some task. When I registered WF, that time it was running OK. But when i modified the procedure later. workflow running in error like
ORA-04061 : existing state of has been invalidated
ORA -04061: existing state of package "APPS._WF_PKG5" has been invalidated
ORA -04065: not executed, altered or dropped package "APPS._WF_PKG5"
ORA-06508: PL/SQL: could not find program unit being called: "APPS._WF_PKG5"
I did lot of search but not get clear solution on it. please help me out..
Thanks in advance..
Rega rds,
Uday
Speak to your DBA's please
I am new to oracle work flows, We have issue with a customised oracle work flow in quality module,
Back Ground :
Basically this work flow should go through two level of approvals and it should generate a prq no.
Issue #1
But every time its getting struck at wait_for go moveorder node which had WF_STANDARD.BLO CK as a function.
Labl e Name :WAIT_FOR_GOMOV EORDER
start/en d:Normal
not proceeding and it ends with notified status.
Please help me out guys,I am struck with this for long, Thanks in advance.
Best Regards,
Vizith Kumar Bhogi
Not sure what to say..you are the best.
SK
I created a workflow succesfully with you tutorials, Its a big help but i am facing one requirement here that,
If approver rejects a workflow notification , requestor should be able to make sme changes to it and resumbit the workflow , But my workflow is throwing some error like this : ora-20002:3122 :Duplicate item
'CTRTFAPP/ RFQ00064' Could not be created.ORA -06512: at WF_ENGINE at line 3920 , Please need your help in it
Best Regards,
Vizith
While viewing iExpense approval notifications in outlook express we get the Action links (Approve, Reject, Request Information) at the buttom of the notification message, where as when we see the same notification via worklist the action buttons appears at both top and buttom of the message.
Our requirement is to display this links at the top of the notification message as well when viewing the notification via outlook. could you please though some on it.
Regards,
N eel
It gives 404 not found error.
Can you please suggest?
Thank s,
Satish
(stumbleupon). І havе bookmarked it fߋr later!
Failed Activity Verify Invoice
Activity Type Notice
Error Name WFSQL_ARGS
Error Message 3000: Invalid value(s) passed for arguments. ITEMTYPE=OEOL ITEMKEY=752752 ANAME=NULL
Error Stack Wf_Engine.GetIt emAttrText(OEOL , 752752) Wf_Engine.CB(GE T, OEOL:752752:230 754, VARCHAR2, ::::) Wf_Engine.GetIt emAttrText(OEOL , 752752) Wf_Engine.CB(GE T, OEOL:752752:230 754, VARCHAR2, ::::) Wf_Engine.oldCB (GET, OEOL:752752:230 754, VARCHAR2, ::::) Wf_Notification .SendSingle(WAH EED, OEOL, XX_MSG_VERIFY_I NVOICE, WF_ENGINE.CB) Wf_Notification .SendGroup(FND_ RESP|AR|ITC_AR_ ENDUSER|STANDAR D, OEOL, XX_MSG_VERIFY_I NVOICE, WF_ENGINE.CB) Wf_Engine_Util. Notification_Se nd(OEOL, 752752, 230754, OEOL:XX_MSG_VER IFY_INVOICE) Wf_Engine_Util. Notification(OE OL, 752752, 230754, RUN)
can you help us plz
RSS feed for comments to this post