Transcript to see my NOUG presentation with screen shots of the

Oracle Workflow Cartridge
Jason Moody
Into Networks
[email protected]
(617) 905-7892
Northeast Oracle Users Group
(4/12/2000)
Agenda
Overview
Process Modeling
Examples (Content Workflow)
Architecture
Users View
Extending Oracle Workflow Cartridge
Workflow Versioning
Northeast Oracle Users Group
(4/12/2000)
Overview
Predictability.
Eliminates the ‘Excel Spreadsheet’
phenomenon.
Oracle Workflow allows your customers to
modify your product without writing code.
Northeast Oracle Users Group
(4/12/2000)
Practical Considerations
Workflow is tougher (than data modeling).
Process modeling must be done up front.
Long testing periods.
Northeast Oracle Users Group
(4/12/2000)
Project Timeline
Medium Project (with 4-5 processes)
Design Phase: 4-6 weeks
Implementation: 4 weeks
Testing: 4 weeks
User Acceptance: 2 weeks
(Expect 4 months just for workflow)
Northeast Oracle Users Group
(4/12/2000)
Design Phase
Process Modeling
Flow and Roles in the
Title Manufacturing Process
Management
Filter
Potential solution from
Engineering
Title begins the encoding process
Arepa Encode
Title is waiting to
be assigned to an
encoder
Title is assigned to an encoder
Arepa User
Title is being
encoded
Technical Failure - Briq is sent back to the encoder
ERD
Data Dictonary
Arepa Engineering
Defect
Briq is sent to profiling
Title Defect
Potential solution from
Publisher
Visio
Designer
Start
Manufacturing
Arepa Profile
Briq is waiting to
be assigned to a
profiler
Briq is assigned to a profiler
Briq successfully passes profiling
The title is cancelled
because no fix is
available from
the Publisher
and we will not
produce an
Arepa engineering
fix.
Arepa Archive
QA process and
check-in
Gather statistics
End Manufacturing
End Manufacturing
Arepa User
Briq is being
profiled
Visio Diagram
Northeast Oracle Users Group
(4/12/2000)
Example: Content
Workflow System
Into Networks allows software on-demand
No Download or installation of titles.
Description: Content acquisition for
software titles including:
Assets (Screen shots)
Encoding information
Title Notes
Northeast Oracle Users Group
(4/12/2000)
Content Workflow (Con’t.)
Workflow
2 processes
14 notifications
Data Entry
40+ forms
Northeast Oracle Users Group
(4/12/2000)
Architecture
Oracle Database
Application Server
Oracle Application Server
Webdb
Workflow Builder
Email
Northeast Oracle Users Group
(4/12/2000)
Architecture
Roles
Database Roles
Notifications (End User Client)
Web Monitor
Client Server (Apps Version)
Business Logic (PL/SQL Blocks)
Processes (Workflow Builder)
Northeast Oracle Users Group
(4/12/2000)
Architecture
Workflow
Directory Services
Users (Database)
Roles (Database)
Web Notification
List
Workflow Builder
Oracle
Applications
Server
Workflow Monitor
Title History
(CWS)
Notification
Services
Engine
Send
Execution
Respond
Definition
Forward
Adminstration
Cancel
Monitoring
Query
Query
Workflow Loader
Reporting (CWS)
Cold Fusion
Oracle Workflow Objects
Data Entry (CWS)
Views
Summary
Functions
Procedures
Workflow Definition
Files
Content Database
Email
Notification Mailer
(Sendmail)
Oracle Workflow Enabled Application
Data Entry
Application
End-User Client
Application Server
CWS Reporting
Oracle Server
Northeast Oracle Users Group
(4/12/2000)
Workflow Development Client
Roles
Workflow views show database roles.
Example: Wf_users
NAME NOTIFICATION_PREFERENCE EMAIL_ADDRESS
MIKES
BETA
TEST
MAILHTML
MAILHTML
MAILHTML
MIKES
BETA
TEST
Northeast Oracle Users Group
(4/12/2000)
Notifications
Northeast Oracle Users Group
(4/12/2000)
Business Logic
CREATE OR REPLACE PACKAGE BODY OWF_ADM.WF_AREPA
as
procedure arepa_startprocess (p_itemkey in varchar2)
is
v_wf_process
varchar2(30);
v_item_type
varchar2(30);
v_owner
varchar2(30);
begin
v_wf_process := 'P_OVERVIEW';
v_item_type := 'AREPA';
v_owner := 'OWF_ADM';
wf_engine.createprocess (
itemtype => v_item_type,
itemkey => p_itemkey,
process => v_wf_process
);
Northeast Oracle Users Group
(4/12/2000)
Workflow Builder
Northeast Oracle Users Group
(4/12/2000)
Workflow Process
Exit Process
NOOP-TITLECANCELMFG
N_MFG_CONTENT_FAILURE
END - REJECTED MANUFACTURING
(Reject)
Retry Process
CONTENT_FINISHED_REJECT-1
N_DBFAIL-1
N_DBFAIL-CHECKPRI
N_CONTENTFINISHED
Reject
Acknowledge
Fail - DB error
Fail - DB error
Reject
Pass
START
Acknowledge
MARKETCONTENT N_SET_PRIORITY
Pass
CHECK PRIORITY
Acknowledge
N_STARTMFG
Approve
P_ENCODING-1
Fail - Rule violation
Approve
P_PROF-1
P_AND
NOOP-TITLECOMPLETE
END - APPROVED CONTENT
(Approve)
Pass
Approve
Fail - Rule violation
Retry Process
Approve
Retry Process
N_STARTASSETS
P_CONTENT_FAILURE-CHECKPRI
P_CONTENT_FAILURE
ASSETS
Reject
Fail - DB error
Fail - Rule violation
Exit Process
Retry Process
Exit Process
Acknowledge
Exit Process
NOOP-TITLECANCELCONTN_ASSET_CONTENT_FAILURE
N_DBFAIL-ASSETS
CONTENT_FINISHED_REJECT
Northeast Oracle Users Group
(4/12/2000)
END - REJECTED MARKETING
(Reject)
Extending Oracle Workflow
Application Servers
Management Reporting
Portal
Comments
Northeast Oracle Users Group
(4/12/2000)
Adding Cold Fusion
Integrated Cold Fusion
Rapid Application Development
Data Entry Screens
Single Login (OAS manages logins)
Northeast Oracle Users Group
(4/12/2000)
Reporting Problems
Need to provide lots of information
Workflow and Application Specific
No Out of Box Management Reports
Try to use existing reports instead of
creating new.
Especially with workflow: People want to
see the same data multiple ways.
Northeast Oracle Users Group
(4/12/2000)
Management Reporting
No Out of Box
Management
Reports
Created custom
approach vs.
Discoverer
Northeast Oracle Users Group
(4/12/2000)
Portal Home Page
Northeast Oracle Users Group
(4/12/2000)
Library Page
Northeast Oracle Users Group
(4/12/2000)
Title Detail Page
Northeast Oracle Users Group
(4/12/2000)
Comments
People want to communicate problems to
others.
End to End Systems
Future versions of workflow may have this
functionality.
Northeast Oracle Users Group
(4/12/2000)
Comments - Data Entry
Northeast Oracle Users Group
(4/12/2000)
Comments - Report
Northeast Oracle Users Group
(4/12/2000)
Workflow Versioning
Real World Constraints of Workflow
Process changes
Items finish with the version they start with.
Cannot make changes to process structure
on the ‘fly’.
Can change notifications (messages)
users see.
Northeast Oracle Users Group
(4/12/2000)
Workflow Thoughts
Do up front process design work.
Problem to change process later
Design reporting piece as part of original
project.
Make Notifications (Messages) single point
of contact.
The first project is intense.
Northeast Oracle Users Group
(4/12/2000)