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.startprocess. 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.

Have a look at FND_WF_STANDARD.submitconcprogram and FND_WF_STANDARD.waitforconcprogram

This WF API has provision to submit request. After the request is completed, the API will push the workflow forward.

Search on these APIs within documentation. You will need to define wait activity just after the executeconcprogram.

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

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/notifications, 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.

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..etc. on notification. Once 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.

Hi Anil , I am new to this site.first of this is damm good and the info provided here is very helpful. Actually 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? Please help me in this...

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...

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.

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.

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.

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.To 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.

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.

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'. do we need this status as running to send e-mail notification.(not only to a single mail for diffrent mails also do we need that in running mode).

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.

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

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?

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.appropriate?

Regards Manohar

how to change the approval hierarchy in requisition workflowwritten by abs.sharma , February 18, 2008

Hi Anil,

Iam new to workflow and I need your advice on one of our business requirements. Whenever 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.

thanks Bhanu

PLS-00201: identifier 'XDP_SFM_SR_WF.CALL_PROCESS_ORDER' must be declaredwritten by Kishor , February 23, 2008