The following is intended to outline our general

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Service Enabling E-Business Suite Nishit Rao Group Product Manager Fusion Middleware @Nor. Cal OAUG Jan 17 th 08

Service Oriented Architecture for EBS

What is Service Enablement? It’s all about… • Capability to Provide Services Service Broker Find Register • Ability to Consume Services Service Contract • Abstracted Re-Usable Interfaces • Standard Based Web Services Service Consumer Service Provider • Documented Services & API Client Service

Why Service Enablement? Business Drivers • • • Leveraging the investment of existing Applications Rapid time to design and deploy new solutions Interoperability in a heterogeneous ecosystem Integrated View of business processes Maximize ROI by re-usability of services Low TCO for implementation and deployment

Service Oriented Architecture SOA Concept E-Business Suite SOA Service Broker: Describe Service’s Location and Contract Integration Repository Service Provider: An appropriate agent to implement a particular service Oracle E-Business Suite Adapter Integration Repository Find Register Service Contract Service Consumer Client E-Business Suite Adapter Service

Integration Repository Single Source of Truth • • PL/SQL APIs (2650+) Open Interface Tables (147+) Concurrent Programs (214+) XML Gateway (170+) e. Commerce Gateway (24+) Interface Views Java Web Service

Integration Repository http: //irep. oracle. com • Catalog of all Public Interfaces – the single source of truth for Integration • Common User Interface to search and browse E-Business Suite interfaces • Embedded within the core E-Business Suite schema to leverage the standard security system • Preconfigured for exposing & administering Interface Points as Web Services • Automatically kept in step with source code, via standard patching technology

Oracle E-Business Suite Adapter Schematic Architecture PL/SQL API, Views, Business Events XML & e. Commerce Gateway Open Interface Table & Concurrent Programs Integration Repository Oracle SOA Suite BPEL PM Oracle Apps Adapter BAM ESB B 2 B

Oracle Adapter Architecture Adapter Design-time (JDeveloper) Generates WSDL / JCA Service definition Oracle Adapters (JCA 1. 5 Resource Adapter) Technology Legacy Application Package Application Backend Native Interfaces JCA 1. 5 Adapter Framework WSDL/JCA ESB Exposes WSDL/JCA Services BPEL PM J 2 EE Application Server (Oracle AS, BEA Weblogic, JBoss, IBM Websphere)

Salient Features Oracle Applications Adapter • Leverages Integration Repository for 11. 5. 10 • Expose only recommended public interfaces • Version aware design-time • Packaged IREP content for 11. 5. 10 • Direct Application connectivity for pre 11. 5. 10 • Completely standards based product • XA Support • Automatic Application Context Initialization

Oracle Apps Adapter Standards Based • Based on J 2 CA 1. 5 standards • Deployed as a resource adapter in the same Oracle AS Server Containers for J 2 EE (OC 4 J) • Supports open standards, such as • • • J 2 EE Connector Architecture (J 2 CA) Extensible Markup Language (XML) Web Service Invocation Framework (WSIF) Web Service Inspection Language (WSIL) Web Service Definition Language (WSDL) • Uses JDeveloper based design-time environment • Generates Adapter metadata as WSDL files with J 2 CA extension

Supported Interfaces • Business Events • • Seeded and custom events for outbound Only custom events for inbound • PL/SQL APIs • • • Packaged IREP annotated for 11. 5. 10 (public APIs) All for pre-11. 5. 10 Custom + Ones still not annotated in IREP • XML Gateway Interfaces • Seeded + custom maps • Open Interface Tables & Concurrent Programs • ECommerce Gateway Interfaces

Oracle E-Business Suite Adapter Benefits • Exposes E-Business Suite Integration Interfaces as standard Web Services for 1. 5. x versions • Supports multiple versions of Oracle Apps in a heterogeneous ecosystem • Supports most-used interface types • Intuitive UI • Simplifies design-time experience • Faster design to deploy time • Declarative development of integration solutions

About Integration Interfaces

Business Event System • Events as business documents • • • Component of the Oracle Workflow Based on Oracle Advanced Queues (Oracle AQ) Allows Apps modules and external systems to raise events Facilitates event subscriptions Subscriptions can be synchronous or asynchronous • Provides hooks into the E-Business Suite for, • Messaging Integration • Workflow Business Processes • Code Extensions • Supports non-invasive changes

Business Event System Component Architecture AQ AQ Business Events • New Order • Update Order • Cancel Order AQ AQ Business Events System Workflow Engine Business Events (XML) Oracle Applications

PL / SQL APIs • Public PL/SQL are used for inserting and updating Oracle Applications data • Multiple operations can be performed by the procedures for a Business Service • The PL/SQL APIs are typically used for A 2 A integration purposes

