Apps To Fusion

...
written by Sreenivasa Rao Ramuni , December 28, 2006

Thanks a lot Anil. Its very helpfull for the people who is learning the Workflow

...
written by Sreenivasa Rao Ramuni , December 28, 2006

Thanks a lot Anil. Its very helpfull for the people who is learning the Workflow

...
written by Anil Passi , December 29, 2006

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

...
written by Nimish , December 29, 2006

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.

Regards!

...
written by Anil Passi , December 29, 2006

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

...
written by Nimish , December 29, 2006

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.

Regards!

...
written by Ranjeev Singh , February 19, 2007

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

...
written by shahnawaz , May 16, 2007

was gud, but better if you do it bit slow and explain properly.

...
written by Aloy , June 05, 2007

Hi Anil,

Excellent 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

...
written by Anil Passi , June 05, 2007

Hi Aloy,

Simply remove that FYI notification activity from the workflow.

Thanks,
Anil Passi

...
written by Joydeep , June 18, 2007

Sir,
Is there no link for Order management and inventory. It will be great hep for the manufacturing people.

Thanks,
Joydeep

...
written by Munish Thukrela , June 18, 2007

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.

Regards,
Munish

...
written by Anil Passi , June 19, 2007

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

...
written by Uttam , June 20, 2007

Anil,
I am really surprised/amazed to find your patient replies to lots n lots of queries floating around.
Hats off to your effort.
Keep up the good work..

Regards,
Uttam
-- An enthusiastic new entrant to OWF

...
written by Chirag , July 30, 2007

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

Regards,
Chirag.

...
written by Chirag , July 31, 2007

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.
Worth going through it.
Thanks once again.

Regards,
Chirag

...
written by Sajith , August 25, 2007

Hi Anil,

Appreciate ur commendable effort.

It will be very helpful, if the workflow training lessons are downloadable. I there any way out to download.

Regards,
Sajith

...
written by Ananth , August 26, 2007

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

Regards
Ananth

...
written by Mohummad Fahad , August 27, 2007

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

i'll really appreciate ur help Anil.

Thanks
Fahad

...
written by Mohummad Fahad , August 30, 2007

Hi Anil,

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

Fahad

...
written by Basava.S , September 07, 2007

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

Basava
Vijayawada,AP.

...
written by Basava.S , September 07, 2007

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

Thanks ,
Basava.

...
written by bhanu_Kamal , September 07, 2007

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.


Thanks & Regards

Kamal

...
written by Dhritiman Maitra , September 11, 2007

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

...
written by Dhritiman Maitra , September 11, 2007

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,
Dhritiman Maitra

...
written by Vijaya , September 11, 2007

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,

regarding work flow mailer
written by sudheer kumar , October 01, 2007

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.


please replme me
thanks
sudheer G kumar
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Online WF training is marvellous..
written by Zameer , October 02, 2007

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.

workflow notification mailer
written by sudheergbe , October 03, 2007

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


Thanks
sudheer G
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Remove Forward, Approve and Forward in Requisition Notification
written by Hi Anil, , October 25, 2007

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
Ram

work flow
written by siddam , October 29, 2007

please send me
work flow video tutorials

Nice Work
written by madhuri desu , November 03, 2007

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

How To Install WorkFlow on oracle applications
written by Ramakrishna_gottipati , November 26, 2007

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.

Regards,
Ramakrishna.

Oracle Workflow Certification
written by Tamil Selvan , December 18, 2007

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)

regards
Tamil

Order Line Workflow
written by Neelam , January 25, 2008

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?

Workflow Schema Issue
written by Manohar Baddam , February 01, 2008

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 workflow
written 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 declared
written by Kishor , February 23, 2008

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_ORDER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored [Error Process Error: 3116: Activity 'WFERROR/SERVEREQ_ERROR' is not a runnable process.]

Regards,
Kishor

'Where to search for .wft files
written by satheesh , March 20, 2008

Hi Anil,

I am very very new to workflow. Can you please guide where to check for the .wft files created.

...
written by Subodh , March 27, 2008

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

Thanks
written by Subodh , March 28, 2008

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.

Thanks


Regards,
subodh

Oracle Workflow for DBA's
written by Shadow , May 06, 2008

Anil,

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

Thanks in advance

XML workflow question
written by Amy , May 08, 2008

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.

Thanks in advance. Love your tutorials. They were a great help.

How to Send Multiple Notifiacations with Approver and RequesterNames
written by Murugesan , May 19, 2008

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.Please tell me , is it possible. if it is possible , tell me how we can do ?

HRMS Reminder Notifications.
written by Divya , June 17, 2008

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.

Appreciate your help.

Thanks,
divya

To notify the manager when ever an user gets updated
written by Josephin , June 23, 2008

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

notify when changes made to user
written by Anil Passi- , June 23, 2008

You should subscribe to Business Events that get invoked when responsibilities 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,
Anil Passi

I tired the first lesson of your workflow...but i never received an email.
written by Ramki123 , July 23, 2008

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 \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

same as your example.

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

Thanks,
Ramki

workflow traning lesson 1
written by sreelesh , July 29, 2008

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_TRAINING_PROCESS' is not a process.
ORA-06512: at "APPS.WF_ENGINE", line 3920
ORA-06512: at "APPS.XXXX_PO_WF_TRAINING_PKG", line 96
ORA-06512: at line 3
Can you please let me know what need to done to fix this.
Thanks
Sreelesh

Work Flow Training Lesson 1
written by sreelesh , July 30, 2008

Anil,
I keep getting the same error .
ORA_20002:3114:Activity'XXXPTR/MAIN_TRAINING_PROCESS' is not a process.
Please let me know what I have to do to fix this problem.
Thanks
Sreelesh

Developer
written by Prakash979 , July 31, 2008

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,
Prakash

...
written by Kirti Kumar Gupta , August 31, 2008

Hi Anil,

I am in the need of sending mail notifications based on online discussion happens in Oracle sourcing.
Please help me how to do this.

Thanks and Regards
Kirti

Training lesson 1
written by Gil Aguirre , September 09, 2008

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.

Thanks a lot !!!!!!!!!!!!!!
written by Suresh1784 , October 25, 2008

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

Event to fire only on certain fields
written by Marinus , January 20, 2009

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?

PO Workflow Change
written by syed , May 27, 2009

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

Syed

Need help in Credit Card workflow (APCCARD)
written by balkrishna Bihade , May 28, 2009

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
Balkrishna

Workfow issue haunting us
written by MG , July 17, 2009

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

This e-mail address is being protected from spambots. You need JavaScript enabled to view it 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.

REQAPPRV customization
written by Ratnesh , September 22, 2009

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