AIA Integration with Ebusiness Suite R12.1.3

Author Name: Thiruselvam V Nov 9, 2013

ORCHESTRATE. ACCELERATE. LIBERATE.

About the Speaker Thiruselvam V, DBA Manager, KBACE Technologies Private Ltd

Industry Experience

Discrete Manufacturing, Process Manufacturing, Health Care, Telecom, Education, Financial Services and Pharmaceutical © KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Has over 20 years of experience in IT and lead teams in various roles with overall responsibility. Experience includes people management, consulting services, practice management, project management and service delivery engagement, customer support relationship, operations and global blended delivery methodologies. Technical experience includes major areas in Ebusiness Suite Implementation, Ebusiness Suite Production Support 24 x7 environments, Oracle Applications and Database Upgrades of various release, Platform Migration Projects, Fusion Middleware, Non ERP areas includes such as Demantra, Middleware, Agile and Siebel.

Agenda    

Enterprise Challenges Traditional Approach Need of AIA Introduction AIA  AIA Integration Values

         

AIA Architecture How AIA is Delivered Installation Requirements for AIA PIP A Generic Flow Key Business Requirements AIA User Process Flow Business Scenarios Benefits of Solution Other integrations Q&A

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Division 2

Division 1

Sales

Operations

CRM

Accounting

Mfg

Sales

CRM

Operations Accounting

Mfg Partner System

Order Mgmt

Data

Applications

Depts./Users

Enterprise Challenge

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Financials

Order Mgmt

Financials

Traditional Approach Traditional approach wherein the data integrations across disparate systems are point-to-point, rigid, and costly to maintain

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

5

Need for AIA 1

Most organizations are saddled with a very heterogeneous systems

2

High levels of complexity in executing business processes

3

High operating costs

4

AIA drastically reduce the TCO

5

Approx. 70% cost goes on maintenance and only 30% for new capabilities

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

6

Introduction AIA AIA • E-Business Suite customers make use of AIA PIP integration for their various business integration needs • Business case that requires Application to Application integration between two different flavours would employ Application Integration Architecture • AIA PIP provides an open, standards-based framework for creating cross-application business processes that support the way organization run their business today • Offers pre-built integrations, allowing for rapid implementation of mission critical business processes • Business processes that require custom integration solutions can also be achieved

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

7

Transformations Often Resemble “Science Projects” Division 1

Division 2

Technology Shortcoming Sales

Operations

Business Impact

Accounting

Sales

Operations

Heterogeneous Systems CRM

Mfg

Accounting

Complexity, High Cost CRM

Mfg Partner

Proprietary Technologies Order Mgmt

Financials

Point-to-Point Integration

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Closed, Difficult to Partner System Order Mgmt

Financials

Rigidity, Slow to Adapt

AIA Integration Value Oracle increases value with pre-packaged & sustainable integrations

Application Integration Architecture © KBACE Technologies, Inc. 1998-2013 All Rights Reserved

9

AIA Abstraction Layer Concept Optimize Offer

Siebel CRM

Forecast Demand

Capture Order

Pick, Pack, Ship

Billing

Enterprise Service Customer Sales Order Bus

Deduction & Settlement

Invoice…

E-Business Suite

BPEL Process Manager AIA Enterprise Business Objects & Services Layer Data Integration SAP

Custom App

Composite UI

JMS or WSIF API or Web Service

•

Common objects, standardized business services

•

Re-usable, loosely coupled services to support one to many

•

Leverage AIA UI service SDK to build composite tasks

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Application Business Connector Service API or Web Service

How AIA Is Delivered Oracle Application Integration Architecture Process Integration Packs • Loosely coupled composite business processes

Foundation Packs • Comprehensive business process composition framework

Direct Integration s

Direct Integrations Manage. Pre-built integrations to support data flows between systems Process Integration Packs Optimize. Pre-built composite business processes across enterprise Applications Foundation Packs

Supports • Modernizing apps • Consolidating systems / MDM • Improving/Extending processes

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Standardize. Common Object and Shared Service Library with supporting SOA programming model and best practice implementation methods

Installation Requirements for AIA PIP Installation Requirements • Oracle Lead to Order Integration Pack for Oracle CRM On-Demand and Oracle Business Suite was implemented • Following installation steps are mandatory for the intended functionality to work  Oracle E-Business Suite Install 12.1.3

 Oracle WebLogic Server 10.3.5  Oracle SOA Suite 11.1.1.5  Oracle AIA Foundation pack Install 3.1  Oracle AIA PIP Integration

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

12

A Generic Flow (Lead to Order) Lead, Account, Contact and Opportunity Management

Customer (Accounts/ Contacts)

Product

Opportunity

One-Way Sync EBS>OD

Bi-Dir Sync EBS OD

OpptytoQuote

Flow Account Receivables

Opptyto-Order

Yes

HTML Quote?

Opptyto-Quote

No

QM Order

OM Quote

HTML Quote

Purchasing Indirect Integration

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Legend CRM On Demand Oracle E- Business Suite Shared Data 13

Key Business Requirements Business Requirements E- Business Suite needs to extend CRM functionality to sales teams Ensure high levels of data integrity and governance over key business processes across front and back offices Synchronization of customer and product data and integrated • Opportunity-to-quote or • Opportunity-to-order management

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

14

AIA User Process Flow User logs in to CRM OnDemand Opportunity appears in Ebusiness Suite

Create an opportunity Siebel CRM OnDemand

EBusiness Suite R12.1.3

Fusion

Middleware

End User enters authenticati on

Click on view Ebusiness Suite link It pops up Ebusiness Suite page

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

15

Business Scenarios (Oracle Lead to Order)  Master data flow batch load customer data

Step 1

Batch Load Account Info from Ebiz to CRMOD

Step 2

 Transactional flow (Create, Update and Synchronize)

Create Account Info

Batch Load Account Info from Ebiz to CRMOD

Upgrade Account Info

Bidirectional Flow

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Synchronize Account Info

Can be performed in Ebiz or CRMOD

16

Business Scenarios

(Contd…)

 Master data flow batch load product data

Step 2

Step 1

 Transactional flow (Create, Update and Synchronize)

Batch Load Product Info from Ebiz to CRMOD

Create Product Info

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

Performed from Ebiz to CRMOD

Upgrade Product Info

Synchronize Product Info

Changes made to product in CRMOD are not synchronized with Ebiz

Unidirectional flow from Ebiz or CRMOD

17

Business Scenarios

(Contd…)

 Generate Sales Quotes or Sales Orders in Ebusiness Suite Generate Sales Order/Sales Quote based on Sales Opportunities’ in CRMOD

Enables to create Sales Quote based on CRM HTML Quoting module or OM Sales order based

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

18

Benefits

Benefits of Solution

•

Ability to generate sales quotes or sales orders in Oracle E-Business Suite

•

This is achieved based on sales opportunities' in the CRM On Demand system

•

Provides foundation for the development of more;  Complete lead-to-order integrations  Reduced order errors through the elimination of manual front office to back office transformations

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

19

Other Integration in AIA • Agile PLM integration with E- Business Suite • Key functionalities  Manufacturing release of new product definition and product launch  Change management of previously launched products  Bidirectional synchronization of engineering change status and material attribute info from E- Business Suite to Agile PLM

 Monitoring and control of the change processing and validation

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

20

Question?

© KBACE Technologies, Inc. 1998-2013 All Rights Reserved

21