Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Workflows Training Index
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Please find a sequential list of training articles on Oracle Workflows.

Oracle Workflow Training

Oracle Workflows Training Lesson 1

Oracle Workflows Training Lesson 2

Oracle Workflows Training Lesson 3

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

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

Oracle Workflows Account Generator Example

Oracle Workflows : Attach documents to Notifications

Adjust Notification Timeouts to include bank holidays and weekends

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

Basics of Oracle Workflows Engine

Oracle Workflows Access Protection Concepts

Preserve Customizations to Oracle Workflows - A Presentation

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


Anil Passi

Comments   

0 #1 Sreenivasa Rao Ramuni 2006-12-28 00:00
Thanks a lot Anil. Its very helpfull for the people who is learning the Workflow
Quote
+1 #2 Sreenivasa Rao Ramuni 2006-12-28 00:00
Thanks a lot Anil. Its very helpfull for the people who is learning the Workflow
Quote
0 #3 Anil Passi 2006-12-29 00:00
.
.
.
.
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.
.
.
.
.
.
Quote
0 #4 Nimish 2006-12-29 00:00
thanks Anil for your help. I thought so but wanted to try and avoid going to DBA for creating stuff in Apps schema. Anyways I will check with them.

Regard s!
Quote
0 #5 Anil Passi 2006-12-29 00:00
.
.
.
.
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.
.
.
.
.
.
Quote
0 #6 Nimish 2006-12-29 00:00
thanks Anil for your help. I thought so but wanted to try and avoid going to DBA for creating stuff in Apps schema. Anyways I will check with them.

Regard s!
Quote
0 #7 Ranjeev Singh 2007-02-19 00:00
Hi Anil,
I want to send the e-mail for the approval to the approver email ID using Workflow how do i do this..... PLease hepl me in this regard....
Quote
0 #8 shahnawaz 2007-05-16 00:00
was gud, but better if you do it bit slow and explain properly.
Quote
0 #9 Aloy 2007-06-05 00:00
Hi Anil,

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
Quote
0 #10 Anil Passi 2007-06-05 00:00
Hi Aloy,

Simply remove that FYI notification activity from the workflow.

Th anks,
Anil Passi
Quote
0 #11 Joydeep 2007-06-18 00:00
Sir,
Is there no link for Order management and inventory. It will be great hep for the manufacturing people.

Than ks,
Joydeep
Quote
0 #12 Munish Thukrela 2007-06-18 00:00
Thanks a lot Anil. Indeed, its very helpfull for the people who want to learn the Workflow. And pls guide me what should I do to learn more about workflow because I am very new for oracle workflow.

Re gards,
Munish
Quote
0 #13 Anil Passi 2007-06-19 00:00
Hi Munish,

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

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

Thanks,
Anil
Quote
0 #14 Uttam 2007-06-20 00:00
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
Quote
0 #15 Chirag 2007-07-30 10:21
Hi Anil,

I have a workflow called 'OM Order Line'. Now according to the requirements i need to advance the workflow for the selected lines of the sales Order from one activity 'Branch on Form Selection' to 'Schedule Line'.
I need to create a concurrent request with the parameters
1)Sales Order number
2) line numbers of the sales orders ( like 1-3,5 )
So if i am not wrong i need to call the workflow manually to advance from one activity from another.
Please provide some information regarding that. Is there any standard API to do that?
I found API, wf.engine.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.
Quote
+1 #16 Anil Passi 2007-07-30 20:23
Hi 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
Quote
0 #17 Chirag 2007-07-31 08:54
Hi Anil,

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

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

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

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

Regards ,
Chirag
Quote
0 #18 chowreddy 2007-08-25 06:47
Hi Anil,

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
Quote
0 #19 Ananth 2007-08-26 13:29
Hi Anil,

