Notification Mailer
Date: Tue, 23 Mar 1999 09:28:42 -0800 (PST) Installation
From: Missy Schaetzke [SMTP:Missy_Schaetzke@zd.com]
Date: Wed, 7 Apr 1999 12:28:40 -0400
Date: Wed, 7 Apr 1999 12:13:14 -0400
From: "Tate, Dana" dtate@kpmg.com
Date: Wed, 7 Apr 1999 10:11:00 -0700
Date: Wed, 7 Apr 1999 16:18:11 -0700 (PDT) COGs through Workflow
--- "Ishihara, Bill" bishihara@trimarine-usa.com
From: oraapps-l@cpa.qc.ca
--- "Ishihara, Bill" bishihara@trimarine-usa.com wrote:
Date: Fri, 16 Apr 1999 16:11:26 -0700 (PDT) PO - Requisition approval
--- om hari sri_varada@hotmail.com wrote:
Date: Mon, 3 May 1999 10:55:50 -0700 (PDT) Workflow Background processes
Date: Mon, 28 Jun 1999 15:46:12 -0700
Date: Thu, 1 Jul 1999 11:32:26 -0700 (PDT) How do You configure UNIX Mail
Date: Wed, 07 Jul 1999 08:15:08 -0500
Date: Thu, 8 Jul 1999 20:28:55 EDT What is Workflow
shanmugam kasiviswanathan" kasiviswanaths@hotmail.com
Date: Wed, 14 Jul 1999 13:14:08 -0700 (PDT)
From: Jason Chan [mailto:jchan14@yahoo.com]
Date: Mon, 19 Jul 1999 13:57:55 -0500 How to use Workflow to page, fax or email
Date: Thu, 15 Jul 1999 16:36:03 -0700
Date: Mon, 19 Jul 1999 14:43:07 -0400 (EDT) Calling Workflow from Customer Entry Form
Date: Thu, 22 Jul 1999 16:04:10 +0530
Date: Fri, 23 Jul 1999 11:17:27 -0400 Workflow for MultiOrg
From: Erik Ritters eritters@prg.com Workflow Monitor Error with Netscape 4.5 in OSSWA
Date: Wed, 14 Jul 1999 16:03:47 -0500 Workflow Monitor error in PA
Date: Sun, 18 Jul 1999 03:23:53 PDT Oracle Workflow API to return Table of Record
Date: Tue, 27 Jul 1999 08:01:37 PDT How to trigger a Workflow
Date: Wed, 18 Aug 1999 16:10:26 -0400
Date: Wed, 18 Aug 1999 16:33:26 -0700 Workflow - setup
Date: Sun, 22 Aug 1999 06:40:00 PDT Workflow Monitor setup
Date: Tue, 24 Aug 1999 03:50:18 PDT
Date: Wed, 22 Sep 99 10:41:21 -0800
Date: Fri, 27 Aug 1999 22:32:16 PDT Workflow to generate Code Combos
Date: Tue, 24 Aug 1999 18:40:33 -0700
Date: Tue, 24 Aug 1999 22:35:42 -0700
From: Jason Chan
Subject: Re: Sending approval notification via email
Have you had any experience with the Workflow Notification Mailer in
R11? We are in the process of an upgrade to R11.02 and are trying to
send PR approval notifcations via Notes. It is not working for us yet.
The Mailer is sending only notifications that do NOT require a response.
Any notifications that require a response from the users are not going
out. We are on Sun Solaris.
Any advice will be appreciated.
Regards,
Jason Chan
Sent: Wednesday, April 07, 1999 10:29 AM
Subject: Installing Oracle Workflow
We are in the process of upgrading to Release 11 and have found that we
need to install Oracle Workflow. The documentation we have does not go
into specifics on this particular topic. Can someone shed some light on
what we'll need to do to install this application?
I've read that the self-service web applications need to be installed to
use Workflo. I've also read that there's an Oracle Workflow cartridge.
Is
this true? All I have is about a paragraph of info on each. I'd like to
be able to give some info to our DBA. BTW, I've looked out on the
Metalink
site but haven't found much info there either.
Our platform is a Sun Solaris and database version is 8.0.5. If you can
provide any information I would greatly appreciate it.
Thanks,
Missy Schaetzke
Systems Analyst
Ziff-Davis Education
From: Edward McDonald Edward.McDonald@petersons.com
Subject: RE: Installing Oracle Workflow
Missy:
I'm working on an R11 project that probably about 2 months further along
than yours, so maybe this will help. Workflow is much more prevalent in R11
than it was in R10.7, but it's still not everywhere. If you're installing
the "standard" applications, the biggest uses of Workflow seem to be in the
PO notifications process and in the Account Generator (which replaces
FlexBuilder). When you buy the R11 Apps, you get Workflow as part of the
package, and you should have your DBAs install it with the base apps
install. You can use the "standard" features of Workflow which are embedded
in the Apps. What's not included in this baseline package is the "Workflow
Builder", a client software package that's needed to design new workflows or
adapt the PL/SQL coding behind existing ones. (Workflow is entirely based
on PL/SQL - not SQL*Plus.) Hope this help a bit.
Ed McDonald
Hi Missy!
On Metalink there is extensive documentation. Go to the Metalink Home page,
click on Product References box, then Application Core Technology, then
Workflow. This will take you to the Workflow page, where you can then click
on Product Documentation and download the entire Workflow Guide. The URL
for the Workflow page with documentation is as follows:
http://support.us.oracle.com/ml/plsql/mlv15.frame?call_typemain&javaFlagJA
VA
Dana Tate
Manager
Financial Services
KPMG LLP
Office: (214) 758-8859
dtate@kpmg.com
From: "Sunil D. Rao" Sunil.Rao@ey.com
Subject: Re: ORAAPPS-L digest 3008
Reply to Sub: Installing Oracle Workflow
1. Oracle Workflow on R11 is an integrated product when you install OSSWA. So you shall need
to install OSSWA during your Application install.
2. For anykind of Workflow customization work in the future, you shall need
Oracle Workflow builder product.
3. For smooth Oracle Workflow implementation you need PLSQL cartridge configured on your
Web Server and ensure that you upgrade to R11.0.1 or R11.0.2 to make use of New Workflow
features. Please read the Post-install chapter in the Install Guide for configuration of Web server. Here
you shall find steps to configure OSSWA.
sunil
From: Jason Chan jchan14@yahoo.com
Subject: RE: Installing Oracle Workflow
Make sure you look under the "White Paper" section for Workflow as
well. There are a couple of white papers that were helpful in getting
our Workflow to work.
As far as the Workflow Cartridge, I understand that it is only required
for standalone installation of Workflow. If you are just using the
embedded version of workflow with the App, it may not be required.
Jason Chan
wrote:
Hi,
I am trying to find a way to hit an intercompany
COGs account. I believe
standard Workflow for COGs in release 11 picks off
the COGs as defined at
the item. I do not know how to get Workflow to
make
a decision for the
natural account segment.
Thanks,
Bill
[mailto:oraapps-l@cpa.qc.ca]On Behalf Of Jason
Chan
Sent: Friday, April 16, 1999 9:37 AM
Subject: Re: COGs through Workflow
1. Are you using the "Generate Account Using
Flexbuilder Rules" or
"Generate Default Account" process?
2. What is the decision you want WF to make based
on? Depending on
what it is, you may be able to use the standard
functions "Compare
Text" or "Compare Number" to make the decision and
then generate the
account segments based on the result.
Jason Chan
We are using "Generate Default Account" and want WF
to make decision based
on Order Type.
Thanks any help and input you can provide.
Bill
From: Jason Chan jchan14@yahoo.com
Subject: RE: COGs through Workflow
In general terms, you can use the standard "Compare Number" function to
compare the attribute "Order Type ID" with a reference number (e.g.
intercompany order id). If the result is "equals", then build your own
code combination using the standard functions "Assign Value to Segment"
and/or "Segment Lookup Set Value". If other results (or by default),
use the "Get CCID for a line" function to use the default code
combination.
Keep in mind that once you customize the WF process, Oracle Support
will not support this process anymore.
Let me know if you need more details.
Jason
Hi All:
When I try to approve a document in purchasing from
the submit for approval
window on the enter requisitions screen it raised an
alert saying that 'the
item type workflow does not match the document type'
I had followed all the set up steps in the 'setting
up Document Approval and
security'
The Reference manual states that"The default
approval workflow processes in
Purchasing use the approval controls and hierarchies
you define according to
the setup steps in 'Setting Up Document Approval and
Security'.
I also tried with the existing approval workflow...
I came to the document
type screen and changed the approval workflow to '
PO Requisition
approval'.The result was that it did not raise any
alert and also it also
did not submit the document for approval and the
document has an
incomplete status.
I also tried the other approval workflow 'PO
Requisition',and the result
was the same.
Would appreciate any help on this
Thanks
From: Jason Chan jchan14@yahoo.com
Subject: Re: Requisition approval:
The default workflow for Po Requisitions should be "PO Requisition
Approval" and it works for my company.
Is your "Workflow Background Engine" running? If not, it should be
scheduled to run every 5 to 10 minutes (or more frequently if needed)
through Sys Admin. Also, make sure the min and max threshold are set
to 0 and 10,000 for the Background Engine.
Jason Chan
From: Jon.Bostick@Notes.airtouch.com
Subject: Workflow Background Process
Does anyone have information on how to determine the optimal number and
paramter values for the Workflow Background Process?
Oracle documentation suggest the following as a minimum:
At least 1 with Process Deferred and Process Timeout set to 'NO'.
At least 1 with Process Deferred and Process Timeout set to 'YES'
Thanks,
Jon
From: Jason Chan jchan14@yahoo.com
Subject: Re: Workflow Background Process
We only have one WF Background Process running with the following
settings:
Min: 0
Max: 10,000 (do not use 1,000 as stated in Oracle doc)
Deferred: Yes
Timeout: Yes
It seems to be working well for us.
Jason Chan
From: Pat McBride pmcbride@mdp.com
Subject: Workflow: How do You configure UNIX Mail
What UNIX sendmail account should be used as the Mail Account for Workflow embedded in Oracle Applications?
The documentation states that we should use the same account from which we start the concurrent manager (currently APPLMGR). When we use this account, a loop is created between the standard APPLMGR mail and the Workflow mail processing program. Thsi creates a loop where workflow is telling APPLMGR that the format of it's mail is invalid and APPLMGR is telling workflow that it cannot accept mail.
Any suggestions?
Patrick McBride
EDS - Meredith Account
515-284-2809
pmcbride@mdp.com
From: Nikora@aol.com
Subject: Re: Workflow: How do You configure UNIX Mail
We configured unix sendmail in Oracle Alerts and for that the key
is to have a user created on the mail server who will forward mail picked up
from
the apps database server to others. This user should receive mail or alerts
from Oracle Apps. All depends on whether you uses DNS and the level of
security your mail server administrator has set up (eg domain name hiding)
George
07/14/99 12:35PM
Hi,
What is Oracle Workflow? Where can I find info. about Oracle Workflow
ver2.0.3 on Web?
later,
Kasi.
From: Siddharth Shah shahsd@yahoo.com
Subject: Re: Oracle Workflow
Hi,
The link to Oracle Workflow Web Site:
http://www-apps.us.oracle.com/atg/wf/index.html
For a brief summary of what Oracle Workflow is click here
Hope this helps,
Siddharth Shah
Sent: Monday, July 19, 1999 12:18 PM
Subject: Re: Oracle Workflow
Is this web site available for public uses or for Oracle internal uses
only?
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Oracle Workflow
It's internal to Oracle only.
From: Jason Scherer x139 JasonScherer@trm.com
Subject: R11 Oracle Workflow
Has anyone used Oracle Worflow to page, fax, or e-mail? If so, are there
any guidelines, white papers, examples, etc. that anyone knows of that
refers to this subject?
As always,
Thanks in advance!
Jason Scherer
ECS Integrated Technology Solutions, LLC
Senior Technical Consultant
email: jscherer@ecs-its.com
on-site email: jasonscherer@trm.com
on-site phone: 503-257-8766 ext. 139
From: Jason Chan jchan14@yahoo.com
Subject: Re: R11 Oracle Workflow
We are using Oracle Workflow to send e-mail notifications. Workflow
uses the Notification Mailer engine to send out e-mails. The Workflow
Manual has good info on the Notification Mailer.
From: Dilip Fauzdar DilipFauzdar@inf.com
Subject: Work Flow gurus...please help
Hi,
We want to create a new workflow item and will call this workflow
when a user enters a CUSTOMER in CUSTOMER ENTRY form. Is this possible ? Do
we need to modify the standard CUSTOMER ENTRY form to call this workflow
process??? If yes then what modifications are required.
Thanks in advance
regards
dilip
From: "Spiro, Bruce (HT-EX)" bspiro@GI.com
Subject: RE: Work Flow gurus...please help
You do not need to modify the customer entry form. What you can do is
create a trigger on that table for a new entry, and place the ID in a custom
table to be used as a Queue. Then have a periodic alert check the custom
table and run the new workflow against all the ID's in that custom table.
We do a similar thing for 12 custom workflows that we created for Order
Entry.
Bruce Spiro
Manager, Distribution & HR Technologies.
(215) 323-2421
Subject: Work - Multi Org
Date: Mon, 28 Jun 1999 11:29:40 -0400
Can anyone within the forum please provide any feedback on defining Oracle
Workflows
within a rel 11 environment as they relate to Multi Org - concerns, issues,
etc?
Thanks in advance!
Erik Ritters
Information Technology & Strategy
Production Resource Group, L.L.C.
539 Temple Hill Rd.
New Windsor, NY 12553
Phone - (914)567-5784
Fax - (914)567-5805
Email - eritters@prg.com
http://www.prg.com
From: Pat McBride pmcbride@mdp.com
Subject: Workflow Monitor Error w/ Netscape 4.5
Workflow 2.0.3
Web Server 3.0.2
Applications 10.7sc
Web Expense 2.1 Patch set F
We are running Self Service web applications and receive an error when
trying to view the workflow monitor using Netscape. This typically occurs
after I have successfully viewed one workflow and am attempting to view
the workflow for a second item. We receive the message: "applet oracleapps.fnd.wf.monitor can't start ERROR"
Internet Explorer is able to repeatedly display the Workflow Monitor
without errors. I have also tried upgrading to Netscape 4.61 and applying
the JDK plug in upgrade but neither solution appears to fix our problem.
Any suggestions would be appreciated.
Patrick McBride
EDS - Meredith Account
515-284-2809
pmcbride@mdp.com
From: "siddharta ganguly" pintu_100@hotmail.com
Subject: PO: Workflow Monitor not working
Hi All,
We r on R11.0.3, NT.
In Requisition/ Purchase Order Header Summary, everytime we want to 'View
Approval Through Workflow' from Special menu option, the netscape opens up
and throws up the following message:
Internal error!! Please try again.
Even if I try to open up PO Change History screen, I am getting the same
message.
I don't know what is causing this problem. Is there a problem in setup? Any
help will be greatly appreciated.
Thanks a lot in advance.
Regards,
Jayanta.
From: shafiqr@sa.ibm.com mailto:shafiqr@sa.ibm.com
Subject: Re: PO: Workflow Monitor not working
Hi 11 Gurus
I don't get any message on Workflow inquiry. Seems somethinf to be done on
setup side
Shafiq
From: "shanmugam kasiviswanathan" kasiviswanaths@hotmail.com
Subject: Oracle Workflow API.
Hi,
I am using Oracle 8.0.5, Oracle Web Server 3.0.1, Oracle Workflow
2.0.3. I have written a interface package for a process on Oracle
WorkFlow using API GetItemAttrNumber, in that I am calling a procedure
(PerformanceRequirement.GetCustomerNSYTDAmt) which resturns a single
value(NSYTDAmt). Please gothrough the following Package(ignore
PendingReasonListController.OverridePendingReason, this is for handling
exception).
create or replace package wms_wf_intface
is
procedure wfi_GetCustomerNSYTDAmt
(itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout OUT varchar2
);
End;
create or replace package body wms_wf_intface
is
procedure wfi_GetCustomerNSYTDAmt
(itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout OUT varchar2
)
is
v_CustNSYTDAmt number;
v_CustID number;
v_order_id number;
v_CustNSYTDLimit number;
R_REASON PendingReasonListController.PENDING_REASON_TYPE;
Begin
v_CustId := wf_engine.GetItemAttrNumber
(itemtype => itemtype,
itemkey => itemkey,
aname => 'CUSTOMER_ID');
v_order_id := wf_engine.GetItemAttrNumber
(itemtype => itemtype,
itemkey => itemkey,
aname => 'ORDER_ID');
v_CustNSYTDLimit := wf_engine.GetItemAttrNumber
(itemtype => itemtype,
itemkey => itemkey,
aname => 'CUST_NSYTD_LMT');
PerformanceRequirement.GetCustomerNSYTDAmt
(v_CustID, v_CustNSYTDAmt);
R_REASON.REASON_CD := 'INVALID_NSYTD_AMT';
R_REASON.DISPLAY_TXT := 'NSYTD Amount Greater than permitted';
R_REASON.VALUE := v_CustNSYTDLimit - v_CustNSYTDAmt ;
R_REASON.CREATE_DT := sysdate;
R_REASON.OVRD_ALLOW_IND := 1;
R_REASON.USER_CD := 'USER_CD';
R_REASON.RESOLVED_DT := null;
R_REASON.OVERRIDE_VALUE := null;
R_REASON.COMMENT_TXT :='Update By WorkFlow' ||v_CustId ||v_order_id;
if nvl(v_CustNSYTDAmt,0) > v_CustNSYTDLimit
then
PendingReasonListController.OverridePendingReason('ORDER',v_order_id,R_REASON);
resultout := 'COMPLETE:NSYTD_AMT_T';
else
resultout := 'COMPLETE:NSYTD_AMT_T';
end if;
End wfi_GetCustomerNSYTDAmt;
Noe I need to write another interface package for a process on Oracle
WorkFlow and I need to call a procedure which returns a TABLE OF
RECORD. What is the exact API I need to use to handle this problem.
Please help me out. Write me for anymore details.
Later,
kasi.
From: "Satyakanth Abbaraju" satyakanth@mindspring.com
To: OraApps-L@cpa.qc.ca
Subject: Workflow
Hello,
What are all the possible ways in which a workflow process can be triggered?
Please explain in general terms or using any example convenient for your
explanation. Otherwise use these examples: I create a new workflow process
related to Purchase receipts of specific items, or related to accounting
entries into specific accounts. I want to know what different methods are
available by which I can trigger this workflow process to start.
All replies are appreciated.
Thanks!
Satyakanth
From: Ye He yhe@us.oracle.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Workflow
It all boils down to this:
call createprocess
set item attribute values that pertain to this instance of the process
call startprocess.
Where you do all these workflow API calls is totally up to you.
In your PL/SQL stored procedure, program, your C program that
talks OCI, a form (that triggers an event), a database trigger (in which
case you should have the process deferred immediately), etc.
Of course if you start it from a form that form needs to have registered
with Apps, etc.
Does this help? I'm not sure how familiar you are with the terms
I used above. Email me if you need clarification. Thanks.
Ye
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re:Urgent - Workflow setup
22.8.99
We are implementing 11.0.3,oracle8.0.5. We have found that the workflow is
working in the vision demo. We are unable to setup workflow in the
production instance. Can anyone please assist us in the steps involved to
enable workflow for embedded application?
Thanks in advance
Ravi
From: "David Philips" philipsdavid@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: Workflow Installation
Hi gurus,
Can any one guide me how to make a workflow monitor work
what should be the settings in the
to be done in wfcfg.msg file
what should be port id to be put
for the following entry
WFTKN WF_WEB_AGENT 0
http://server.com:portID/PLSQL_agent_virtual_path
Please tell what value should be taken from web server configurations
Reply awaited
DAVID Philips
philipsdavid@yahoo.com
From: sagarwal@guthy-renker.com
Subject: Re: Workflow Installation
Workflow Monitor can use the same or different PLSQL agent as used by
your apps. If you want to use the same as your apps. then take the
value from system profile option "Applications Web Agent".
Sanjay Agarwal
sagarwal@guthy-renker.com
From: "David Philips" philipsdavid@hotmail.com
Subject: urgent- workflow installations
HI all,
Regarding Workflow Installation ,
I am using embedded workflow
I am not able to view the workflow monitor through the notifications
form.
What I had done was ..
my entry for wf_web_agent in wfcfg.msg file
was http://server.com:portid/your web_agent here
my port id was 81 which is port at which my listner [vis] for vision
database is set
your web_agent here -- vd11plsql/plsql
which is plsql agent path for VD11PLSQL plsql agent
/vd11plsql/plsql is virtual path defined in web request broker for PLSQL
catridge which corresponds to %ORAWEB_HOME\bin
also what should be the system profile setting
my ORAWEB_HOME is d:\orant\ows\3.0
We are using OWS3.0
Now ..for setting up the workflow monitor
for the web listener [vis] on port 81
file system path = d:\orant\forms45\java\oracle\apps\fnd\wf\
flag = NR
virtual path = /OA_JAVA/oracle/apps/fnd/wf/
after doing these things when i access workflow monitor from
a notification -
get Internal error try aagain
Can any of u , please help me out how i can proceed with it
If you are using it then can u send a a sample entry ..
of it ..
I in urgent need ...to implement it at client site
David Philips
Tech Consultant
RELICON
DUBAI
From: Shanthi Shanthi@SignatureEyewear.com
Subject: Setting up Workflow
Hi all,
We want to customize work flow to generate account code combinations in AR
as per our requirements. Can somebody tell us how to do it? The accounting
structure is
Company-CostCentre-Account-Brand-Type
We need to set the cost centre value on the revenue and cogs accounts based
on the customer class on the order.
Any input will be highly appreciated. Thanks in advance,
Shanthi
From: "Mohan Iyer" miyer@fortuna.com
Subject: RE: Setting up Workflow
Shanthi,
You will need to install the WorkFlow Builder software on your PC (client)
and then learn to use it to be able to make the changes.
The way to learn it is to either take a class or just dive into it and learn
by getting references from other people who have used it.
Hope this helps and you are successful in your task
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA