Category: Human Capital Management

Prebuilt HCM Report to view all Transfer details

HCM prebuilt reports

One of the most important processes in an Organization is Employee Transfer. These transfers usually occur under different organizational requirements such as: • The requirement of additional resources in a department • Need for resources with a particular skill set • Releasing unutilized resources across departments etc. Every Management should constantly monitor the resources available and how they are utilized in each department in order to effectively maintain the recruitment process and the existing resources in an Organization. Report Description: DataTerrain’s Prebuilt report lists the changes or transfers of an employee for a particular effective date. The transfers in Job Location, Position, Manager, Company and Job codes will be captured in the output. This prebuilt report can be run for the below parameter • Effective Date This report can also be modified to run for a date range so that Users can view the transfers that occurred in a particular date range. This report is built as a BIP report and hence it can be run from the BI Publisher Catalog. Output: The output data will have both a new Job/Location/Position/Company details along with the previous Job/Location/Position/Company details. The output format of this report is Excel and it can also […]

Read More +

Expedite Peoplesoft Reports to Oracle HCM Migration Using Pre-Built Reports

Most of the big enterprises have started migrating their Peoplesoft system to Oracle Fusion HCM. After the migration process, one of the important challenges faced by the Users is that they would be not able to have the reports in Oracle Fusion HCM that they were previously using in Peoplesoft Environment. Oracle provides a bundle of pre-built reports which users can make use for viewing the required Payroll/HR/Compensation data from Fusion. In certain scenarios, users would like to have their existing PeopleSoft report replicated in Oracle Fusion HCM for requirements such as tax filing or other internal audit purposes. DataTerrainhas created a variety of pre-built Oracle HCM reports which are similar to Peoplesoft reports in report functionality and formatting features such as page breaks and totals. These reports can be quickly rolled out with minimal customization, saving significant time and cost. Some of the useful Peoplesoft reports that are already pre-built in Oracle Fusion HCM are: • PAY007 – Deduction in Arrears • PAY013(CN) – Employee Earnings Snapshot • TAX010FD – Tax Summary – Federal (can be run for a date range) • TAX010ST – Tax Summary – State (can be run for a date range) • TAX900 – Tax […]

Read More +

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 +

How to use HCM Report to determine payment as per DPC norms

Oracle HCM

DataTerrain’s prebuilt Oracle HCM report provides 100 percent of base salary for weeks 2 to 13 of disability (Week one is taken as Time Bank hours) and also provides 75 percent of your base salary for weeks 14 through 26. This is as per DPC (Disability Policy Consortium) norms. 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 Group This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Department classifications, Elements description, Monthly Salary of each employee.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 +

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 +

PreBuilt HCM Report to view Officer Wages

HCM prebuilt

DataTerrain’s Prebuilt HCM report is designed to display the Gross wages of Employees with Officer Codes for the fiscal year to utilize these information for specific tax credits. 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 Unit This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Officer Code, Tax level, and Gross Wages of each employee.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 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 +