Using Oracle SOA Suite and Oracle BPEL Process Manager to Integrate and Extend Oracle EBusiness Suit

1
(No Transcript)
2
Using Oracle SOA Suite and Oracle BPEL Process
Manager to Integrate and Extend Oracle E-Business
Suite Applications
Richard Esposito Nishit Rao Vebhhav Singh
Senior Applications Manager Group Product
Manager Principal Sales Consultant
Forsythe Technology, Inc. Oracle Fusion
Middleware Oracle
3
Program Agenda

• Fusion Middleware Overview
• Fusion Apps and Fusion Middleware
• SOA Suite Components - BPEL
• SOA based EBS Integration using BPEL
• Forsythe Customer Case Study
• Q A

4
Oracle Fusion Middleware
5
Oracle Fusion MiddlewareThe Worlds Best
Middleware Suite - Gartner MQs

• Application Platform Suites
• Development Tools
• Application Server
• Web Services Platform
• Enterprise Portal
• Enterprise Content Mgmt.
• Enterprise Records Mgmt.
• Enterprise Service Bus
• Business Integration
• Business Process Mgmt.
• Business Intelligence
• Corporate Performance Mgmt.
• Access Management
• Identity Provisioning
• Web Services Management
• Data Integration

6
Oracle Fusion MiddlewareThe Worlds Best
Middleware Suite
Global Customers Business Week 1000 Fortune 50 G
lobal Fortune 50 US Partners ISVs SIs VARsPa
tents
Industry Awards
77,000 873 39 43 7,800 4,780 38,5004,500
227
145
7

Oracle SOA Platform
8
Oracle SOA Evolution
Portlet Web Services (WSRP)
Stellent Doc Mgmt, Image Proc
WSDL, UDDI, Development Tools, Expanded Web
Services Platform
Web Services Manager, BAM
BPASuite
Tangosol

2001
2002
2004
2003
2006
2005
2007
2008
WebLogic Server ALSB Repository ALBPM Event Se
rver
Web Services Support
J2EE 1.4 Standard Web Services
ServiceRegistry
OracleDataIntegrator
BPEL Process Manager
9
Best-in-Class Awards

• SOA World Magazine
• Readers Choice Awards 2007
• Winner in 15 of 20 categories, including
• Best SOA/Web Services Platform
• Best BPM Engine
• Best Integrated Services Environment
• Best Security Solution

• Winner, SD Times 100
• Business Process Management
• SOA Integration

? ? ? ? Oracle BPEL Process Manager
? ? ? ? Oracle Business Activity Monitoring

• Oracle SOA Suite Excellent
• Highest Rating in SOA Category
• Hands down, the most comprehensive and easy to
  use product on the market today

• Oracle BPEL Process Manager
• Winner, Web Services Journal Readers Choice
  Award
  
• World class product

Winner, Best Business Process Management System
Winner, ebizQ Buyers Choice Award
Enterprise Information Integration
Oracle SOA Suite, Winner, Tech Innovator 2007
Business Software Enterprise Applications and
Infrastructure
10
Continuing to Win Awards in 2008
http//www.infoworld.com/slideshow/2008/01/144-200
8_technology-3.html
11
11
12
Oracle SOA and Event Technologies
Coherence Cache J2EE Application Server(Oracle A
S, WebLogic, WebSphere, JBoss)
Messaging
JRockit VM RT
13
The Oracle BPEL Process Manager

• A standards based workflow for human and IT tasks

• Native BPEL Standard
• Adapters to E-Business Suite
• Automate Enterprise processes replacing manual
  tasks.
  
• Runs on OracleAS, WebLogic, JBoss and WebSphere
• Get up and running in less than 15 minutes!

BPEL
Workflow Services
BPEL Process Manager
Integrated BPM Services
Metadata Repository (Dehydration)
Workflow
Decision Service
Sensors
Core BPEL Engine
Process Console
MANAGE
J2EE Application Server (Oracle AS, WebLogic, JBo
ss, WebSphere)
14
Realize the Full Benefits of SOAWith an
Enterprise-Class Service Bus

• Service Mediation Management
• Location Transparency
• Service Virtualization
• Configuration
• Any to Any Protocol, Payload
• Policy Enforcement
• High Availability Scale

BPM
Portal
B2B BPM
Oracle Service Bus
Adapters
Presentation Services
Service Repository
Integration Services
15
Oracle Business Activity Monitoring
3
Oracle BAM
BPEL Process Manager
ESB
.
Siebel CRM
E-Business Suite
JD Edwards Enterprise One
PeopleSoft Enterprise
Repository
Application Integration Architecture can be
plugged into
Business Activity Monitoring
16
(No Transcript)
17
Order Management
Call Center
Customer
Create Sales with Approval

• Create Purchase Order
• Update Status

Customer
Delivery Confirmation

• Create Invoice
• Update Status
• Create Shipment

Pickup Notify
Fulfillment
3PL Shipper
18
Oracle SOA Governance Solution

• Enterprise Repository
• Impact / dependency analysis
• Compliance Reporting
• Service reuse
• Lifecycle management

SOA Governance Suite
Enterprise Repository

• Web Services Manager
• Policy-oriented security and access control

EM SOA Management Pack
Web Services Manager
Metadata Exchange

• SOA Management Pack
• Management of production processes and services
• Production metrics
• SLA monitoring

Service Registry

• Service Registry
• Runtime service discovery

UDDI Integration
18
19

Service Oriented Architecturefor EBS
20
Service Oriented Architecture
Integration Repository
Register
Find
Service Contract
Service Consumer
E-Business Suite Adapter
Service
Client
21
Integration RepositorySingle Source of Truth

