using oracle soa suite 11g to integrate with peoplesoft 9.1

Using Oracle SOA Suite 11g to Integrate with PeopleSoft 9.1

Leon Swan | Integration Architect | Veolia Environmental Services

Brad Bukacek | Team Lead | Fishbowl Solutions

Veolia’s Global Business

2

The world leaderfor water services

$15.9 billion

WATER

The global benchmarkfor waste managementand resource recovery

$12.0 billion

ENVIRONMENTAL SERVICES

A solutions providerfor energy optimization$10.1 billion

ENERGY

2

The only company in the world able to cover the entire range of environmental solutions$38.8 billion in global revenue in 2012

Veolia Environmental Services Worldwide

3

As the only global operator to provide a complete range of waste management solutions, Veolia Environmental Services managed nearly 60 million tons of waste for over 800,000 worldwide customers in 2012.

4

With 220,000 employees in 48 countries*

11%Asia-Pacific

9%North

America

66%Europe

7%Africa &

Middle East

7%South

America

*with more than €5M in capital employed, excluding Veolia Transdev employees and revenues currently under divestment

VESNA Service Locations Today

5

6

Mix of Business by Service Area

Field Services56%

Electronics Recycling9%

Alaron1%

Incineration20%

Reclaim/Treatment14%

Hazardous & Regulated Waste (Technical Solutions) 2012

Vacuum26%

Blasting15%

Other Services*12%

Waste Treatment5%

Chemical Cleaning5%

Tank Cleaning5%

Sewer Cleaning5%

Oil Reclamation5%

Transportation4%

Separations4%

Auto4%

Legacy Local Services4%

Emergency Response3%

Industrial Services 2012

*Other, plus general cleaning and mechanical

About Fishbowl Solutions

Experience• Over 700 projects since founding in 1999• Oracle “Gold” Partner• Oracle “Public Sector Pillar Partner”

Expertise• Portals and Content Management• Enterprise Information Management• Business Process Automation

Customer Successes• Across verticals

Award Winning• Forrester Groundswell Award - Mobile App• Oracle Excellence Award• Enterprise 2.0 Blazer• 2009 ECM Architect of the Year

Leading WebCenter Innovations

WebCenter Mobile WebCenter Portals & Intranets

Google Search Integration 11g Upgrades

Fishbowl Consulting Services

+ WebCenter Content+ Document Management

+ Digital Asset Management

+ Image & Process Management

+ Forms Recognition

+ WebCenter Portal+ Employee Intranets

+ Vendor or Partner Extranets

+ Customer Portal

+ ADF \ SOA+ BPM (business process management)+ ERP Integrations+ Installations, Configuration, Performance Tuning, Solution Design,

Development, Implementation

+Records Management

+Web Content Management

+Document Capture

+Content Consolidation

10

11

Operation Phoenix Objectives

Implement a fully integrated ESA solutionEliminate redundant manual and paper processes to increase and drive efficiencies and cost savingsAchieve consistency in business functions across the corporation where possible and practical

Provide financial controls inherent in the PeopleSoft Financials Suite to facilitate Veolia Sarbanes Oxley requirements

Establish an application architecture that provides VESNA a framework for future acquisitions and growth

Limit customizations to those that will provide a competitive edge for Veolia. Strive for a “vanilla” implementation

Enhance data accuracy by reducing the number of systems and databases that roll into Corporate reporting

Reduce the cost of upgrading and maintaining multiple systems and databases by adopting standard Oracle/PeopleSoft applications

“Right time” access to accurate and reliable operational & financial information (planning, programming, budgeting, accounting, and cost information) in support of financial accountability

12

Application Integration

FIN / ESA - 8.4

HCM - 8.3

eSD/dSD

13

What’s Changing?

• Estimating and Bidding

• Paper -> Hard Dollar

• Project Costing

• PeopleSoft 8.4 -> PeopleSoft 9.1

• Contracts

• PeopleSoft 8.4 -> PeopleSoft 9.1

• Accounts Receivable

• PeopleSoft 8.4 -> PeopleSoft 9.1

• Billing

• PeopleSoft 8.4 -> PeopleSoft 9.1

• Service Receipts

• Paper -> PeopleSoft 9.1 e-SD and Tablets d-SD

• Inventory

• Excel/Peachtree/Other -> PeopleSoft 9.1

14

Application Flowchart

15

Hard Dollar – Main Topics

Provides an estimate/proposal that also gives costs/margins.

Greatly streamlines the approval process.

Contract/resource rates are loaded into the system.

Each estimate is also a template.

Can be exported into Excel for use in actual proposal.

Generates very beneficial reports.

Can be utilized with Microsoft Project or Primavera to develop schedules.

16

PeopleSoft – Main Topics

Project Costing.

Visibility into Project at Project, Program, or Contract level Issue Tracking

Billing/Accounts Receivable.

Ability to bill milestones on a date basis; allowing for automated billing worksheet generation (shared with Contracts)

Ability to view/print Pro-Forma Inventory.

Automatic creation of Material Stock Request through e-SD integration

Increase inventory accuracy through counting events

17

Electronic Source Document (e-SD)

Business Process Change

System generated eSD and dSD’s Vs. blank SR’s Only contract specific L.E.M. available on eSD and dSD Connected, Disconnected, and Dispatch versions Scalable from day to day to T/A’s and Outages activities Integration of internal and external customizable KPI’s for PMT

reporting

Benefits

Better planning of resources and equipment Less tracking down of open SRs More timely billing to our customers Reduce our Days Sales Outstanding (DSO) Improve our Revenue Recognition and Reporting

18

The Case for SOA

SOA as a Veolia Integration Solution

Integration with multiple sources/protocols Desire for single, composite application “look and feel” from

multiple system integration

SOA as a Phoenix Solution

Because it was there! Avoid additional PrimaVera application

Use existing PeopleSoft Project functionality Provide Hard Dollar to PeopleSoft interface

19

Infrastructure

4 Environments

Development, Test, UAT, and Production Single Node Oracle Linux on Oracle VM Oracle 11g RAC Database

Build Server Subversion Hudson

20

Applications

21

Use Cases

Integration with Hard Dollar

Hard Dollar Bid PeopleSoft Contract and Project Creates Project and Activities Stages Budget Details Creates Contract Header and Rates Command & Control links activities and rates to

contract Reduces time to create PeopleSoft Contract

PeopleSoft Customers Hard Dollar Address Book PeopleSoft Contract Rates Hard Dollar Library

Enables bids to be generated from existing contracts

Reduces time to complete estimate

22

Integration Design Goals

Consistency

Flexible

Standards-Based

Best Practice Integration with PeopleSoft

Reusable Services

23

Methodology

Loosely Based off Oracle AIA Methodology

Broken down into the following types of services:

Enterprise Business Services (EBS)Application Business Connector Services (ABCS)Enterprise Business Flows (EBF)Enterprise Business Objects

24

Enterprise Business Services

Well Defined Interfaces

CRUD Operations

CreateReadUpdateDelete

25

Application Business Connector Services

Application Extensions for PeopleSoft & Hard Dollar

BPEL-Based Services

Transformations, Security, Validations

Error Handling

26

Enterprise Business Flows

Implement business activity String activities together from application(s) No human intervention needed Used in project bid from Hard Dollar to PeopleSoft

27

Enterprise Business Objects

Canonical Models Leveraged OAGIS

XML schemas ERP, Supply Chain and etc.

Custom Enterprise Business Objects Contracts, Rates

28

Why This Approach?

Minimize changes, less maintenance Flexibility Reusable Services

Not only for business services But, for services like error handling and notifications

29

Hard Dollar Bid PeopleSoft Contract / Project

Field Agent Finalized Bid Web Service call to SOA Complex Hard Dollar schema Front-end processing

6 Enterprise Business Services Enterprise Business Flow Combination of sync & async services

Key Issues: Hard Dollar application did NO validation Duplicate bids

30

PeopleSoft Customers Hard Dollar Address Book

Event Table Triggers on key customer tables DB adapter to poll event table Retrieved customer number

PeopleSoft Integration Retrieved customer details

Processed back to Hard Dollar via Web Services Activated/Inactivated Customers Updated Customer Info & Address Information

