1

<Insert Picture Here>

An Oracle E-Business Suite Integration Primer: Technologies and Use Cases

Veshaal SinghSenior Director – ATG Development

Neeraj Chauhan Manager – Product Management

3

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.

4

<Insert Picture Here>

Presentation Agenda

• Overview of Integration• Oracle E-Business Suite – SOA Capabilities• Leveraging Oracle SOA Suite• Oracle E-Business Suite Adapter• In Tandem With AIA• Business Use Cases • Roadmap

5

Oracle E-Business SuiteIntegration Landscape

J2EE Application Server(Oracle AS)

Oracle Workflow

Business Event System

eCommerce Gateway

XML GatewayPL/SQL APIs

Interface Tables

Concurrent Programs

BSO Java APIs Interface Views

Integration Repository

Integrated SOA Gateway

Web Services

6

Enterprise Manager Grid Control 10g

JSP

Forms

BI Publisher

BC4J

OC4J

Web

Lis

tene

r

UIX

Client

RAC & ASM

Global Single Data Model

10g

Application Database

11g

Release 12 Technology StackArchitecture

7

Oracle Workflow

Directory Services

Oracle Server

Notification Services

WorkflowEngine

Oracle Workflow Enabled Application

WorkflowClient

WorkflowBuilder

WorkflowDefinition

Files

WorkflowLoader

ApplicationServer

NotificationMailer

Browser Client

WebNotification

Worklist

WebMonitor

WebAnalysis

Tools

MailApplications

Business Event

System

Advanced Queues

8

Mailer APIs for Integration

Internal Name DescriptionWF_MAIL To access the Oracle Workflow message

subsystem and send messages through e-mail.oracle.apps.fnd.wf.mailer.Mailer

Invokes & subsequently controls the inbound & outbound threads for a notification mailer

WF_MAIL_UTILTo perform conversions of notification data.

WF_NOTIFICATION To access the Oracle Workflow Notification System and manage notifications.

WF_PURGE To purge obsolete runtime data for completed items & processes, and expired design info, users & roles

WF_XML To access the Oracle Workflow XML message processing subsystem. & perform various actions

9

Business Event System

Business Event based Integration

OutboundMessage

ApplicationApplication

InboundMessage

Business Events• New Order• Update Order• Cancel Order

Advanced Queuing

Workflow Engine

10

Business Event System Architecture

DatabaseEvent

Dispatcher

Java Actions

PLSQLApplication

JavaApplication

PLSQLActions

JavaEvent

Dispatcher

Common Registry of Actions

PLSQLWorkflow

Notifications

XML on JMSWeb Services

Asynchronous or Synchronous

Events

Events

11

Business Event – Outbound integrationTransaction Diagram

Run Time

Action PerformedEvent

Raised

Business Event

Event SubscriptionListens to AQ

WF_BPEL_QAdvanced

Queue

S1 –Sn SeededSn+1 Deferred Subscriptions

WF_BPEL_QAdvanced

Queue

Design Time

12

Business Partner Integration

CustomersSuppliers

BanksPartners

OrdersInvoices

PlansProduct Designs

OAGISRosettaNetHL7X12, Edifact

13

Oracle E – Commerce GatewayTransactional Diagram

Business Partner’s

Application

EDI Translator

Interface FileStandard X12, EDIFACT File

14

XML GatewayTransactional Diagram

Oracle EOracle E--Business SuiteBusiness Suite XML Gateway

Workflow

Message Queues

Out

In

Create XML

Message*

Consume XML

Message*Workflow

API

PurchaseOrder

• XML Messages defined byOAG

SalesOrder

Advance

Queue

Advance

Queue

Integration with OTA JMS, B2B

15

PL/SQL APIs - Integration

Simple Data Type

Wrapper Package

ComplexData Type

Service

16

Open Interface TablesSchematic Diagram

ConcurrentProgram

SQL*Loader

Staging Tables

EDI Gateway

XML Gateway

3rd PartyAdapter

Open Interface Tables

Validation using the

application logic

17

Supplier: Order ProcessCombination of Workflow & Business Events System

Receive Order

Check Order Details

Customer Credit Check

Item Stock Check

