Oracle HCM Extracts

Generate data extracts in Oracle HCM Cloud and send the data to Visier.

Note: To enable this feature, contact your Customer/Partner Success Manager.

Overview

Visier integrates with Oracle Fusion HCM Cloud to receive data from your preferred source system. Use HCM extract definitions to transfer data in bulk from Oracle to Visier. You have full control over the fields and history to include. In Oracle, define an extract, add filters and parameters, and schedule it to run. For more information about HCM extracts, see Introduction to HCM Extracts. You can then send the exported files to Visier through SFTP. For more information, see File Upload Using SFTP.

Prerequisites

Access to Oracle Fusion HCM with the following roles.

Role	Description
Human Capital Management Integration Specialist or equivalent	Required for HCM Extracts, Data Exchange, Fast Formula, and HCM Data Loader access.
Application Implementation Consultant	Required for Setup and Maintenance access for Manage Value Sets.
BI Publisher Data Model Developer or BI Administrator or equivalent	Required to build the Data Model, Report object, and upload the eText report template to format extracted data into the delivery file.

Ability to build Oracle Fusion extracts that:
- Allow Visier to extract historical data, not latest period snapshots.
- Are optimally performant and won't time out when pulled.
Ability to troubleshoot and modify extracts to give the expected results.
Update your organization's allowlist. For more information, see Allowlist information.

Supported HCM extract definitions

Visier supports the following extract definitions.

Extract definition	Description
VSR001 - Employee Report	A Changes Only HCM extract definition. After the first full run, this extract only sends records that changed since the last successful run. Attach the globalReportsDataModel Data Model to the BI Publisher report. Like any report built on a standard HCM Extract Definition, this one requires a data model. The data still comes from the extract, not from a SQL query.
VSR002 - Employee PII Extract	A Full Extract HCM extract definition. This extract pulls all employee PII every time it runs. Attach the globalReportsDataModel Data Model to the BI Publisher report. Like any report built on a standard HCM Extract Definition, this one requires a data model. The data still comes from the extract, not from a SQL query.
VSR003 - Location Master Data Extract	A Full Extract HCM extract definition. This extract pulls all active and inactive locations and workplaces every time it runs. Attach the globalReportsDataModel Data Model to the BI Publisher report. Like any report built on a standard HCM Extract Definition, this one requires a data model. The data still comes from the extract, not from a SQL query.
VSR004 - Organization Tree Extract	A BI Publisher artifact built from the following objects. Data Model. This is a SQL query against raw Oracle Fusion tables. Report. This is the object that runs and formats the Data Model's output using an uploaded template. A standard HCM extract does not expose the flattened tree hierarchy. Instead, this extract queries the hierarchy directly using SQL against Oracle's tree tables.
VSR005 - Employee Salary Extract	A Changes Only HCM extract definition. After the first full run, this extract only sends records that changed since the last successful run. Attach the globalReportsDataModel Data Model to the BI Publisher report. Like any report built on a standard HCM Extract Definition, this one requires a data model. The data still comes from the extract, not from a SQL query.
VSR006 - Ethnicity Details Extract	A full extraction. This extract pulls all standard ethnicity meanings and their associated countries from Oracle's delivered lookup tables every time it runs. It is a BI Publisher artifact built from the following objects. Data Model. This is a SQL query against raw Oracle Fusion tables. Report. This is the object that runs and formats the Data Model's output using an uploaded template. There is no value set and no changes-only mechanism. This extract is a reference or lookup data report. It pulls standard ethnicity meanings and their associated countries from Oracle's delivered lookup tables, not from individual employee records.
VSR007 - Corporate Pay Level / Grade Rate Extract	A full extraction. This extract uses a direct SQL query against the Oracle Fusion application database. It is a BI Publisher artifact built from the following objects. Data Model. This is a SQL query against raw Oracle Fusion tables. Report. This is the object that runs and formats the Data Model's output using an uploaded template. There is no: Extract definition. Data Group, Data Record, or Data Element structure. HCM extract delivery flow.
VSR008 - Position Master Extract	A Full Extract HCM extract definition. This extract pulls all active and inactive positions every time it runs. Attach the globalReportsDataModel Data Model to the BI Publisher report. Like any report built on a standard HCM Extract Definition, this one requires a data model. The data still comes from the extract, not from a SQL query.