Management Cloud Oracle Human Capital

Oracle Human CapitalManagement CloudHCM Extracts20D

Oracle Human Capital Management CloudHCM Extracts20DPart Number F34338-03Copyright 2011, 2020, Oracle and/or its affiliates.Author: Devjani KarThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protectedby intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate,broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering,disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please reportthem to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, thenthe following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed oractivated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to oraccessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to theapplicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display,disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integratedsoftware, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computerdocumentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. Theterms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights aregranted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended foruse in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardwarein dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safeuse. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarksor registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. OracleCorporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, andservices unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsiblefor any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicableagreement between you and Oracle.The business names used in this documentation are fictitious, and are not intended to identify any real companies currently or previously in existence.

Oracle Human Capital Management CloudHCM ExtractsContents1PrefaceiWorking with HCM Extracts1Introduction to HCM Extracts . 1Extract Components. 1HCM Extract Types. 3Overview of Payroll Interface Extract Definitions . 4Best Practices for Viewing User Entity Details . 5User Entities in HCM Extracts . 6HCM Extracts TemplatesDefine Extracts. 7. 8Define Extracts in the Simplified Interface . 16Extract Deleted Object Details . 22How Extracts are Validated . 24Review Extract Run Details . 25Purge Extracts Archive Information . 26Extracts Process Diagnostics Report . 27FAQs for Managing Extracts . 282Filtering and Delivering HCM Extracts37Guidelines for Using Different Modes for HCM Extracts . 37Filter Extracts Using Advanced Filter Criteria . 38HCM Extract Formula Types . 39Guidelines for Delivering Extracts . 40Define the BI Publisher Template in HCM Extracts . 40Best Practices for Delivering Encrypted Data Using HCM Extracts . 42Define SFTP Configurations . 42FAQs for Filtering and Delivering HCM Extracts . 43

Oracle Human Capital Management CloudHCM Extracts3Flow Patterns49Flow Patterns for Extracts and Reports . 49Checklist and Flow Tasks. 49How Tasks Within Flow Patterns are Edited . 50Flow Pattern Parameters. 51Flow Task Start and Due Dates . 56Examples of Editing Flow Patterns . 57Add a BI Publisher Report to a Flow . 59Create a Flow within a Flow . 63FAQs for Flow Patterns4. 65Transferring Encrypted Data67Set up Encryption for File Transfer . 67Encrypt and Upload Files Automatically . 69Transfer Files Automatically from HCM Extracts with PGP Encryption . 705HCM Extracts and Diagnostics73HCM Data Loader Extracts . 73Setting Up HCM Data Loader Extracts . 73Running HCM Data Loader Extracts . 786Benefits Data Extract83Guidelines for Extracting Benefits Data Using HCM Extracts . 83Configure Benefits for Extracting Data . 84Valid Extract Names. 86Generate and Transmit Benefit Extracts . 88Example of a Custom Layout for Benefits Extract . 897Talent Review and Succession Management Data Extract97Guidelines for Extracting Talent Review Data Using HCM Extracts . 97Guidelines for Extracting Succession Management Data Using HCM Extracts . 98

Oracle Human Capital Management CloudPrefaceHCM ExtractsPrefaceThis preface introduces information sources that can help you use the application.Using Oracle ApplicationsHelpUse help iconsto access help in the application. If you don't see any help icons on your page, click your user imageor name in the global header and select Show Help Icons. Not all pages have help icons. You can also access the OracleHelp Center to find guides and videos.Watch: This video tutorial shows you how to find and use help.You can also read about it instead.Additional Resources Community: Use Oracle Cloud Customer Connect to get information from experts at Oracle, the partnercommunity, and other users. Training: Take courses on Oracle Cloud from Oracle University.ConventionsThe following table explains the text conventions used in this guide.ConventionMeaningboldfaceBoldface type indicates user interface elements, navigation paths, or values you enter or select.monospaceMonospace type indicates file, folder, and directory names, code examples, commands, and URLs. Greater than symbol separates elements in a navigation path.i

Oracle Human Capital Management CloudPrefaceHCM ExtractsDocumentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website.Videos included in this guide are provided as a media alternative for text-based help topics also available in this guide.Contacting OracleAccess to Oracle SupportOracle customers that have purchased support have access to electronic support through My Oracle Support. Forinformation, visit My Oracle Support or visit Accessible Oracle Support if you are hearing impaired.Comments and SuggestionsPlease give us feedback about Oracle Applications Help and guides! You can send an e-mail to:oracle fusion applications help ww grp@oracle.com.ii

Oracle Human Capital Management CloudHCM Extracts1Chapter 1Working with HCM ExtractsWorking with HCM ExtractsIntroduction to HCM ExtractsThis topic introduces ways of developing outbound integrations from Oracle HCM Cloud.These include: HCM Extracts Oracle Business Intelligence Publisher (Oracle BI Publisher)HCM ExtractsThe main way to retrieve data in bulk from Oracle HCM Cloud is HCM Extracts, which is a tool for generating data filesand reports.HCM Extracts has a dedicated interface for specifying the records and attributes to be extracted. You: Identify records for extraction using complex selection criteria. Define data elements in an HCM extract using fast formula database items and rules.You manage HCM Extracts either in the Data Exchange work area or using the Checklists interface in the Payroll workarea. Alternatively, you can run extracts using the Flow Actions Service web service from outside Oracle HCM Cloud.This feature enables you to automate the outbound extract as part of an overall integration flow.HCM Extracts Output FormatsUsing the built-in integration with Oracle BI Publisher, you can generate extracts in various formats, including CSV, XML,Microsoft Excel, HTML, RTF, and PDF.You can download the raw hierarchical XML from a completed extract using the Extract Actions Service web service.Alternatively, you can download the formatted BI report (for example, the CSV file) using the BI ScheduleService. In bothcases, the output is streamed in a byte array. Therefore, any orchestration mechanism must handle this output, possiblyby means of wrapper code.You can also generate an HCM Extract without specifying an output format at the design stage. Subsequently, you cangenerate a BI report based on the extract using either Oracle BI Publisher or the BI ReportService. This technique uses adedicated BI data model that interfaces with the generated HCM Extracts XML.Oracle BI PublisherOracle BI Publisher supports both scheduled and unplanned reporting, based on either predefined Oracle TransactionalBusiness Intelligence analysis structures or your own data models. You can generate reports in various formats. To useOracle BI Publisher for outbound integrations, you generate reports in a format suitable for automatic downstreamprocessing, such as XML or CSV.1