EPM ERP Cloud and OnPremise All Integration Options

EPM, ERP, Cloud, and On-Premise All Integration Options Explained (CON 6754) Kumaresh Sankar Senior Director, Oracle EPM Product Development James Clark Group Manager of FP&A, Sims Metal Management Limited October 2, 2017 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal

Safe Harbor Statement 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. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 3

Program Agenda 1 Integration Overview 2 Cloud Integration 3 Hybrid Integration 4 Customer Story – Sims Metal Management 5 Q&A Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 4

Integration Overview Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 5

Cloud and Hybrid Integration Overview Data Warehouse Data Mart Other Systems EPM Cloud File Excel Oracle EBS, People. Soft, JDE, Fusion APPs, SAP R/3 As customers incrementally migrate to the cloud, integration between on-premise, EPM Cloud and other branded cloud services becomes critical Oracle and Non-Oracle Cloud Copyright 2014 Oracle its affiliates. All rights reserved. Copyright © 2017, ©Oracle and/or its affiliates. All rights reserved. | | 6

EPM Integration Solutions Data Management for the Cloud FDMEE for On-Premise & Hybrid • Open Source - File • Packaged Integration – Oracle Cloud ERP, HCM, Net. Suite • Integration between Oracle EPM Cloud Services • Open Source - File, Open Interface, Universal data Adpater • Packaged Integration – EBS, Peoplesoft, JDE, SAP • Integration with Oracle Cloud • Extensible and Customizable Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 7

EPM Cloud Integration Use Cases Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 8

Generate Data in Pre-defined format from Source Provided by each EPM Cloud Service • • Specific format for each EPM cloud service Import/Export Data and Metadata Execute manually, schedule with UI or EPMAutomate/REST Drill-through not supported Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Generate data in Source format Transform and load from any source use Data Management • Any format • Delimited, fixed width, multi-column, text, etc. • Map data to transform from source • Robust features provided to manage the data loading workflow process • Drill-through to source possible if HTTP: // landing page available • Use log files available from Process Details to investigate issues Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle GL Cloud to EPM Pre-built Integration • • • Includes GL Balances and Budgetary Control Write back as Standard Budget or Control Budget Drill-through automatically configured Oracle GL Cloud also available in Hybrid mode with FDMEE User/Password and WSDL for connection setup Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle HCM Cloud to EPM Pre-built Integration • Predefined content for EPBCS – Workforce Planning • Standard HCM Extract • Pre-built mapping in Data Management • Data only – user responsible for metadata • Supports WFP and SWFP • Customize pre-built integration if needed • Framework for custom user defined HCM extracts Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Netsuite to EPM Cloud Pre-built Integration • Netsuite “Saved Search” available as integration source • Any saved search - GL, AR, AP, etc. • Production and sandbox environments • Drill Through Supported • Available now • Netsuite early adopter approval required Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Integrate data between EPM Cloud Services Using Data Management • Synch data between EPM Cloud service instances • Supported sources – PBCS, EPBCS, FCCS, PCMCS, TRCS • Setup consistent with loading from a file • Pick source, target, mapping, data load rule • Drill available to Data Management • Direct page links for PBCS and EPBCS • Form or Dashboard with POV Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Automate integration using EPM Automate Standalone Utility installed in on-premise • Command line access for EPM Cloud applications • Available for Windows and Linux • Easily schedule. bat or. sh files • Integrate with other scripts for end-to-end processes • See documentation for full list of commands Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Data Management and EPM Cloud Services Release Highlights – October 2017 Data Management Included? On-Prem to Cloud Hybrid Support? Export from cloud or source for pod to pod? Load Text and Multi -Col Load Journals Integrate with Fusion GL Cloud PBCS Yes Yes NA Yes EPBCS Yes Yes NA Yes FCCS Yes Yes Yes ARCS Yes TBD NA NA Yes PCMCS Yes Yes NA Yes TRCS (Tax) Yes TBD Yes Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential

Hybrid Integration Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 17

Hybrid Implementation Support • Financial Data Quality Management, Enterprise Edition (FDMEE) – Recommended approach for Hybrid Integration • Easily integrate cloud and on -premise applications • Virtually any source or target • Lift and shift your onpremise Planning apps to the cloud Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential

On-Premise to EPM Cloud Using On-Premise FDMEE • Register EPM Cloud application in FDMEE • Looks and acts like on-prem application • Drill-through from cloud natively supported • 2 -Way integration for PBCS, EPBCS and FCCS • Extract from TRCS, ARCS and journals from FCCS on roadmap • Use scripting to extend to other services as needed • Important tool to facilitate incremental move to cloud Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Roadmap Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 20

