Mark Craig Senior Product Manager Oracle Workflow Oracle Corporation

2. Mark CraigSenior Product Manager Oracle Workflow Oracle Corporation

3. Workflow and Business EventsDatabase to J2EE

4. Oracle Workflow • Supports enterprise requirements for business process management • Business Event and Process Definition • Business Process Automation, Integration • Business Process Intelligence • Traditional application workflows • Business document approvals • E-business integration workflows • Sending, receiving, routing on JMS messages

5. Oracle Workflow • Embedded Process Management Engine of • the Oracle E-Business Suite • Oracle Application Server 10g Integration technologies • Workflow Server 2.6.3 ships with upcoming Database/Application Server 10g releases

6. Business Benefits • Visual documentation of the business process • Crosses organizational, company boundaries • Analyze time and costs of entire processes with multi-dimensional analysis • Business processes will change • You can only fix what you can see • Enabling dynamic processes sympathetic to change • Change business processes without changing code (Reduced cost of ownership)

7. Workflow Enabled e-business Suite Release 11i highlights • CRM • Call Center • Service • Contacts • Support • Marketing • iStore • ERP • Order Management • Internet Procurement • Self Service Financials • Advanced Planning System • Projects • HRMS • Candidate Offer • Career Management Reviews And many more...

8. Traditional Workflow: Expense Report AP Standard Expense Report Process

9. Oracle Workflow For Java (OW4J) • Currently Under Development • Next generation of Oracle Workflow • Java based Business Process Management • Integrated with Oracle JDeveloper Application Developer Framework • You choose whether your workflow is executed by the database or java engine (based on where your business logic is deployed)

10. Architecture Transformation OW4J Oracle Workflow JDeveloper IDE (Java) Design Tool (Windows) Web Browser (HTML) PLSQL Engine Java Adapter Java Engine PLSQL Engine Database Repository Database or XML PLSQL Web Toolkit UI JSP UI

11. Business Events launch Business Processes

12. Why? • Don’t hardcode your business actions or process to your application • Achieve maximum flexibility to make additions and modifications without changing code • Identifying business events already key part of the development process • Register Events, optionally register actions

13. Business Event Application Business Event Actions Workflow Business Logic Integration

14. Business Event System • Applications raise events • Declaratively register • Business Events • Actions to Business Events (no coding required) • Actions include • Launching a workflow • Publishing XML to JMS • Executing Code

15. Business Event System Architecture Application Matching Event Subscription Raise Local Events Workflow Process Event Dispatcher Action (Java/PLSQL) Listen External Events XML on JMS JMS

16. Model your Business Process

17. Model your Business Process • Bottom up/Top Down Design • Receiving and Raising Events • Receiving and Sending Messages • Business Logic • Task assignment • Use sophisticated constructs • Looping • Results-based branching • Parallel Flows • Rendezvous

18. Today…Oracle Workflow Builder

19. Future……OW4J Modeler • OW4J Modeler • Applications developer tool • Integrated with Oracle JDeveloper Application Framework • Based on XML • Leverages Oracle JDeveloper Application Framework metadata services • Runs on platforms supported by Oracle JDeveloper

20. OW4J Modeler

21. OW4J Modeler Application Navigator Component Palette Structure Pane Property Inspector Process Window

22. D E M O N S T R A T I O N OC4J Modeler

23. Future…OW4J Self Service Modeler • OW4J Self Service Modeler • Browser Based • Process modeler for Business Analysts • Optimized for simple use case scenarios (Notification messages editing & simple activity re-sequencing ) • Hosted environments

24. OW4J Self Service Modeler

25. Layered Customizations • Base Workflow Definition/Template modeled in OW4J Modeler • Never overwritten by customers • Customizations applied in OW4J Self Service Modeler • Layered on top of base definition at runtime • Available Customization layers • User • Verticalizations • Localization • Organization • Powered by Application Developer Framework XML metadata services technology • Manages runtime application XML metadata (file/database) • Supports Reuse, Caching, Translation, Customization