• PL/SQL APIs (2650)
• Open Interface Tables (147)
• Concurrent Programs (214)
• XML Gateway (170)
• eCommerce Gateway (24)
• Interface Views
• Java
• Web Service

22
Oracle E-Business Suite Adapter Schematic
Architecture
23
Service Enabling PL / SQL APIs
24
PL / SQL APIsExample
25
PL/SQL APIs Architecture
Data
26
Salient FeaturesOracle 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
• Security
• Application Context, Dynamic setting of
  Application Context
  
• Apps Password No sharing required with FMW
• Role Based Access Control (RBAC)
• Exception and Error Handling Support
• Faults for Native E-Business Integration
  components
  
• XA Support

27

EBS Adapter Demo
28
Order-To-CashBusiness Visibility into End-To-End
Order Process

• Oracle BPEL PM
• Multiple Order Capture Systems

• Oracle BPEL PM
• Integrate with Order Management

29
Procure-To-Pay Business Visibility into
End-To-End Order Process
30

Forsythe Case Study
31

Who is Forsythe?
32
Who is Forsythe?

• Proven IT infrastructure integrator
• 37 years of providing data center solutions to
  enable innovation, reduce cost and manage
  risk
  
• Strong tradition as a trusted, independent
  advisor
  
• North American base with international reach
• 800 employees
• 44 offices in the U.S.
• Canada (4 offices) and UK
• Support 36 of Fortune 100

33
Forsythe Vision
Forsythe is a leading, independent provider of
expert technology infrastructure solutions,
and is focused on helping customers optimize
their technology investment.
34
Forsythes Growth is Through Our Clients Growth
34
Forsythe proprietary
July 26, 2009
35
Recent Client Engagement Results

• 93M storage cost savings for a business unit of
  one of the largest US banks.
  
• 22.6M server consolidation savings over three
  years for a client with global database
  complexity.
  
• 6.5M storage savings annually for a large
  insurance company.
  
• 2.5M annual savings strategy to address 200
  year-over-year storage growth, for a financial
  institution.
  
• 1M savings per month for a 10,000 handset IPT
  deployment at a national risk services and
  staffing consulting company.
  
• 20M savings annually by optimizing and
  consolidating maintenance contracts at a 50B
  pharmaceutical company.

35
Forsythe proprietary
July 26, 2009
36
Forsythe Partners
37

Case Study
38
Business Problem

• Back-office Procurement volume was dramatically
  increasing
  
• Workloads were increasing and the number of data
  entry errors were increasing
  
• Order error tracking was becoming more difficult
  due to increasing volumes
  

Drive to decrease costs and improve productivity
39
Business Solution

• Create B2B connection to a top vendor to achieve
  back-office efficiencies
  
• Procurement Area
• Transactions
• PO
• PO Acknowledgement
• Order Status
• Ship Notice
• Business Benefits
• Automated population of data
• Faster problem resolution
• Decreased time to create Customer Invoices
• More timely order status information

40
Challenges/Capabilities/ValueConcept to
DesignPLM
Oracle Differentiator
CHALLENGES
CAPABILITIES
VALUE

• Perform a Configuration Check using Web services
  calls
  
• Submit Purchase Orders to top vendor as a
  RosettaNet PIP3A4
  
• Receive PO Acknowledgements as a RosettaNet
  3A4-C
  
• Receive PO Status as a RosettaNet 3A6
• Receive Ship Notice as a RosettaNet 3B2
• Integrate BPEL with Workflow
• Connect BPEL seamlessly with Oracle EBS

• Improve order management efficiency
• Improve visibility to order shipments commit
  dates
  
• Improve customer service and logistics
  efficiencies
  

• Reduce effort spent submitting POs to top vendor
• Improve speed in identifying PO errors
• Improve ability in determining cause of PO
  errors
  
• Decrease time to bill customer

41
Specifications

• Oracle Environment
• BPEL Development
• JDeveloper v10.1.3.3
• Application Server
• BPEL 10.1.2.0.2
• B2B 10.1.3.0.1
• DB 10.1.5
• EBS 11.5.10.2
• Connectivity
• RNIF 2.0
• SSL 1024 bit Certificates
• Transactions
• RosettaNet Standard
• 3A4 Purchase Order
• 3A4c PO Acknowledgement
• 3A6 Order Status
• 3B2 Ship Notice
• SOAP Web Services Calls
• 5 separate calls

42
Process Flow
Vendor
Web Services Calls
Configuration System
BPEL/B2B
B2B Server
PIP3A4 - Submit
Oracle eBusiness
Application System
PIP3A4 - Confirm
PIP3A6
Oracle
Database
PIP3B2
Buyer
43
Logical Architecture
44
Process
45
Error handling

• Exceptions
• Error types
• System Error
• Email goes to the Service Desk
• User Error
• Workflow Notification goes to the user
• Exception around the entire process, and in
  sub-processes
  
• Process - Configuration Check
• Known error
• If fails, then workflow notification generated to
  the user
  

46
Workflow

47
Lessons Learned

• Leverage BPEL Adapters
• Oracle Application Adapter
• When you need to change data, use the OAA with
  PL/SQL and you are able to use a trace
  
• Database Adapter
• Direct table access Selects
• XML Gateway
• Moving away from it
• Use BPEL for linking B2B into the Users existing
  process
  
• Tuning
• Timeout Parameters 75 sec
• Audit Trail Logging Level Production,
  Development, Minimal
  
• Mapping
• More complex mapping is simpler via xslt/xpath
  syntax rather than the visuals
  
• Leverage Workflow Worklists
• Instead of Emails
• What the User is familiar with

48
(No Transcript)