To Workflow guides, use the links provided below.
Download Workflow Developer's Guide: (HTML version): http://download.oracle.com/docs/cd/B19306_01/workflow.102/b15853/toc.htm
PDF version: http://download.oracle.com/docs/cd/B14099_19/integrate.1012/b12161.pdf
Workflow API Guide: http://download.oracle.com/docs/cd/B14099_19/integrate.1012/b12163.pdf
Workflow System Administrator Guide: http://download.oracle.com/docs/cd/B19306_01/workflow.102/b15852.pdf
Showing posts with label Workflow. Show all posts
Showing posts with label Workflow. Show all posts
Friday, July 23, 2010
Friday, May 28, 2010
Where to download latest EBS Workflow Client?
If you need to download latest workflow client, for EBS, search in metalink for Doc ID # 261028.1.There are different versions, to be downloaded depending on what version of Oracle RDBMS you would be working on. For example if the RDBMS version is 10g or above, then download patch # 4066964 click here.to go there.
If you intend to work on non-EBS Oracle installation, then you can download from OTN - click here to go there.
If you intend to work on non-EBS Oracle installation, then you can download from OTN - click here to go there.
Tuesday, March 25, 2008
How to Capture invalid email address?
How can invalid or mal-formed email address (or so called bouncing emails) be captured?
As note: 456378.1 says, after enabling the event WF_MAIL.Disable_Recipient_Ntf_Pref, if a recipient's email address is invalid, an email notification is sent out the SYSADMIN that an email notification could not be sent.
Note:
1. However, this will work only on or after RUP5.
2. Notification preference for SYSADMIN should be MAILHTML or MAIL
to read the complete metalink note, click here
As note: 456378.1 says, after enabling the event WF_MAIL.Disable_Recipient_Ntf_Pref, if a recipient's email address is invalid, an email notification is sent out the SYSADMIN that an email notification could not be sent.
Note:
1. However, this will work only on or after RUP5.
2. Notification preference for SYSADMIN should be MAILHTML or MAIL
to read the complete metalink note, click here
Sunday, March 9, 2008
How To Find Out What Time A Timecard Was Submitted Using Wfstatus.sql
I was recently posed a question: To identify when a timecard was submited?
Easy: Use WFSTATUS.sql
Pass parameters the Internal Type of the Timecard and the Timecard Number (It is also the Expenditure_ID as well as the Item Key)
Reference: Metalink Note: 185820.1
Easy: Use WFSTATUS.sql
Pass parameters the Internal Type of the Timecard and the Timecard Number (It is also the Expenditure_ID as well as the Item Key)
Reference: Metalink Note: 185820.1
Sunday, March 2, 2008
Designing adhoc roles
I recently came across a code which creates adhoc roles for sending Missing Timecard notifications to Supervisors.
Requirement: Every timecard has to approved by the Project Manager of the Project. If a timecard is not submitted then a notification has to be sent to the Employee and to the PM of that Project.
Issue: The code I saw created one role for every timecard submitted.
Problem is an Employee will work in various projects, may be even during the same time. There is only one approver for each project. So how can you get this resolved?
The Code I saw, creates an adhoc role for every Timecard submitted. Obviously, this will create millions of rows in wf_local_user_roles, since each role created will have at least 2 persons to notify.
My preferred solution: What I would do is either create one role for every project the Employee works for and append the Project Managers to this; or, create a PLSQL table of persons to whom the notifications has to be sent and in the approval workflow, loop till this list is exhausted.
Requirement: Every timecard has to approved by the Project Manager of the Project. If a timecard is not submitted then a notification has to be sent to the Employee and to the PM of that Project.
Issue: The code I saw created one role for every timecard submitted.
Problem is an Employee will work in various projects, may be even during the same time. There is only one approver for each project. So how can you get this resolved?
The Code I saw, creates an adhoc role for every Timecard submitted. Obviously, this will create millions of rows in wf_local_user_roles, since each role created will have at least 2 persons to notify.
My preferred solution: What I would do is either create one role for every project the Employee works for and append the Project Managers to this; or, create a PLSQL table of persons to whom the notifications has to be sent and in the approval workflow, loop till this list is exhausted.
Thursday, July 26, 2007
How to determine Workflow Mailer status without using OAM
I had an interesting question from my friend the other day.
How can you determine the availability of WF Mailer without using OAM?
The following query provides the status, eliminating the need to use OAM.
SELECT Component_name, Component_Status
FROM FND_SVC_COMPONENTS
WHERE component_type = 'WF_MAILER'
Reference: Metalink Doc: 316352.1
How can you determine the availability of WF Mailer without using OAM?
The following query provides the status, eliminating the need to use OAM.
SELECT Component_name, Component_Status
FROM FND_SVC_COMPONENTS
WHERE component_type = 'WF_MAILER'
Reference: Metalink Doc: 316352.1
Monday, June 11, 2007
Workflow Model
Saw an interesting posting in the OTN forum on Workflow model (see above) by Luiz Soares. There is link in the thread to download the model Click on the title to goto directly and download from the server Luiz has posted.
Thanks Luiz. Awesome job :-)
Subscribe to:
Posts (Atom)