26. XML Business Process Definition • OW4J based on XML Schema process definition • Member of the Workflow Management Coalition • Moving towards industry standard XML schema based import/export definition of business process • Closely following ongoing debate(s) in various standards bodies (BPMI.org ,BPEL….)

27. The Promise of a Standard Definition • Business Analysts already using specialized desktop applications to model business processes • These applications will be able to export an industry standard XML definition of a business process…… • XML imported into OW4J Modeler • Configuration by Developers and Analysts • OW4J Engine runs that business process

28. Include People (Employees,Customers,Suppliers) in your Business Process

29. Automated Task Management • FYI Notifications • Response Required Notifications e.g.. Approvals • Browser based Oracle Workflow Worklist • Automatically Notify Users of Tasks • Sends Notifications to Roles (users and groups) • Drill down capability (URL, Attachments) • Escalation Management • Vacation Handling

30. Automate Task Management

31. Worklist Configuration Capabilities Control Notification Filtering, Column Display and Order

32. Choose Column Display and Order

33. Choose Notifications to Display

34. Notification Content

35. Notification Mailer • Based on Java Mail APIs, XML and JMS • Outbound SMTP, Inbound IMAP • HTML, Text, Summary formats • Managed & Configured using the Oracle Workflow Manager • Some customers send up to 20000 outbound emails/day

36. Wireless Access to Notifications • Leverages Oracle Application Server 10g Wireless Option • Sends FYI or Response Required Text Messages • Wireless Devices supported • PDA • Phone • Instant Messaging • Voice etc

37. Electronic Signatures • What are Electronic Signatures • Password Based E-Signatures (PSIGS) • Digital Signatures (PKCS7 / X.509) • Biometrics, etc. • Why Electronic Signatures • Government Requirements • Contractual Obligations • High Value Transactions • Security Consciousness

38. Electronic Signatures • Already available in Oracle E-Business Suite • Password Based Signatures via Browser • Under Development • Digital Signatures(PKCS 7/X.509) via Browser • Future Directions • Signing via e-mail (S/MIME)

39. Content Management Workflows • Oracle Content Management SDK • Java based, Object Oriented File System • Targeted at Developers building CM solutions • Integration with Oracle Workflow via AQ • Oracle Files • Enterprise File Server Replacement • Built on CM SDK • Workflow integration for approval and routing

40. Automate your Business Process

41. Business Process Automation • Short and Long Lived Processes • Sequence the execution of • Java Methods • Enterprise Java Beans (EJBs) • Web Services • PL/SQL • Task assignment • Consume and Publish JMS Messages • Store and Manipulate Java Objects • Serialize/Deserialize Java Objects

42. Business Process Execution • The OW4J Engine will complement, not replace the existing database resident PL/SQL engine • Easy optional migration for existing customers from PL/SQL Engine to Java Engine • For existing customers, no incentive to upgrade existing processes until/if applications are reimplemented in Java.

43. Utilize Expression Languages • Minimize Coding • Route on Java Object or EJB Attributes • SPEL, the Simplest Possible Expression Language • Example: Employee Item Attribute stores as Employee Java Object • ${employee.salary>50000} returns boolean which workflow can route on • XPATH for XML • Third Party Java Rules Engines • Database Rules Engine

44. OW4J Engine Status • OW4J Engine Developer Preview • Lightweight, no Database required • Demo Application: Requisition Approval • Available from OTN now! • EJBs with underlying PL/SQL implementation (OTN download) • Customers can verify and use the new interface • Execution still performed by PL/SQL workflow engine

45. Manage and Optimize Business Processes

46. Oracle Workflow Status Monitor Universalaccess to process status • Summary of key activities • Decision makers in the process • Current owners • Graphically monitor and administer workflow transactions • View and analyze transaction history • Retry or skip any activity • Rewind and rerun any process • Available to end users and administrators

47. Self Service Status Monitor

48. Oracle Workflow Status Monitor Universalaccess to process status

49. Oracle Workflow Manager • Component of Oracle Enterprise Manager • Browser Based System Management Tool • Dashboard for System Administrators and DBAs • Highlights • Manage Workflow Background Processes • Manager Workflow Mailer • Track Workflow System Status • Drill Down Capability

50. Oracle Workflow Manager