Send Order Ack

ASN Process

Send Invoice

PL/SQL APIOpen Interface Table

XML Message EDI Message

* Sub Process

Business Event

18

Integration RepositoryCustomization support

• Catalog of all annotated public integration interfaces

• Search / Browse by Product Family / Interface Type / Standards

• Part of EBS Integrated SOA Gateway – R12.1.1 Custom Interfaces

( From Partners / Customers)

Oracle Seeded Interfaces

19

Publishing Custom Integration Interfaces

Integration Repository

StandAlone Parser

FNDLoad

HR

Projects

Finance

Order

Procure

Planning

Sales

Shipping

PL/SQL API

Business Event

Business Service Object

Concurrent Program

Annotate Interfaces

XML Message

Custom interfaces in E-Business Suite

Reads annotated files and generates ILDT Files

Uploads Loader File to Integration Repository

20

SOA Enablement Of Oracle E-Business SuiteFor Oracle E-Business Suite Architecture

Oracle E-Business Suite Integrated SOA Gateway

21

Oracle E-Business Suite Integrated SOA Gateway

Integrated SOA Gateway

Integration Repository

Consume Services

Provide Services

SCM Service

Std WS Client

HRMS Service

Apache Axis

BPEL PM / OSBLogistics Service

External Web service

22

SOA ProviderProvide Web services

Process Manager

Enterprise Integration

Publish

Generate

Deploy

AuthenticateMonitor

Authorize

Invo

ke S

ervi

ceWS WS WS

WS WS WS

23

Service Invocation FrameworkInvoke And Consume Web services

Invoke And Consume Service Invoke Web service

Optional Transform-In

External Web services

Reservation Service

Fire Wall

Service Invocation Framework

Optional Transform-Out

Web ServiceRequest

Web ServiceResponse

24

Business Integration Technology Capabilities

25

Leveraging SOA Suite

26

BAM

BUSINESS

BUSINESS

VISIBILITY

VISIBILITYPATTERN

PATTERN

DETECTION

DETECTION

CEPEM

MANAGEMANAGE

MONITOR

MONITOR

POLICYMANAGER

SECURESECURE

JDEV

DESIGNDESIGN

Oracle SOA Platform

ERP MAINFRAME SERVICES EVENTS

ORCHESTRATE

ORCHESTRATEBPEL PROCESS MGRBPEL PROCESS MGR

BUSINESS RULESBUSINESS RULESHUMAN WORKFLOWHUMAN WORKFLOW

INTEGRATE

INTEGRATE

VIRTUALIZE

VIRTUALIZE SERVICE BUSSERVICE BUSDATA INTEGRATORDATA INTEGRATOR

REG/REP

Adapters & B2BPARTNERSDB

27

SOA Enablement Of Oracle E-Business SuiteFor Oracle SOA Suite

Oracle E-Business Suite Adapter

28

Oracle E-Business Suite AdapterIntegration Solution Overview

Oracle SOA Suite

Mediator B2B

BPEL PM BAM

Open Interface Table & Concurrent Programs

XML & eCommerce Gateway

PL/SQL API, Views, Business Events

Inte

grat

ion

Rep

osito

ry

OracleE-Business

SuiteAdapter

29

• Leverages Integration Repository • Secured and Trusted Connection• Functional Security Enabled• Application Context Ready• Transaction Support• Customization Support

Key FeaturesOracle E-Business Suite Adapter

30

Service Oriented ArchitectureOracle E-Business Suite Adapter – Life Cycle

JDeveloperDevelop

BPEL PM / ESBOrchestrate / Event

Oracle EBS SecurityAccess Control

Adapter FrameworkIntegrate:Technology

Enterprise ManagerMonitor & Manage

Integration RepositoryIntegrate: Content

31

Oracle E-BusinessSuite Adapter

Oracle E-Business Suite AdapterIntegration Streams

32

Oracle BPEL PMOracle E-Business Suite Adapter – Design Time

Run TimeDesign Time

33

Oracle Mediator

Design Time

EBS Adapter Service

34

Oracle Service BusOracle E-Business Suite Adapter Service Configuration

35

Design Time

Oracle WebLogic Integration

36

