Varadarajan Rajaram Senior Product Strategy Manager Process and Integration Oracle Corporation

1. Varadarajan RajaramSenior Product Strategy Manager Process and Integration Oracle Corporation

2. Oracle Workflow Release 11i.10+CUs[1] [1] CU = Cumulative Updates

3. Oracle Workflow 11i.10+CUs • Worklist Flexfields • Mailer Enhancements • SSL Support • Smart Error Handling • Integration with System Alerts • Business Event System • Declarative Error Handling

4. Worklist FlexfieldsDescription • Message Attributes displayed in the Worklist • Allows users to sort on those attributes • Send and Respond message attributes can be mapped • Supports multiple data types • Supports Flexfields rule levels

5. Vanilla Worklist

6. Personalized View Worklist Flexfields Worklist Flexfields

7. Worklist FlexfieldsData Type Support • Supported data • Date • Number • Text • Form • URL • Unsupported data • Lookups • Role • Document

8. Worklist FlexfieldsRule Levels • ‘Core’ level • The columns are 'protected' and cannot be overridden by Rules at the customer site • ‘Limit’ level • The columns are not 'protected‘, and Rule can be disabled by the customer, or overridden by another 'Limit' level Rule for the same Workflow Type with a higher 'Phase', or by a 'User' level Rule for the same Workflow Type with a higher ‘Phase’. • ‘User’ level • The columns are not 'protected‘, and Rule can be disabled by the customer, or overridden by a 'User' level Rule for the same Workflow Type with a higher ‘Phase’.

9. Defining Worklist Flexfields • 3-Step Procedure: • Create a Worklist Flexfields rule • Create a Personalized View for the personal Worklist • Secure the Personalized View with a securing function Personalization

10. Step 1: Create Worklist Flexfields Rule

11. Select And Map Message Attributes

12. Step 2: Create Personalized View

13. Step 3: Secure View with Subfunction

14. System Alerts • Notify system administrators of serious problems or potentially serious problems. • System Alerts are posted to the Oracle Applications Manager (OAM) console • Context information such as end user, responsibility, OS Process, database session automatically captured • Oracle Applications Manger tracks multiple occurrences of the same alert message to prevent duplicate notifications from being sent.

15. System Alerts

16. System Alerts Integration • Mailer • Agent Listeners • System Alerts sent when • Component goes to “Stopped with Error” Status • Component goes to “System Deactivated” Status

17. Mailer Enhancements Security • Secure IMAP Connection • SSL will be used to establish a secure connection to the mail store • Secure SMTP Connection • SSL will be used to establish a secure connection to the SMTP Server

18. Mailer Enhancements Smart Error Handling • Bad E-mail Address • SYSADMIN as email address!! • Framework Content Generation Timeouts • Smart Error Handling • New Mail Status – FAILED • New Notification Preference – DISABLED • Concurrent Program to re-process FAILED notifications

19. Business Event System Enhancements • Declarative Error Handling • Subscriptions specify error handling • Error Handling Options • Stop and Rollback – Default • Skip to Next • Skip to Next - Ideal for subscriptions which are • Optional and/or independent in nature • Does not impact the execution of any other subscriptions defined for that event

20. Business Event SystemDeclarative Error Handling

21. Business Process Management Oracle E-Business Suite Roadmap

22. Workflow Engine Business Event System (BES) Business Process Management – Now Applications Forms Self Service Custom Third Party Systems Repository

23. Advantages of BPEL • Standards-based process orchestration • Industry standard language: BPEL • Standards-based connectivity to heterogeneous applications • JCA, JMS, WS etc. • Move towards Service Oriented Architecture

24. Workflow Engine Web Provider Business Event System (BES) BPEL Integration – Now! BPEL Server Applications Forms Self Service Custom Oracle Application Server Repository Third Party Systems

25. BPEL Integration – Now! • Whitepaper: Oracle E-Business Suite to BPEL and Back in 3 Easy Steps • http://www.oracle.com/technology/products/applications/integration/BPEL-BES4Apps.zip • Leverage Business Event System • Asynchronous invocation of BPEL processes • Asynchronous invocation of business logic in E-Business suite from BPEL • Sample code

26. Workflow Engine Business Event System (BES) Web Provider E-Business Suite Adapter BPEL Integration – R12 Applications Forms Self Service Custom BPEL Server Oracle Application Server Repository Third Party Systems

27. BPEL Integration – R12 • Tighter Integration with BES • Oracle E-Business Suite Adapter integrated with Integration Repository • Comprehensive transformation support • OAG messages • XSLT-based transformations • No code to generate XML document!

28. Project Fusion • The next step in Oracle applications and technology, embracing a service oriented and standards-based information architecture • Allows more cost effective integration, flexible business processes and extensibility • About fusing processes, people, and products to leverage the best parts from each of the components

29. Project Fusion • Architecture • Service-Oriented Architecture • Global Single Schema • Embedded Business Intelligence • Technology • J2EE • Web Services • Grid Computing • Standards • BPEL • XML

30. BPEL Applications Forms Self Service Custom Workflow Engine Business Event System (BES) Messaging Database – 10G Application Server–1.0.2.2 Events Service Beans Adapters Layered Extensions BAM BPEL Runtime Data Hub Business Process Management – Fusion Applications Upgraded to Fusion Portal ADF Java / J2EE Fusion Middleware ESB Fusion Repository

31. Project FusionBPEL Process Manager • Standards-based Business Process Management engine for Fusion • Make Extensions not Customizations • Layered Extensions • No client-side tool • Browser-based Business Analyst friendly tool • Built-in BAM Support • Standards-based integration with Enterprise Service Bus • Scalable, High-performance engine • Optimized for Fusion

32. Process and Integration Customer Advisory Board Work closely with customers to address tactical problems and help drive appropriate solutions that would solve customer pain points and make the current process and integration technology across various product families easy to manage, implement and customize.

33. Process and Integration Customer Advisory Board • Benefits of being a CAB member • Work with development to help set strategy for product direction • Opportunity to share industry knowledge • Help us drive requirements and influence the technology modernization • Interested? • E-mail varadarajan.rajaram@oracle.com to be nominated

34. OpenWorld 2005X-Treme Sessions • Business Process and Integration for Oracle, PeopleSoft and JD Edwards Applications - The Road Ahead   • Oracle E-Business Suite Business Process Management - Leveraging Workflow today and tomorrow • The Oracle E-Business Suite Event Driven Architecture

35. OpenWorld 2005Weekend Sessions • Business Process and Integration - Best Practices • Business Analysis and Simulation Workshop • Using the Oracle BPEL Process Manager with the Oracle E-Business Suite

36. For More Information MetaLink • Version numbers and certification status change frequently • See MetaLink for certification status and migration instructions OTN (Oracle Technology Network) Website • http://www.oracle.com/appstech

37. Q & Q U E S T I O N S A N S W E R S A