PL/SQL APIs Architecture Simple Data Type Design Time WSDL IREP Apps Context Info JPub PL/SQL Wrappers Complex Data Type Apps. Initialize Run Time Shopping Cart Add Remove List Data

Oracle XML Gateway • Typically used to integrate with trading partners using XML Document formats that conform to OAG standards • Messaging platform for transmitting XML documents • Repository-based message designer • Event-Driven message processing using Workflow

XML Gateway Schematic Transactional Diagram XML Gateway E-Business Suite Business Event API Workflow Sales Order Consume XML Message* • XML Messages defined by OAG Purchase Order Business Event Workflow Create XML Message* In Message Queues Out

Open Interface Tables • Intermediate staging tables when the data is inserted / updated. • The data from these tables is posted into the base tables via the concurrent programs • The Open Interface Tables can be exposed as web service based integration interfaces • The Open Interface Tables are typically used for internal and A 2 A integration purposes

Open Interface Tables Schematic Diagram Oracle Form 3 rd Party Adapter EAI Solution SQL*Loader Validation using the systems application logic Flat File Database Gateway Technology Oracle Database Non Oracle Database Import Program Interface Tables EDI Gateway / XML Gateway EDI or XML

Open Interface Tables Architectural Diagram Design Time Create JOIN (optional) WSDL IREP Interface Tables Apps. Initialize Run Time Apps Context Info Shopping Cart Add Remove List Data

Concurrent Programs • An Execution file that can be an operating system file or database stored procedure which contains application logic (Example: PL/SQL, Java) • Typical use is to move data from staging tables to base tables • The concurrent program can be exposed as a web services based integration interface • The concurrent program is typically used for internal and A 2 A integration purposes

Concurrent Programs Architectural Diagram, Example Design Time WSDL Concurrent Program Interface Tables Concurrent Program Base Tables IREP Apps Context Info Apps. Initialize Run Time Apps. Initialize

Leveraging Fusion Middleware

Oracle BPEL PM XML & e. Commerce Gateway Business Events Concurrent Programs Oracle E-Business Suite Integration Interfaces Oracle EBusiness Suite Adapter Apps Adapter Web Servic e Interfa ce in Oracle BPEL PM Open Interface Tables, View, PL/SQL APIs Integration Repository Process Orchestration Oracle BPEL PM

Oracle ESB Open Interface Tables, View, PL/SQL APIs XML & e. Commerce Gateway Business Events Concurrent Programs Oracle E-Business Suite Integration Repository Event Driven Architecture Integration Interfaces Oracle EBusiness Suite Adapter Apps Adapter Oracle ESB

Oracle Business Activity Monitoring Open Interface Tables, View, PL/SQL APIs XML & e. Commerce Gateway Business Events Concurrent Programs Oracle E-Business Suite Integration Repository Real-Time Dashboards Integration Interfaces Oracle EBusiness Suite Adapter Apps Adapter Oracle BAM

Oracle DB Adapter vis-à-vis Oracle Applications Adapter Feature DB Adapter Oracle Applications Adapter Supported Interfaces • PL/SQL API • Open Interface Tables & Concurrent Programs • Open Interface Views • PL/SQL API • Open Interface & Concurrent Programs • BES • XML Gateway • Open Interface Views Integration with IREP Not possible Supported Public versus private interfaces Exposes both public as well as private Oracle Application Interfaces Only exposes public Oracle Application Interfaces Application Context support Does not provide any support. Enables application context to be set up either statically or dynamically

EBS Adapter Demo

Order Visibility Case Study

Business Problem • The Business Use Case • Move to automated Quote-to-Order Processing. • Faster rampup of additional B 2 B partners. • Increased RN PIPs interactions (new message types being added) • Partners are demanding faster turnaround, forcing Company to upgrade I. e. – stop being the bottleneck • What is expected from BPEL/BAM • Event driven integration and orchestration for Order Status, ASN, and Invoice from ERP (EBS) to B 2 B • Create Rosetta. Net documents for PO, ASN, and Invoice • Order Processing Dashboard

Technical Issues/Requirements • Technical Requirements • Integrate EBS with 3 rd Party B 2 B using JMS. • Order Processing was heavily customized with custom PL-SQL validation. • The Order for EMEA has different validation from Order for APAC. • SLA from trading partners (15 m – 1 h) turnaround for order processing. • Software versions • EBS for Order Processing. • 3 rd Party for B 2 B. • BPEL for Integration and BAM for Visibility. • Siebel for Order Capture.

Order Processing Workflow events generated at Key Transaction Points Logical Architecture Events published to single generic Q BPEL dequeues using correlation ID and enqueue to JMS Generic Queue ASN Invoice Order Status Siebel Captures Order and matches to Quote sends order to EBS

BAM Usage • Information available: • Order status • Volume counts • Cycle times • B 2 B service level • Errors • Search capability: • Date range • Error • Customer • Quote number • PO number • SO number • Last state

Q & A