In Tandem With AIA

37

Oracle Application Integration ArchitecturePre-built integrations

38

SOA Enablement Of Oracle E-Business SuiteFor AIA

1. Oracle E-Business Suite Integrated SOA Gateway

2. Oracle E-Business Suite Adapter

39© 2007 Oracle Corporation – Proprietary and Confidential

Order-to-Cash Integration Scenario Application Integration Architecture

Create Order

Configure and

Validate

Invoice/Receive

Pmt

Confirm/ Pack/Ship

Application Integration

Architecture

Siebel CRM Customer

Management

Siebel CRM Customer

Management

EBSOrder

Management

EBSOrder

ManagementPrice/ Check

Availability

E-Business SuitePre-Built Services

Application Business Objects

Extensible Services Framework

EBS Security Model Compliant

AIA Application Agnostic Framework

Plug and Play

40

Business Use Cases

41

Oracle E-Business Suite IntegrationBusiness Use Cases

Sub Contracting

Process

After Sales Service Process

Hire to Retire Process

Procure to Pay Process

Payroll Processing

Process

Order to Invoice Process

42

Create Supplier Ship & Debit Request (SDR) Integrated SOA Gateway Demo

Locate WSDL URL for SDR: in Integration

Repository

Design Integration Developer

Execute the SOAP Request

View SOAP Response

Verify SDR creation in Oracle Trade Management

Trade Management User

Integration AdministratorExecution

Locate SDR API Generate SDR WSDL

Deploy SDR Service

Integration AdministratorInception

Configure the Web Service Client

Pass the Web Service Parameters

43

Order Entry / PO AcknowledgementOracle E-Business Suite Adapter Use Case

Oracle, Non-Oracle and Legacy

Systems – PO Inbound

Mapping / Translation

Verify and Book Sales OrdersPO Acknowledge OutboundPO

Acknowledge xml file

<xml>abc</xml>

Interface Tables For SO Header & Lines

Import Programs Sales

Orders

EBS Apps DB

44

Integration Options

45

Release R12.1.1

Release 11i10CU2 +

Options With Integration Services

• Oracle E-Business Suite Adapter

• Oracle E-Business Suite Integrated SOA Gateway• Oracle E-Business Suite Adapter

46

Oracle EBS ISG vis-à-vis AdapterPositioning

Integrated SOA GatewaySOAP web service

Provided out-of-box from EBS

Provides Interoperability leverage fromany standard web service client

Multi service transaction failures need tobe handled explicitly

Consumption of external web servicesvia native service invocation framework

Integration transactions are monitoredvia SOA monitor

Supports PL/SQL API, BSO, XMLGateway (IN) & Concurrent Program

New product since EBS R12.1.1

E-Business Suite AdapterStandard JCA service

Provided from SOA Suite in mid-tier

Provided via Oracle BPEL ProcessManager or Enterprise Service Bus

Multi-service transaction failures are rolledback via transaction control of JCA framework

Consumption of external web servicesis via Oracle BPEL PM or ESB

Integration transactions are monitoredvia BPEL PM, ESB consoles

Supports PL/SQL API, XML Gateway (IN), Concurrent Program, Open Interface & Views

Support EBS 11iCU2, R12.0.x, R12.1.x

47

Roadmap

48

Roadmap

• Support Flex Fields• Support Group Business Events• Error And Exception Features• Uptake of SOA Governance Suite• Support Custom Concurrent Programs in Oracle E-

Business Suite Adapter

49

Related Sessions

• Speaker Session ID#: S318127Enabling Web Services with Oracle E-Business Suite Integrated SOA Gateway Date: 21-SEP-10, Time: 17:00 - 18:00 Venue: Moscone West L2, Room: 2024

• Hands-On Lab Session ID # S318747 Oracle E-Business Suite Integrated SOA Gateway: Web-Services-Based Integrations Date: 21-SEP-10 , Time: 12:30 - 13:30 Venue: Marriott Marquis, Room: Nob Hill CD

• Dempod At DemogroundsSOA-Based Integration for Oracle E-Business SuiteDate: 20-SEP-10 To 23-SEP-2010Venue: Moscone South - Demogrounds

50

51

52