October 03 rd , 2017

1. October 03rd, 2017 Oracle Financials Cloud with Oracle Planning and Budgeting Cloud Session ID: CON3637 Speaker : Kavitha Krishna

2. Welcome to OOW ’17 - About Cognizant-KBACE Oracle’s Cloud and other technologies play a critical role in supporting your digital transformation initiatives • We are a long term, award winning Oracle partner. • A proven leader in digital transformation. • More than 200 successful projects using the Oracle Cloud. • We have the end-to-end, best practice services, backed by deep industry expertise needed to deliver successful solutions for our clients across: Oracle HCM, ERP, SCM, CX, PaaS and IaaS.

3. Agenda Introduction to Oracle Integration Services: Oracle PBCS to Oracle Cloud Financials CONTENTS Technical Insight and Process Flow: Budget & Actual Balances Customer Implementation Experience Reporting Capabilities Achieved Cognizant’s Value Proposition

4. Introduction to Oracle Financials Cloud Service along with Oracle PBCS • Oracle Financials Cloud out-of-box integration with Oracle Hyperion Planning and Budgeting Cloud Service(PBCS) facilitates sharing of budget and actual balances between these systems. • PBCS delivers functionality of Hyperion Planning application in SaaS model. • Enables implementation of budgetary controls in Financials for budgets shared via PBCS • Facilitates transparency and efficient financial reporting capabilities

5. Integration Overview • Oracle General Ledger Oracle PBCS Chart of Accounts and Hierarchies Dimension Metadata 2 1 Extract Import Refresh Cube 3 Actual Balances Actual Balances 5 4 Extract Import Run Business Rules for Aggregation 6 Budget Amounts Budget Amounts 8 7 Import Extract

6. Transfer of Budget Balances from PBCS to General Ledger

7. Technical Mapping: Budget Balance Transfer 8 1 Oracle PBCS and Oracle Financials Cloud are generally maintained on separate instances 7 2 The PBCS Essbase cube is different from the Financials cube. The Master data is maintained in these individual respective cubes This integration will enable sharing of budget & actual balances between these cubes 3 6 4 5

8. Process Flow: Budget Balance Transfer Step 01 : Execute the Data Load Rule in Oracle PBCS

9. Process Flow: Budget Balance Transfer (Cont..) Step 02 :You can view the results of the request from the Process Details page. Select Process Details from the Tasks menu bar.

10. Process Flow: Budget Balance Transfer (Cont..) Step 03 : View Uploaded data in ERP

11. Transfer of Actual Balances from General Ledger to PBCS

12. Technical Mapping: Actual Balance Transfer 1 3 5 7 Oracle Financial Cloud Oracle PBCS Data Management : Configure Source Connection as GL Define Import Format Create/Assign Period Mapping Create Data Load Mapping Data Management : Configure Target Application as PBCS Create Location Create/Assign Category Mapping Create Data Load Rule 2 4 6 8

13. Process Flow: Actual Balance Transfer Step 01 : Submit the ‘Trial Balance’ in Oracle Cloud General Ledger

14. Process Flow: Actual Balance Transfer (Cont..) Step 02 :Execute the Data Load Rule in Oracle PBCS

15. Process Flow: Actual Balance Transfer (Cont..) Step 03 :Review the Data Loaded in Oracle Data Management

16. Process Flow: Actual Balance Transfer (Cont..) Step 04 : Confirm and Export Data for upload to Oracle PBCS

17. Process Flow: Actual Balance Transfer (Cont..) Step 05: Verify the data loaded in Oracle PBCS Drill Down to Source Balance in Oracle Cloud GL

18. Process Flow: Actual Balance Transfer (Cont..) Step 06 : The Loaded data could be also reviewed in Smartview Reports

19. What is Supported • Existing ERP systems (On-Cloud & On-Premise) can be integrated with Oracle PBCS For existing Hyperion Planning Customers, PBCS supports upgrade from R11.1.2.1 directly into the Cloud-based application Drilldown from PBCS to Source System Data Refresh & Retrieval in Excel Spreadsheets maintained on local machine via Smart View Data Refresh & Retrieval in Financial Reporting Studio Reports

20. Oracle ERP Cloud-Led Finance Transformation for an Australian Chain of Restaurants TECHNOLOGY PLATFORM SOLUTION HIGHLIGHTS BUSINESS BENEFITS PROJECT HIGHLIGHTS Turnkeyapproach to Project Management “One to Many to One” enterprise structure,design and implementation 30+ Financial Reporting Center reports from ERP and PCBS 50+integrations Unified Architecture across application landscape Automated planning and budgeting enabling faster decision making for store managers Implementation ofOracle ERP Cloud R11 and Oracle PBCS Integration usingOracle SOA Cloud Service (including Oracle MFT Cloud Service) 450+ stores across 8 states and 40 districts in Australia Replacement of legacy systems & manual processes with a solid ERP system Turnkey approach to improved third-party interactions and retention 15% savings on cost leakage Automated PO transmittals and Invoice Entry by EDI interfaces BUSINESS REQUIREMENT 10% overall reduction in time required to set up new stores and with better cost control Decreasemanual data input & processing time for period close Improve existing Finance and Accounting processes Dashboards for Analytical views POS integration time reduced from 13hours to 1hour

21. Solution Integration Architecture Oracle Cloud Macromatix (MMX) PBCS 1 MMX Financials interfaces 2 General Ledger STM POS 3b 3c 3a Receivables SAP BO Objects Cash Management 4 Micros POS Payables Vendors 5 iExpense MMX Order Management interfaces 6 Purchasing 7 Fixed Assets 9 8 Vendors 10 11 Product Hub 12 HR System MMX Master Data 13 Inventory 16a 14 MMX Employees SAP BO Objects 15 16b Projects Payroll File System 17

22. Key Challenges and Cognizant’s Solution Lack of standard business processes Established common business processes resulting in improved financial consolidation and reporting Critical reports tracked on spreadsheets via manual create and update process Built FRS, Smart View Reports. Enabled personalized views on Account Balance and Monitor to track and report. E.g.: balance sheet, tax calculation reports, critical budget accounts Multiple, disparate systems for various operations Financials and other ERP solutions were brought under Oracle Cloud solution. Seamless integrations built from/to Oracle Cloud with third-party applications for data sharing Meeting timelines and solution agreements with financial institutions for integrations Payment transfers and bank statement import processes were automated. CTS SMEs worked with the bank and arrived at industry best-in-class solutions

23. Cognizant Value Adds • Use of Cognizant’s Centre of Excellence Tools & Solution Accelerators for arriving at best-in-class solutions and bug free code • Development of customized Financial Reporting Studio Reports, Smart View Reports • Deployment of Oracle certified and trained cloud consultants with rich industry experience • Leveraged Cognizant’s partnership with Oracle to identify and help fix issues faster • Effective stakeholder involvement and communication to ensure program success

24. Customer Reports : FRS, SmartView Financial Reporting Studio : Variance Analysis Report

26. Join our leadership at our Digital Innovations Center @ JilliansRequest a meeting now at http://cogniz.at/oow17 Join us at Jillian’s and receive an Ebook version of “What to do When Machines Do Everything”, by Malcom Frank, Ben Pring, and Paul Roehrig Jillian's San Francisco 175 Fourth Street San Francisco CA 94103 415.369.6100 Across from Moscone West To download this presentation visit this page after the show: http://cogniz.at/oowKK

27. Thank You Kavitha.Krishna@cognizant.com