Very good info. thanks for your info.I have a doubt. When do we have to go for a workflow ?? as far as my knowledge goes we can go for it when i have to send workflow mails/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
Quote
0 #20 Mohummad Fahad 2007-08-27 18:28
Hi Anil,

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

I have craeted a customized workflow which have five levels of approval.
When the user submit the request,it will go to first level of approval.The approver will be able to see the details in the Action History table as Num,Action,From ,To,Details..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
Quote
0 #21 Mohummad Fahad 2007-08-30 17:09
Hi Anil,

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

Fahad
Quote
0 #22 Aghe Martins 2007-09-07 14:23
Hi Anil ,
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.
Quote
0 #23 Anil Passi 2007-09-07 14:26
Hi Basava,

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

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

Than ks ,
Basava.
Quote
0 #25 bhanu_Kamal 2007-09-07 18:43
Hi Anil,
I have a problem related to po requisition workflow customization. i am describing my requirement through an example.


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

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

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


Thank s & Regards

Kamal
Quote
0 #26 Ashwin Kumar Avula 2007-09-11 05:46
Hi Anil,
I am new in Workflow Development and got help from ur articles.
If u please mail me those links to download those articles (to run it offline)
then it will be more helpful for me.

Thanks
Quote
0 #27 Ashwin Kumar Avula 2007-09-11 05:55
Hi Anil,
I am new in Workflow Development and got help from ur articles.
If u please mail me those links to download those articles (to run it offline)
then it will be more helpful for me.

Thanks,
Dh ritiman Maitra
Quote
0 #28 Chandra Thangavelu 2007-09-11 21:24
Hi,
Your website is great. I got a workflow job browsing your website. Thanks a lot for all your great help. Can you help me on this. Is it advisable to change the standard oracle seeded process (taking the backup) otherwise we have copy the process and change in our own process.
if we are making our own copy where all we should check to change our references to point to new process.

Thanks in advance,
Quote
0 #29 Anil Passi 2007-09-12 20:11
Hi Vijaya

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

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

Thanks ,
Anil Passi
Quote
0 #30 sudheer kumar 2007-10-01 15:00
Hi anil ,
your lesson's are very good.They helped me alot.Thanks for that and i have one doubt hear.
Do we need workflow notification mailer status in 'RUNNING' mode to send an e-mail notitfication.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
Quote
0 #31 Zameer 2007-10-02 14:14
Hi Anil,
This online WF training helped me much and helps others too.
Could you please let me know how can i down load as i don't have internet connection at
my home.
Thanks in advance.
Thanks ,
Zameer.
Quote
0 #32 sudheergbe 2007-10-03 11:43
Hi anil,
I have seen your lessons they really good to understand the work flow from basics.
In one of your lessons u said how to send all the notifications to the single mail.
But my requirement is to send the PO details to the buyer.
so buyer wont be same all the times so to send the e-mail notifications to the diffrent peoples what are the setups i need to do.

and one more thing in my system the workflow notification mailer status is not in running mode it is saying that 'SYSTEM DEACTIVATED'.
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
Quote
0 #33 Hi Anil, 2007-10-25 13:02
Hi Anil,

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

Any help pls?

Regards
R am
Quote
0 #34 siddam 2007-10-29 07:14
please send me
work flow video tutorials
Quote
0 #35 madhuri desu 2007-11-03 14:00
I know the basic concepts of workflow and how to create attributes, notifications and processes etc but I couldnot understand how to save them to the database and how to run them.
But after working with your example I learned to do it.

Thanks for your Lessons and I hope I could learn more in the further lessons
Quote
0 #36 Ramakrishna_gottipati 2007-11-26 12:53
Hi Anil,

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

Rega rds,
Ramakrishn a.
Quote
0 #37 Tamil Selvan 2007-12-18 12:16
Hi Anil,
I would like to do Oracle Workflow Certification.
but i couldn't find study guides for preparing the exam.

Please help in providing the study guides if you have.

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

