Safe Harbor Statements The following is intended to outline

Safe Harbor Statements 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. 1 Copyright 2011, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 8

Fusion HCM Cloud Integration File Based Loader ( Rel 5) Prabu Iyer ,Timm Hannula –Fusion HCM Development 2 Copyright 2011, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 8

Oracle Fusion Integration Framework The “Big Picture” File Based Loader - Simplified high volume data loading based on CSV , XML, DAT Spreadsheet Loader – Simplified Low volume data loading via spreadsheets Core HR Staging Area Specialized Loaders Payroll Batch Element Entries Benefits, Talent Web services – Programmatic data exchange with external systems 3 Copyright 2011, Oracle and/or its affiliates. All rights reserved. Benefits HCM Extract Performance Management BI Publisher - Extract data from HCM Business Object repository in a preformatted template Goal Management Web Services Talent HCM Extract - Extract, Transform and format large amounts of complex data Fusion Analytics Compensation Insert Information Protection Policy Classification from Slide 8 OTBI - Extract data from HCM Business Object repository to provide real-time operational reporting & file creation

Agenda 4Copyright 2012, Oracle and/or its affiliates. All rights reserved. FBL Overview Demo - Load /Update Scenarios Q/A

File Based Loader Overview Load HR data from your source system to Fusion HCM Flat file based data upload utility Validates and loads the data Support for Error Correction Supports complex data objects with full date effective history Supports multiple data sources Load data from any source via Flat Files in Fusion Object Shape 5Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

File Based Loader Process Flow csv datafile Bulk Data Load Bulk Load CSVData format CSV format Data Conversion Data Conversion Initial & On going Initial & On going Fusion HCM csv datafile Load data to Load data to Interface Interface Tables Tables Multiple Source Systems 6Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 Validate/ Validate/ Correct Errors Correct Errors Load data Load data to Fusion to Fusion

Process Flow 1. Prepare Fusion for Integration 7 Copyright 2011, Oracle and/or its affiliates. All rights reserved.

Process Flow 2. Transform and Generate Data Files 8 Copyright 2011, Oracle and/or its affiliates. All rights reserved.

Process Flow 3. Validate and Load Data 9 Copyright 2011, Oracle and/or its affiliates. All rights reserved.

10Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 Import data to Fusion HCM schema Verify the imported data Fix import errors and re-import if necessary Import the files in to Fusion HCM staging tables via Data Exchange Observe correct order of the importing objects Customer/Partner Customer/Partner Activity Activity Create the files in Fusion HCM format Transfer the files to Fusion HCM via Secure FTP Cleanse the source data Transform the source data Write Extraction routines Compare the fields from source data with the available fields in Fusion HCM object schema Map source data fields to Fusion HCM object Delivered Delivered Functionality Functionality Import data to Fusion HCM schema Validate data Import Files to Fusion HCM stage area Create Files and transfer files via SFTP Prepare Source data Perform Schema Gap analysis File Based Loader Who does what.

FBL Documents /References Integrations Library: The Data Conversion Reference Library provides customers and partners with timely data conversion related information specific to their Fusion HCM implementation. Email [email protected] for access with you email address . https://beehiveonline.oracle.com/teamcollab/overview/HCM Data Conversion Reference Library Workspace 11Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

File Based Loader Supported Business Objects Work Work Structures Structures 1. 1. Location Location 2. 2. Organizations Organizations Business Business Unit Unit HR HR Org Orgas as Departments Departments 3. 3. Job Job Family Family 4. 4. Job Job 5. 5. Position Position 6. 6. Grade Grade Talent Talent 1. 1. 2. 2. 3. 3. 4. 4. Competencies Competencies Qualification Qualification Rating Rating Scales Scales&&Levels Levels Schools & Colleges Schools & Colleges Compensation Compensation 1. 1. 2. 2. 3. 3. Salary Salary Basis Basis Salary, Salary, Salary Salary Components Components Element Element Entries Entries (Bonus, (Bonus, Allowances) Allowances) 12Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 Employment Employment 1. 1. Person Person Person Person Name Name Person National Person National Identifier Identifier Person Person Address Address Person Person Legislative Legislative Person Person Phone Phone Person Email Person Email Person Person Documentation Documentation Person Person Type Type Usage Usage 2. Assignment 2. Assignment Assignment Assignment Work Work Measure Measure Assignment Assignment Supervisor Supervisor Work Work Term Term Work Work Relationship Relationship 3.Person 3.PersonProfile Profile 4.Person 4.PersonProfile Profile Items Items

File Based Loader Dat File Structure 13Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

File Based Loader Data Loading Sequence 1. Action 12. ContentItem 2. ActionReasons 13. ContentItemRelationship 3. Location 14. Person 4. BusinessUnit 15. PersonDocumentation 5. Grade 16. Department 6. GradeRate 17. Position 7. JobFamily 18. WorkRelationship 8. Job 19. Salary 9. SalaryBasis 20. Element Entry 10. Establishment 21. Profile 11. Rating Model 14Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

