Oracle Workflow Cartridge Jason Moody Into Networks jasonmoody

Oracle Workflow Cartridge Jason Moody Into Networks jason@moody. net (617) 905 -7892 Northeast Oracle Users Group (4/12/2000)

Agenda z. Overview z. Process Modeling y. Examples (Content Workflow) z. Architecture z. Users View z. Extending Oracle Workflow Cartridge z. Workflow Versioning Northeast Oracle Users Group (4/12/2000)

Overview z. Predictability. z. Eliminates the ‘Excel Spreadsheet’ phenomenon. z. Oracle Workflow allows your customers to modify your product without writing code. Northeast Oracle Users Group (4/12/2000)

Practical Considerations z. Workflow is tougher (than data modeling). z. Process modeling must be done up front. z. Long testing periods. Northeast Oracle Users Group (4/12/2000)

Project Timeline z. Medium Project (with 4 -5 processes) z. Design Phase: 4 -6 weeks z. Implementation: 4 weeks z. Testing: 4 weeks z. User Acceptance: 2 weeks z(Expect 4 months just for workflow) Northeast Oracle Users Group (4/12/2000)

Design Phase z. Process Modeling y. Visio y. Designer z. ERD z. Data Dictonary Visio Diagram Northeast Oracle Users Group (4/12/2000)

Example: Content Workflow System z. Into Networks allows software on-demand y. No Download or installation of titles. z. Description: Content acquisition for software titles including: y. Assets (Screen shots) y. Encoding information y. Title Notes Northeast Oracle Users Group (4/12/2000)

Content Workflow (Con’t. ) z. Workflow y 2 processes y 14 notifications z. Data Entry y 40+ forms Northeast Oracle Users Group (4/12/2000)

Architecture z. Oracle Database z. Application Server y. Oracle Application Server y. Webdb z. Workflow Builder z. Email Northeast Oracle Users Group (4/12/2000)

Architecture z. Roles y. Database Roles z. Notifications (End User Client) y. Web Monitor y. Client Server (Apps Version) z. Business Logic (PL/SQL Blocks) z. Processes (Workflow Builder) Northeast Oracle Users Group (4/12/2000)

Architecture Northeast Oracle Users Group (4/12/2000)

Roles z. Workflow views show database roles. y. Example: Wf_users 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 varchar 2) is v_wf_process varchar 2(30); v_item_type varchar 2(30); v_owner varchar 2(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 Northeast Oracle Users Group (4/12/2000)

Extending Oracle Workflow z. Application Servers z. Management Reporting z. Portal z. Comments Northeast Oracle Users Group (4/12/2000)

Adding Cold Fusion z. Integrated Cold Fusion y. Rapid Application Development y. Data Entry Screens z. Single Login (OAS manages logins) Northeast Oracle Users Group (4/12/2000)

Reporting Problems z. Need to provide lots of information y. Workflow and Application Specific z. No Out of Box Management Reports z. Try to use existing reports instead of creating new. z. Especially with workflow: People want to see the same data multiple ways. Northeast Oracle Users Group (4/12/2000)

Management Reporting z. No Out of Box Management Reports z. 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 z. People want to communicate problems to others. y. End to End Systems z. 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 z. Real World Constraints of Workflow z. Process changes y. Items finish with the version they start with. y. Cannot make changes to process structure on the ‘fly’. z. Can change notifications (messages) users see. Northeast Oracle Users Group (4/12/2000)

Workflow Thoughts z. Do up front process design work. y. Problem to change process later z. Design reporting piece as part of original project. z. Make Notifications (Messages) single point of contact. z. The first project is intense. Northeast Oracle Users Group (4/12/2000)