Transcript Self Service Web Apps Directions

Oracle Workflow
Directions
Atlanta OAUG
Brenda Carlton, KPMG Peat Marwick
June 19, 1998
Workflow - Overview
Routes Information
– Messages
– URL links
– Document management systems (coming)
Defines Any Rule
– Graphically define the rules of your process
– Express using PL/SQL
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
2
Workflow - Overview (cont.)
Delivers Electronic Notifications
– Any Apps user
– Any Email user
– Any Web browser user
Include anyone internal or external to your
organization
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
3
Workflow v. Alert
Workflow
 Manages execution of
complex business
processes resulting
from database events
 Process responses:
– Email
– Web Browser
– Applications
Alert
 Detects database
events
 Process responses:
– Email
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
4
Workflow - Components
Workflow Builder
(client)
Workflow Engine
(server)
Electronic Notification System (server)
Workflow Monitor
(server)
Workflow Definitions Loader (server)
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
5
Workflow Builder
Graphical, windows -based tool that lets
you use drag and drop operations to build
workflow processes
32 bit only - must use Win95 or NT
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
6
Workflow Engine
Set of tables and PL/SQL stored procedures
which manage the execution of a workflow
process
Generates complete audit trail
Delivers notifications and processes the
responses
Immediate and background processing
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
7
Workflow Definitions Loader
Transfer files between databases
Create flat files of workflow processes
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
8
Workflow Electronic
Notifications
Receive notifications via the web, email or
10SC applications
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
9
Workflow Monitor
Web based graphical tool that helps you
analyze your business processes
Requires a web server
Acts as Sysadmin of Workflow
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
10
Available Workflows in 10.7
10SC Application
 Engineering Change Orders
Web Application
 Purchase Requisitions
 Confirm Receipts
 Candidate Offer Letters
 HR Personal Information
 Expense Reports
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
11
Workflow - R11 and Beyond
 Supplier Registration
 Requisition Approval
 AP Procurement Card
 PO Document Approval





Employee Verification
AP Procurement Card
Manager Approval
Transaction
AP Invoice Import
PO Standard
PO Create Documents
PO Confirm Receipt






Reminder
PO Approval
Account Generator
PA Oracle Projects Library
PA Budget Workflow
PA Project Workflow
Journal Batch
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
12
Workflow - R11 and Beyond
 Person Search
 Standard Flexfield
 Career Management






Reviews
Person Suitability Match
HR Approval
HR Employee Direct
Access
HR Standard
HR Offer Letter
Order Entry Review





Workflow
Service Messages
Service Request
Service Request Action
AR: Substitute Balancing
Segment
Customer Registration
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
13
Workflow - How Do I Get It?
With Applications
Standalone Product - v 2.0.3
Interoffice Product
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
14
Workflow: Which Version?
V 2.0.2
 Comes with 10.7SC
on CD “Workflow
Embedded in Apps”
 Install on Client and
Server
V 2.0.3
 Comes with R11 or,
 Separate license as a
Stand-Alone Product
 Install on Server
Backpatch available soon for
enhanced 2.0.3 funtionality into
V2.0.2
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
15
Workflow - Software
Requirements
V 2.0.2
 Internet Explorer or
Netscape 3.0
 Oracle Web Server
V 2.0.3
 Internet Explorer or
Netscape 4.0
 JDK 1.1
 Oracle Web Server
June 19, 1998
Brenda
Carlton, KPMG Peat Marwick
16