Category: HCM Fusion

Overview of HCM Spreadsheet Data Loader

Oracle HCM Data Loader

Oracle HCM Spreadsheet Data Loader (HDL) is useful for loading data to HCM stage tables using an Excel Spreadsheet. Predefined spreadsheets are available for most of the objects and Users can define their own spreadsheets for any object as per requirement. HDL also offers similar features of data loading whereas Spreadsheet Data Loaders have their own advantages: Spreadsheet Data Loader templates are easy to use. Based on business requirement, spreadsheets can be tailor-made. Errors are reported in the spreadsheet template itself where we can fix and review them. In scenarios such as loading element entry for an element, spreadsheet is a better option. Loading data can be done through spreadsheets and can be maintained using .dat files.The process of uploading data using HCM Spreadsheet Data Loader consists of Import and Load stages. During the import process, the data gets uploaded to the HCM Data Loader Stage Tables and during the load process, the imported data is finally loaded to the Oracle HCM Cloud Application Tables.Spreadsheet Data Loader feature has below prerequisites: HCM Integration Specialist role is mandatory for using the spreadsheet feature. Under Setup and Maintenance, the HCM Data Loader Scope value should be set to Full in the Configure […]

Read More +

Prebuilt HCM Report to view Pay Period Validation Report

Prebuilt HCM

DataTerrain’s Prebuilt report is designed to focus on Retention and Severance payments to employees, both Executives and Non-Executives. This report will determine if overpayments were made for employees and identify employees who are receiving Severance or Retention payments during a Pay period. This report can be run for the below parameters● Effective Date● Start Date● Consolidation Group● Payroll● Payroll relationship Group● Payroll Statutory Unit● Person Number● Tax Reporting UnitThis Prebuilt report is available as a BI Publisher Data model report. Output: The output data will have Supplemental Earning Elements, Deduction Elements, Payroll Definition, Garnishments, Termination Dates of each employee. The output format of this report is Excel.Schedule: Payroll Team can also schedule the report to get it delivered weekly/bi-weekly as per their business requirement. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

How to capture and view Employee Safety Statistics using Oracle HCM

HCM Prebuilt

DataTerrain’s Oracle HCM Employee Safety Statistics Prebuilt report is designed to display the number of employees and total hours worked for each site and Department ID (division, cost center). This report can be run for the below parameters● Start Date● End Date● Person● Process Configuration Group● Payroll● Consolidation group● Payroll Statutory Unit● Tax Reporting Unit● Payroll Relation GroupThis Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Number of Employees and Hours details of each site and Department ID.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule : Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +