A Working Heterogeneous Order To Cash System Using Oracle’s Fusion Middleware

1. A Working Heterogeneous Order To Cash System Using Oracle’s Fusion Middleware Georgia Oracle User Conference 21 Mar 2006

2. Agenda • Case Overview • Current Process • Requirement • Solution using BPEL • Modeling the process in BPEL • Setting up the services

3. Current Order To Cash System • Quotes and Orders flow through multiple Systems • A pre processor based on Web Methods is used

4. Requirements from the Order To Cash System • 1.     Quotes and Orders are passed by Storefront and Quote / Order has to be created online • 2.     Order Response will be sent for all transactions received • 3.     Part numbers to be validated against the Part Master • 4.     Actual Turbine Serial Number must be passed. • 5.     Price needs to be obtained from Oracle ERP • 6.     Ship to, Bill to and other information needs to be validated in Oracle

5. Two Possible Approaches BPEL EAI • Easy mapping to many existing database objects • Extention of an existing platform • New Technology • Acquisition cost • Requires some custom development • Introduction of a new footprint • Proven Technology • Acquisition cost

6. Modeling The Process • Process broken into three components • Item Validation • Get Price • Create Order • Each component setup as a service • Two Partners linked to each other • Asynchronous mode of data transfer

7. Item Validation Service • The objective of item validation is to ensure that the part number entered exists in the Oracle Item

8. Item Validation Service • Port Type Definition • Two portTypes are defined, each with a one-way operation: one to initiate the asynchronous process and one for the process to call back the client with the asynchronous response

9. Item Validation Service • Element • Define the elements that need to be passed from the store front to the other application • Include both the Request Element and the Response Element

10. Item Validation Service • Create Partner Link • Partnerlinks represent services that BPEL processes can call or interact with. • Include both the Source and the Destination Applications

11. Item Validation Service • Create Partner Link • Map to stored database procedure which has to be called

12. Item Validation Service • Data Manipulation • Map to stored database procedure which has to be called • use XPath and the BPEL <assign> activity to perform simple data manipulation to initialize the input variable you are passing to the

13. Item Validation Service • Compile the Process

14. Price Request Service • The objective of price request is to ensure that the correct price for the part is obtained from Oracle

15. Price Request Service • Port Type Definition • Define Elements • Define Partner Link • Map Attributes

16. Price Request Service • Compile the process

17. Create Order Service • The objective of Create Order Service is to enable the creation of the order in the ERP • Port Type Definition • Define Elements • Define Partner Link

18. Create Order Service • Map Attributes • XML file used to capture all order attributes from storefront to ERP • Attributes mapped from XML fragment to Process Order API

19. Create Order Service • Compile the process

20. Genpact Software Services “Deploy & Manage Global Enterprise Solutions” We… Highly skilled team with depth and breadth of ‘industry’, ‘process’, and ‘technology’ expertise Highly Evolved Portfolio of Services Ensuring Business Benefits at all Levels of Engagement

21. Representative Key Programs Global IT Program Management Global Enterprise Solution Deployment Application Management Services GE Advanced Materials • Oracle Process Mfg. • 6 Regions - 11 sites • 65% Component Rationalization • GCOA rollout • 2+ year rapid deployment • ERP PMO • PMO for OPM deployment • 19 legal entities • Driving 70% Reuse • 80% Offshore Leverage • 25+ Processes Standardized • Diverse Applications • 650+ Applications • 12000 users • 40+ Technologies • 3 Poles & 56 sites • 24x7 Support • 5000+ Cases per month GE Commercial Finance • Hyperion Engagements • Global RTS & Implementations – 6 ComFin SBUs • Over 70% Offshore Leverage • Executed over 90% programs across vertical • Savings in excess of 80% of FP&A in planning & reporting efforts • Siebel Support • Global RTS – Across 4 poles (US< Europe, APAC, ANZ) • Over 90% Offshore Leverage • Over 5000 users supported – 24x7 • Process Sigma – 4.2 • Support four different instances across CEF, VFS, EEF and CFS • Oracle Lease Mgmt • Systems Rationalization - Systems down -15  1 • Complete life-cycle of a lease in single system; Fragmentation  60%+ GE Energy • Supply Chain & Financials • 20+ Rapid Deployments • 170 Third Party Apps Interfacing • 300+ Customizations • 70% Offshore Leverage • 100% Digitized technical delivery • ERP CoE • ERP for 15 + P&L’s • Standardizing 23 modules of Oracle ERP • $12+MM Program Benefits • Execution of 16+ Programs • 60+% Offshore Leverage • Global ERP Support • 4000+ users, 2200 cases pm • 98.9% SLA adherence • 15+% cost reduction y-o-y • 11 P&L’s, 6 Instances • 750+ customizations • 88% Offshore leverage

22. Contact Information • Kirit Goyal • Kirit.Goyal@genpact.com • 404 513 1378 www.genpact.com