regard s
Tamil
Quote
0 #38 Neelam 2008-01-25 16:59
Hi,
I am working on OEOL workflow. Trying to customize the Line flow Generic,Bill Only process. Soon as the order is booked the lines using this process go into fulfilled. The requirement is to get let user decide when to fulfill. So i added 'wait to fulfill line' function to the workflow. This lets the user progress order to fulfill. This is working well for everything except split line. If i line A is split into A and B, B errors out giving unexpected error. Can you advice on how to resolve this.Is there anyother function that is more appropriate?
Quote
0 #39 Manohar Baddam 2008-02-01 08:14
Hi Anil,
I am working on OEOL workflow, have added a new function activity to this flow.This activity references PL/SQL stored procedure compiled in the APPS schema, Instead is it possible to use the PL/SQL stored procedure compiled in another schema while WF function resides in APPS schema.I tried to give schema name in the function attribute but the WF is going into exception.Can you advice on how to resolve this.Is there any other approach where I can use another schema for PL/SQL code.appropriat e?

Regards
Manoh ar
Quote
0 #40 abs.sharma 2008-02-18 18:32
Hi Anil,

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
Quote
0 #41 Kishor 2008-02-23 09:34
Hi Anil,

we have getting below error when lauching the wf

ORA-06550: line 1, column 7:
PLS-00201: identifier 'XDP_SFM_SR_WF. CALL_PROCESS_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
Quote
0 #42 satheesh 2008-03-20 17:03
Hi Anil,

I am very very new to workflow. Can you please guide where to check for the .wft files created.
Quote
0 #43 Saquib Azmal 2008-03-27 00:47
Hi
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
Quote
0 #44 Saquib Azmal 2008-03-28 00:26
Hi Anil,

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
Quote
0 #45 Shadow 2008-05-06 04:38
Anil,

Could you please let me know what is required for an oracle apps dba to know about workflow?

Than ks in advance
Quote
0 #46 Amy 2008-05-08 16:00
I have been tasked with starting a workflow process from pl/sql using createprocess & startprocess. I have many parameters to pass and would like to send them in to workflow as XML. Is this possible or must I parse them out of the XML and set item attribute values via PL/SQL before I start the workflow process? I have read your XML payload example but do not want to create a custom event to kick off the workflow as this seems like an extra step that adds to the complexity.

Th anks in advance. Love your tutorials. They were a great help.
Quote
0 #47 Murugesan 2008-05-19 07:01
Hi Anil,
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 ?
Quote
0 #48 Divya 2008-06-17 21:46
Hi Anil,

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
Quote
0 #49 Josephin 2008-06-23 07:22
Hi, I need a solution for the business need. I need an optimal and less complicated way to notify the manager when ever an user is impacted(new responsibilitie s added, end dated) or when a new user is entered in the system. Form personalization , alert which ever is optimal and less complicated. Plz let me know the solution ASAP.

Thanks

Josephin
Quote
0 #50 Anil Passi- 2008-06-23 07:36
You should subscribe to Business Events that get invoked when responsibilitie s are added.

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
Quote
0 #51 Ramki123 2008-07-23 18:22
I tired the sample example which is attached to the first lesson of the training, but i never received email of the message neither the notification.

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

same as your example.

pleas e let me know, if their something which i may missed ot needs to cross check

Thanks,
Ramki
Quote
0 #52 sreelesh 2008-07-29 22:03
declare
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
Quote
0 #53 sreelesh 2008-07-30 11:03
Anil,
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
Quote
0 #54 Prakash979 2008-07-31 15:40
Anil,

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
Quote
0 #55 Anil Passi 2008-07-31 16:01
Your notification is attached to a WF Attribute, which contains the name of the Role/Receipent.
You can programatically changed the value of the recepient attribute by setting its value to next level in hierarchy