File Based Loader Objects Filenames OBJECT NAME Person DATA-FILE NAME F PERSON ADDRESS VO.dat F PERSON EMAIL VO.dat F PERSON ETHNICITY VO.dat F PERSON LEGISLATIVE DATA VO.dat OBJECT NAME DATA-FILE NAME F PERSON NAME VO.dat BusinessUnit F BUSINESS UNIT VO.dat ContentItem F CONTENT ITEM RATING DESCRIPTION VO.dat F CONTENT ITEM VO.dat F DEPARTMENT DETAIL VO.dat F PERSON NATIONAL IDENTIFIER VO.dat F PERSON PHONE VO.dat F PERSON VO.dat Department Profile F PROFILE ITEM VO.dat F PROFILE RELATION VO.dat F DEPARTMENT VO.dat ElementEntry F ELEMENT ENTRY VALUE VO.dat RatingModel Establishment F ELEMENT ENTRY VO.dat F ESTABLISHMENT VO.dat F PROFILE VO.dat F RATING LEVEL VO.dat F RATING MODEL VO.dat Grade F GRADE VO.dat Salary F SALARY COMPONENT VO.dat GradeRate F GRADE RATE VALUE VO.dat Job F GRADE RATE VO.dat F JOB GRADE VO.dat F JOB VO.dat SalaryBasis WorkRelationship F SALARY VO.dat F SALARY BASIS VO.dat F ASSIGNMENT SUPERVISOR VO.dat Location F LOCATION VO.dat Position F POSITION GRADE VO.dat F POSITION VO.dat F ASSIGNMENT VO.dat F ASSIGNMENT WORK MEASURE VO.dat F WORK RELATIONSHIP VO.dat F WORK TERMS VO.dat Sample Data https://beehiveonline.oracle.com/content/dav/Oracle/HCM Data Conversion Reference Library Workspace/Documents/4.%20Load/1.%20Tools/2.%20File%20Based%20Loader/3.%20References/ Sample%20Load%20ZIP%20File(s)/FBLv11SampleDemoData.zip 15Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

File Based Loader Mapping DataLoaderColumnsV3.xlsx 16Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

Enterprise setup vs Conversion Objects Data you setup online in Fusion Data you should not setup online, instead convert using FBL Enterprise Level Setup Work structure & Employee Data This is the basic setup in every project irrespective of conversion approach. Once you configure following objects in Fusion Application, extract the GUIDs using cross reference process and use it in the input files for mapping. There is no GUID extract required for data converted using FBL. You will specify IDs (JOBID, Location ID, Person ID .etc) as part of your data file. FBL will use those IDs to build the key map internally. Objects you configure online: ACTION ACTION REASON ACTION REASON USAGE ACTION TYPE ASSIGNMENT STATUS TYPE ENTERPRISE LEGAL ENTITY LEGISLATIVE DATA GROUP PERSON TYPE SETID PAY ELEMENT TYPE STD PAY ELEMENT TYPE SUPPL PAY INPUT VALUE STD PAY INPUT VALUE SUPPL HRT CONTENT ITEM LANGUAGE HRT CONTENT TYPE HRT CONTENT TYPE RELAT HRT PROFILE TYPE HRT QUALIFIER HRT QUALIFIER SET HRT RELATION CONFIG Objects supported by FBL for conversion: Work Structures Business Units Locations Job Families Jobs Grades Grade Rates Positions Departments Dept Hierarchy Transaction Data Person Work Relationships (work term, assignment, supervisor, work measure) Workforce Compensation Salary Basis Salary Element Entries Talent Management Content Items Rating Models Establishments Profiles (Qualifications, Competencies, latest Performance Rating) 17 Copyright Oracle 2011, Oracle its affiliates. All reserved. rights 17Copyright 2012, and/or and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

Cross Reference between the data files 2007 Oracle Corporation – Proprietary and Confidential 18Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

Loading Flex Fields FBL currently does not support loading of Flex Fields There is a Interim work around process to load Flex field data – Details of this process here : https://beehiveonline.oracle.com/teamcollab/wiki/HCM Data Conversion Reference Libra ry Workspace:DFF Load Info 19Copyright 2012, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12

Demo Scenario : Load Locations Update Locations Sample Files Used In the Demo LocationInitLoad.zip 20Copyright 2012, Oracle and/or its affiliates. All rights reserved. LocationChanged1And4.zip Insert Information Protection Policy Classification from Slide 12

File Based Loader Navigator- Work Force Mangement- Data Exchange 1 Load Business Object via Flat Files 21Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

File Based Loader Load Data to Interface Tables – Load HCM Data 1 Load Business Object via Flat Files 22Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

File Based Loader Load Data to Interface Tables – Load HCM Data 1 Load Business Object via Flat Files 23Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Insert Information Protection Policy Classification from Slide 12 Monitor Data Load 4 Error Handling /Data Validation

File Based Loader Load Data to Interface Tables – Load HCM Data - Error Management 1 Load Business Object via Flat Files 24Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

File Based Loader Load Data from Interface Tables to Application Tables– Load Batch Data 1 Load Business Object via Flat Files 25Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

File Based Loader Load Data from Interface Tables to Application Tables– Load Batch Data – Error Management 1 Load Business Object via Flat Files 26Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

File Based Loader Load Data from Interface Tables to Application Tables– Load Batch Data – Error Management 1 Load Business Object via Flat Files 27Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

File Based Loader Load Data from Interface Tables to Application Tables– Load Batch Data – Error Management 1 Load Business Object via Flat Files 28Copyright 2012, Oracle and/or its affiliates. All rights reserved. 2 Submit Data Load Process 3 Monitor Data Load Insert Information Protection Policy Classification from Slide 12 4 Error Handling /Data Validation

Q&A