Setup Approach
Use HCM extracts to extract, archive, transform, report, and deliver high volumes of HCM data from the Oracle Fusion HCM database.
For large volumes of data, HCM Extracts is the recommended process to retrieve data in bulk from the Oracle HCM Cloud application for generating reports.
| Reporting Option | Description |
|---|---|
| Delivered Payroll Calculation and Balance Reports | Use any of the delivered payroll calculation and balance reports,
for example, the Run Statutory Deduction Register for the Latest
Process report to extract the year-to-date (YTD) payroll balances
for large volumes of data. Use the Submit a Flow task under Payroll and search for a report that suits your requirement. Use the Flow Submission page to define parameters you can use to extract the requisite balance information. |
| Delivered Employee Payroll Balances and Run Results Extract Template | Use the delivered, ready-to-use Employee Payroll Balances and Run Results Extract template to create your own extract definition. Use the template to create an extract definition by selecting the records and attributes from an available set of data elements. |
| Create an Extract Definition | Use the Extract Definitions task in the Data Exchange area
to create your own extract definition to generate balance reports as
per your business requirements. Select an Extract Type of Other Payroll Archive so that the extract uses the archived payroll information to generate the report. |