Than ks
Anil
Quote
0 #56 Kirti Kumar Gupta 2008-08-31 09:17
Hi 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
Quote
0 #57 Gil Aguirre 2008-09-09 12:31
Hi Anil,

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.
Quote
0 #58 Suresh1784 2008-10-25 09:06
I have to thanks a lot for all your efforts.

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
Quote
0 #59 Marinus 2009-01-20 07:05
Hi Annil,

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?
Quote
0 #60 muntazir 2009-05-27 08:19
Hi Anil,

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
Quote
0 #61 balkrishna Bihade 2009-05-28 08:23
Hi Anil,

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
Quote
0 #62 MG 2009-07-17 18:16
We have set workflow notifications to be sent to some folks in our company, once a concurrent program completes. One of the recepient of this notification left the company. We removed his name from the notifications. The request ID mentioned in the email does not exists in our tables we we purge old requests. Any idea how to fix this? Outlook admin is after us to remove the persons account which we have already done. However, everyday we are bombarded with following email.

did not reach the following recipient(s):

Subject: Request 10360260 (aaaa Publish Routing Codes) has completed with status Normal

on Fri, 17 Jul 2009 13:14:41 -0700
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.
Quote
0 #63 Ratnesh 2009-09-22 04:00
Hi,

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
Quote
0 #64 Rajesh Kaja 2010-03-17 03:10
Hi Anil,

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.
Quote
0 #65 Braja 2010-06-07 04:17
Hi,
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
Quote
0 #66 sathish kumar gandhe 2010-06-17 02:59
OM:Cost of Goods sold work flow customization to take it from concerned office in the place of inventory org


I am a beginnerr, Can any One Help ou wit this... :(
Quote
0 #67 Siddtharth 2010-06-22 12:55
Is there any API to terminate the workflow and reject the invoice ? I can do that from Oracle App page by clicking the Reject button, but I need to do the same from a pl/sql procedure.

Tha nk you
-- Sid
Quote
0 #68 Arun 2010-07-27 15:02
Hi Anil,

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
Quote
0 #69 Arun Mante 2010-09-28 09:16
As per the training menstioned in the http://www.google.com/search?q=site:apps2fusion.com+workflows-business-events-training-lesson-4
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.
Quote
0 #70 Kaushik 2010-10-19 14:40
Hi,

Can anyone tell me what needs to be done if I want to make the workflow notification mails language independent?


Thank,
Kaushik
Quote
0 #71 Zubair Ali 2010-11-04 00:44
It is very useful resorce to learn workflow. Thanks to Anil.

Regards

Zubair Ali
Pakistan
Quote
0 #72 Uday Jadhav 2010-12-06 07:58
Hi Anil,
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
Quote
0 #73 Anil Passi- 2011-04-14 08:41
Bounce the WF Manager Services
Speak to your DBA's please
Quote
0 #74 vizith 2011-04-28 23:16
hi anil and friends,

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
Quote
0 #75 sk 2011-07-27 11:09
Hi Anil,
Not sure what to say..you are the best.

SK
Quote
0 #76 vizith 2011-10-01 06:32
Hi Anil,

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
Quote
0 #77 Microsoft Office 2007 2011-12-07 01:16
I will keep your new article. I really enjoyed reading this post, thanks for sharing
Quote
0 #78 Neel 2012-02-22 06:08
Hi Anil,

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
Quote
0 #79 Satish SD 2012-05-02 05:04
not able to access link - "http://www.app s2fusion.com/do cs_apps/demo/wf /training_lesso n_1/Oracle_Work flow_Training_l esson_1.htm"
It gives 404 not found error.
Can you please suggest?

Thank s,
Satish
Quote
0 #80 greslazienkowy.org. 2014-04-18 14:30
Ԍood info. Lucky mе I fߋuոd yoսr site by accident
(stumbleupon). І havе bookmarked it fߋr later!
Quote
0 #81 Ahmed AlShafiy 2014-08-13 08:30
we are facing the following error
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
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner