Winning With EPM Cloud - Oracle

Winning with EPM CloudEPM Cloud IntegrationMike Casey, Oracle EPM Product ManagementMarch 7, 20182

Safe Harbor StatementThe following is intended to outline our general product direction. It is intended forinformation purposes only, and may not be incorporated into any contract. It is not acommitment to deliver any material, code, or functionality, and should not be relied uponin making purchasing decisions. The development, release, and timing of any features orfunctionality described for Oracle’s products remains at the sole discretion of Oracle.Copyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal3

Agenda1Integration Overview2Data Management3Use Cases4Roadmap, EPMAutomate and Scripting5Demos6Q&ACopyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal4

Integration OverviewCopyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal5

Cloud and Hybrid Integration OverviewData WarehouseData MartOtherSystemsFileExcelOracle EBS,PeopleSoft, JDE, FusionAPPs, SAP R/3As customers incrementally migrate to thecloud, integration between on-premise,EPM Cloud and other branded cloudservices becomes criticalEPM CloudHow do youimplement thearrows?Oracle andNon-OracleCloud2014and/orOracle and/orits affiliates.All rightsreserved.CopyrightCopyright 2017, Oracleits affiliates.All rightsreserved. 6

Hybrid Implementation Support Financial Data QualityManagement, EnterpriseEdition (FDMEE)– Recommended approach forHybrid Integration Easily integrate cloud and onpremise applications Virtually any source or target Lift and shift your on-premisePlanning apps to the cloudCopyright 2017, Oracle and/or its affiliates. All rights reserved. Oracle Confidential

Data ManagementFDMEE in the CloudCopyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal8

Integration using Data ManagementTransform and load from any source Flat file or directly from Oracle GL Cloud Included in all cloud services except EPRCS Any format Delimited, fixed width, multi-column, text, etc. Map data to transform from source Robust features provided to manage the data loadingworkflow process Drill-through to source possible if HTTP:// landing pageavailable Log files available from Process Details to investigate issues or“Provide Feedback”Copyright 2017, Oracle and/or its affiliates. All rights reserved.

Integration using Data ManagementFilter and Extract Data Utilize data outside of EPM Cloud applications Easy setup in Data Management Use custom application as target Filter and save as delimited file Extracted to Data Management outbox Download by hand or with EPMAutomate Customize to provide additional dimensionality beyond EPMCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Integration using Data ManagementPreferred Use Case Data not in target specific formatManage process with workflow, audit and controlsDrill-through to sourcePrototype with native loading, then transition to DataManagement as complexity increasesCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Automating the Data Integration ProcessUsing EPMAutomate 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 commandsCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Use CasesCopyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal13

Native Cloud Data LoadingProvided by each EPM Cloud Service Specific format for each EPM cloud serviceImport/Export Data and MetadataExecute manually, schedule with UI or EPMAutomate/RESTDrill-through not supportedCopyright 2017, Oracle and/or its affiliates. All rights reserved.

On-Premise to EPM CloudUsing 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 onroadmap Use scripting to extend to other services as needed Important tool to facilitate incremental move to cloudCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Integration using Data ManagementTransform and load from any source Flat file or Oracle GL Cloud, HCM Cloud or Netsuite Included in all cloud services except EPRCS Any format Delimited, fixed width, multi-column, text, etc. Map data to transform from source Robust features provided to manage the data loadingworkflow process Drill-through to source possible if HTTP:// landing pageavailable Use log files available from Process Details to investigateissuesCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Cloud to CloudUsing Data Management Synch data between EPM Cloud service instances Supported sources – PBCS, EPBCS, FCCS, PCMCS, TRCS Journals from FCCS and balances from ARCS not supported 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 POVCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Oracle GL Cloud to EPMPre-built Integration User/Password and WSDL for connection setup Includes GL Balances and Budgetary Control Write back as budgets or to Budgetary Control Drill-through automatically configured Oracle GL Cloud also available in Hybrid mode with FDMEECopyright 2017, Oracle and/or its affiliates. All rights reserved.

Integration with Oracle GL Cloud Extract from Oracle GL Cloud andload to any EPM Cloudapplication Write-back to Oracle GL Cloud– Budgets and Budgetary Control– Actuals (future) Drill-through from EPM Cloud toOracle GL Cloud Note: Metadata loading via native app feature only. Onroadmap for Data ManagementCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Oracle HCM Cloud to EPMPre-built Integration Predefined content for EPBCS – Workforce Planning Standard HCM Extract Each person/resource in HCM Customize as needed 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 Available now!Copyright 2017, Oracle and/or its affiliates. All rights reserved.

Oracle Netsuite to EPM CloudPre-built Integration Netsuite “Saved Search” available as integration source Any saved search - GL, AR, AP, etc. Production and sandbox environments Available for any EPM Cloud application with DataManagement Available now Netsuite early adopter approval requiredCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Oracle Projects Cloud (PPM) to EPM CloudManual ProcessProjects Cloud to EPM Cloud Export Project Details and Budgets Use SOAP api or OTBI (Oracle Transactional BusinessIntelligence Load with Data Management or Native PlanningEPM Cloud to Projects Cloud Export using Data Management or Smart view Import to Projects with SOAP or FBDI FBDI – File Based Data Import Project and Budget spreadsheet Construct SOAP payload as neededMapping between systems is most important stepCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Hybrid for ARCS using FDMEE On-premiseWith Scripting and EPMAutomate Process import file with FDMEEGenerate export file with event scriptPost to ARCS with EPMAutomate or REST called from FDMEEWhite papers provided for standard balances and BAI fileformat processing. Inclusion in Data Management planned for 18.05Copyright 2017, Oracle and/or its affiliates. All rights reserved.

BI Cloud ConnectExport any Oracle ERP Cloud Data Export desired data from cloud ERP Utilizes BI extract view objects (VO) Exported data saved to UCM Download from UCM Load using Data Management or native loadingCopyright 2017, Oracle and/or its affiliates. All rights reserved.

BI PublisherExport any Oracle ERP Cloud Data Export desired data from cloud ERP Use available content or custom query Download manually or via REST API Universal Content Management (UCM) not required Orchestrate using bat/sh file and EPMAutomateCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Integration Cloud Service Two ways to process files HTTP request with payload – 10 MB size limit Via on-prem agent. Up to 10 GB Call REST API to upload file and import Run through Data Management or Native Import ICS is just the “pipe” to upload data and kick off importCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Using EPMAutomateStandalone or called from on-premise FDMEE 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 e.g. Use Jython to pull from on-prem or cloud source White paper available Host EPMAutomate on-prem or PAAS See documentation for full list of commandsCopyright 2017, Oracle and/or its affiliates. All rights reserved.

Cloud and Hybrid Integration OverviewOtherCloudServicesERPCloudOracle EBS,PeopleSoft, JDE, FusionAPPs, SAP R/3Data WarehouseData MartOtherSystemsFDMEE11.1.2.4.200 Requires FDMEE license.Direct integration from on-prem to EPM Cloud.Load, write-back, drill, scripting, etc.EPM CloudDataManagementPod-2-PodFileExcelDrill through to an on-prem URL is supported bydata management without on-prem FDMEEFileExcel2014and/orOracle and/orits affiliates.All rightsreserved.CopyrightCopyright 2017, Oracleits affiliates.All rightsreserved. 28

RoadmapCopyright 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal29

Data Management and EPM Cloud ServicesRelease Highlights – October 2017Data ManagementIncluded?On-Prem to CloudHybrid Support?Export from cloudor source for podto pod?Load Text andMulti -ColLoad JournalsIntegrate withFusion GL sYesYesNAYesTRCS (Tax)YesYesYesYesTBDYesAdditional considerations: Data Management not currently on roadmap for EPRCS or Essbase Cloud ServiceCopyright 2017, Oracle and/or its affiliates. All rights reserved. Oracle Confidential

Oracle EPM: Data ManagementRecent 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 On-Premise release 11.1.2.4.220 (Dec ‘17)R&D Underway Simplified UI (CY2018) HCM Cloud Metadata (CY2018) Generic metadata via a file (17.12) ARCS – Transaction Matching and Bank Filesupport (18.05) Projects Cloud (CY2018) Data Import Simplification (CY2018) Additional import format expressionsLooking Forward Journal Extract from FCCS Actuals write-back to GL cloud Additional Integrations Enhanced ARCS Support Export using OLU Additional Direct Integrations Scripting Integration with DMCS Additional Integrations Database Cloud Service Sales cloud Direct load – no map, no drill Pod-2-Pod Journals from FCCS Oracle Cloud Financials Sub-ledger Auto-create from COA Metadata supportFor Event Use Only. The above is intended to outline our general product direction. It is intended for information purposes only, andmay not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not berelied upon in making purchasing decisions. The development,and timingfeaturesor functionalityCopyrightrelease, 2017, Oracleand/orofitsanyaffiliates.All rightsreserved. described f or Oracle’sproducts remains at the sole discretion of Oracle Corporation.2/2018Copyright 2018 Oracle and/or itsaffiliates. All rights reserved