Oracle EPM: Data Management Recent Highlights Ø Data Management • Included in all services except EPRCS Ø Text, Smartlist, Date support Ø GL Cloud Integration • Data, Drill, Writeback • Budget and budgetary writeback only Ø Netsuite • Saved search and drill Ø HCM Cloud Ø Cloud Features Backported • Available in 11. 1. 2. 4. 210 Ø Full Hybrid Support • Including GL Cloud R&D Underway Ø Ø Convert to Simplified UI Metadata from a file HCM Cloud Metadata On-Premise release 11. 1. 2. 4. 220 Looking Forward Ø Additional Integrations • Sales Cloud • Projects Cloud • Integration Cloud Service • Database Cloud Service • Integration with EDMCS Ø Ø Ø Journal Extract from FCCS “Actuals” write-back to Oracle GL Cloud Export non numeric data Scripting Direct load – no map, no drill For Event Use Only. The above 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, and timing features or functionality Copyrightrelease, © 2017, Oracle and/orof itsany affiliates. All rights reserved. | described for Oracle’s products remains at the sole discretion of Oracle Corporation. 06/2017 Copyright © 2017 Oracle and/or its affiliates. All rights reserved

Sims Metal Management Limited Hybrid Approach to Integration – On-Prem Consolidation and Cloud EPBCS October 2, 2017 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Introductions Jim Clark - Group Manager of FP&A, Sims Metal Management Limited 7+ years at Sims in a variety of accounting & finance functions Experience with HFM/FDM for consolidations and reporting Project lead for global implementation of e. PBCS Sims Metal Management Limited World’s leading publicly listed Metal Recycler (SMM) World’s leading Electronics Recycler (SRS) Municipal Curbside Recycling (SMR) Operations on 5 Continents Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 23

Sims e. PBCS Transition Manufacturing organization Source Systems Multiple instances of 4 GL systems Flat Files EPM Current State FDM Classic On Prem – Hyperion Financial Management (HFM) EPM Future State On-Prem FDMEE 11. 1. 2. 4. 210 On-Prem HFM 11. 1. 2. 4 Enterprise Planning and Budgeting Cloud Services(EPBCS) Reconciliation Application Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 24

Integration Design GL 1 GL 2 GL 3 GL 4 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 25

Application Registration Target Applications in FDMEE On-Premise - HFM Consolidation Application Cloud - Enterprise Planning and Budgeting Cloud Services Target App Type – Cloud Enter Connection Details Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 26

Inbound Integrations Multiple Source GL systems 4 GL systems Flat Files Source Integrations Open Interface Adapter Open interface adapter is essentially a generic staging table in the FDMEE repository you can push or pull data to using any technology you like. Universal Data Adapters Register any database table or database view as a data source in FDMEE. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 27

Inbound Integrations EPBCS Data Same 5 sources for Actuals Another feed of Inventory data Data for EPBCS at different level Make use of Attribute Dimension Leverage data in FDMEE staging tables Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 28

Open Interface Adapter Allows execution of SQL against any relational data repository Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 29

Metadata Build Locations and Import Formats FDM Classic: 46 Locations, 46 Import Formats, 46 Import Scripts FDMEE: 46 Locations, 9 Import Formats, 0 Import Scripts Different SQL code for different entities Deployed a flexible framework for execution of scripts Bef. Import Event script Custom class scripts for corresponding source system called Function executed for the entity for which data load was executed based on location name Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | SQL code executed for called entity and data imported in FDMEE 30

Data Load Mappings/Transformations Reviewed old mappings Found patterns in the maps 1000’s of Explicit maps converted to LIKE maps Manipulation of Segment values in Import Scripts var. Values in FDM Classic converted to Multi-dimension Maps based on Target Values Opportunity for making maps efficient Improves Performance in Data Loads Less Maintenance More Finance users driven Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 31

Data Load Mappings/Transformations EXPLICITS maps with a pattern converted to LIKE Map using wildcard Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 32

Data Load Mappings/Transformations If/Else conditions in Import Script converted into A Multidimensional map in FDMEE Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 33

Data Load Mappings/Transformations SQL Mapping based on the TARGET values Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 34

Data Synchronization – Hybrid Support Requirement Move Budget and Forecast data into HFM application from EPBCS Move Stats data into EPBCS from HFM Build Import Format Select Source & Target EPM Application Create Location Build Data Load Rule Select Source Plan Type Define source Filters in the web interface Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 35

Data Reconciliation Approach - When? • Challenges – Data Validation – The process of comparing 2 (or more) sets of numbers to identify discrepancies in order to ensure accuracy and data quality • When Should Data Validation Be Performed? – System Upgrades – System Changes • Redesigns • Hierarchies – Application Migrations – New System Implementations – Intersystem Reconciliations • HFM Essbase Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 36

Data Reconciliation Approach – Why ? • Traditional way of Validating data – Printed reports – Access database – Excel workbooks • Challenges – Lacks Granularity – Inefficient • Manual end user execution • Application performance – Lacks auditability and version control • When was the process run • When were formulas changed Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 37

Data Reconciliation – How? • Bring data into a common interface (Import) • Align data between the different sources (Map) • Check variances (Report) Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 38

Questions and Answers Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 39

Safe Harbor Statement The preceding 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. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal 40