31

PeopleSoft Contract Rates Hard Dollar Library

PeopleSoft App Engine Queried Component Interfaces to get changes HTTP Post call to SOA

SOA Front-end service retrieved using HTTP Post adapter Very large data sets Complex XSLT

Key Issues: Hard Dollar is single threaded application Throttling was neccessary

32

Throttling

Hard Dollar was single-threaded application

Needed to throttle because changes came in batches

Create singleton BPEL process Read off JMS Queue Once finished, picked up next message

Wasn’t ideal, but worked!

33

Integration Points

PeopleSoft Integration Broker Web Services HTTP Post

Hard Dollar .NET Web Services

34

Message Handling

Included: Fault Handling Success Messages

Event Delivery Network (EDN) Java Customizations Email Notifications

35

Security

Oracle Web Services Manager WS-Security: UsernameToken All services used WS-Security

PeopleSoft Security User ID: VZ_SOA_USER Role: VZ_SOA_PC Permission List: VZ_SOA_PC

36

Testing

Resources: SOAPUI Fusion Middleware Control

End-user testing with Applications

37

PeopleSoft Integration

Use Existing Services/CIs When Available Create CI Based Services When Necessary Avoid Direct Database Interaction Component Interfaces:

Web Services:

PROJECT_ACTIVITYPROJECT_GENERALCA_HDR_CIPROJECT_STATUS1

VZ_PC_RATEVZ_PC_RATE_CONS VZ_PC_RATE_INVVZ_PGM_RESOURCE

CI_PROJECT_ACTIVITYCI_PROJECT_GENERAL

VZ_CI_CA_HDR_CI VZ_CI_PROJECT_STATUS1VZ_CI_VZ_PC_RATEVZ_CI_VZ_PC_RATE_CONSVZ_CI_VZ_PC_RATE_INVVZ_CI_VZ_PGM_RESOURCE

38

PeopleSoft Development Tips

Validate Service With SOAP UI “Common” Error Interpretation

User Password required for Service Operation CI_PROJECT_GENERAL_C. (158,535)

Set SOAP-UI WSS-Password Type = Password Text

Invalid value -- press the prompt button or hyperlink for a list of valid values (15,11)

SOA user lacks authorization for action/valuesNote: System defaults to application server User ID with related Permission List/Business Unit security.

Row already exists with the specified keys

May be differences between online & CI behavior. May need to explicitly code some values.

39

Project Management Test early & often Know your data! Understand your environment Large data sets

Resource Limitations Requirements not met Sell of part of company

40

Final Rumblings

Deployment Architecture Other things to consider:

Automation System Administration

Project Postponed

41

Questions

42

• Network with 5,000+ database and application professionals

• 5 days of in-depth education built by users, for users

• Complimentary Pre-Conference Workshops for IOUG registrants

April 7 – 11, 2014The Venetian Resort,

Las Vegas, NV

Attend for free!IOUG’s Call for Speakers is now opencollaborate14.ioug.org/call-for-speakers

43

CommunitiesMaximum Availability Architecture with Oracle’s Larry Carpenter and Joe MeeksOctober 15: Milwaukee, WIOctober 16: Rochester, NY

Performance and Internals with Craig Shallahamer November 6: Chicago, ILNovember 8: Atlanta, GA

Get more information at www.ioug.org/masterclass or visit the IOUG kiosk in Moscone West, 2nd floor

IOUG Master Class Series ReturnsComing soon to a city near you!

One Day Interactive Training Events to meet your educational needs

44

Win a Free Registration to COLLABORATE 14!

Stop by the IOUG kiosk in the User Group Pavilion in Moscone West, 2nd floor, to pick up a lucky poker chip and see if you are a winner of a free registration to

COLLABORATE 14 in Las Vegas!

45

Contact Us

Leon Swan | Integration Architect

Veolia Environmental Services | Milwaukee, WI

leon.swan@veoliaes.com

Brad Bukacek | Sr. Software Consultant/Team Lead

Fishbowl Solutions | Minneapolis, MN

bbukacek@fishbowlsolutions.com

@bbukacek