Category: Pre-built Reports

Prebuilt HCM report to reconcile PayCheck Details

HCM paycheck

Oracle has seeded reports such as Payslip and Paycheck but at times Users would like to have a report which will have a summarized information of the data that is available on the Payslip/Paycheck so that they can reconcile this report’s data with Oracle’s report in order to confirm the amounts produced are correct in all these reports. Users can run this pre-built report when they would want to see, 1. The total amount processed for a particular paycheck date 2. To confirm if the amounts produced for a paycheck date is correct in the Oracle’s seeded reports. 3. To check the total amounts processed for each paycheck date separately in a huge check date range that they run. DataTerrain’s Prebuilt report: The Prebuilt report Paycheck Detail will provide the Users with data such as employee number, employee name, pay period start/end date, element name, element description, the sum of earnings and sum of earnings hours. Users can run this report with the below parameters, 1. For a single Check Date/For a range as Start Check Date and End Check Date 2. For a single Person 3. For a Payroll This report is built as an HCM Extract in order […]

Read More +

How to view terminated Employee deduction Details in Oracle HCM

Pre-built reports

DataTerrain’s Oracle HCM Prebuilt report is designed to display the payment details of terminated employees in any Check Date range. This report will include specific tax deductions and also it will capture bonuses to be repaid for employees terminated in the Check Date range. This report can be run for the below parameters ● Payroll Name ● Check Start Date ● Check End Date ● Payroll Consolidation Group ● Person Number ● Employee Name ● Company 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, Business Unit information, Payroll Check Number, and details of Deduction elements for each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: HR/Payroll Team can also schedule the report to be 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 300-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 view Employee Location Transfer Details in Oracle HCM

Oracle HCM

Report Description:DataTerrain’s prebuilt report allows an HR specialist to update assignment information on multiple workers who were transferring from one work location to another at once, within the same legal employer. This report can be run for the below parameters● Start Date● Effective Date● Process Configuration Group● PersonThis Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Assignment Details, Payroll Frequency, Deduction Element details for each Employee.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: HR/Payroll Team can also schedule the report for delivery 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 New Hires or Terminations

One of the crucial tasks of HR Team is to maintain a clear track of the new hires and terminations of an Organization. It is necessary for the HR Team to have reports which provide an answer to important questions such as: 1. How many employees are newly hired in the last quarter? 2. How many are terminated within a particular period? 3. In which Business Unit/Location/Department, the most or least hires/terminations occurred? 4. Newly hired/terminated employee count in a particular Payroll DataTerrain’s Prebuilt report provides details related to the new hired/terminated employees. This prebuilt report can be run for the below parameters 1. Start Date/End Date (To get employees in a date range/Quarter) 2. Payroll Name (To filter hire/terminations in a payroll) 3. Organization (Display hire/terminations in an Organization) 4. State/Location/Department (To list hire/termination by State/Loc/Dept) This report can also be run for a default period such as for capturing the hire/terminations in the past 30 days/15 days instead of passing any parameter. This report is built both as an HCM Extract and a BIP report, hence it can be run from the ‘CheckList’ section or from the BI Publisher Catalog, Users can use either Extracts or BIP report […]

Read More +

Prebuilt HCM Report to view Union Dues

PREBUILT HCM REPORT

Report Description: DataTerrain’s Prebuilt report has 3 different Extracts with specifications as below: 1. This report lists the employees who have new union dues authorization. The output displays the deduction code, deduction amount, the employee hire date, and the effective date of their deduction. 2. The next report under Union dues fetches the employees with union type deduction and also have been promoted to Manager in the date range we have run for. Employees with Action Type as Promotion are displayed. 3. This report identifies the employees who have union initiation fees in the current pay period we run for. This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. The report will run with the following Parameters: • Pay Period Begin Date • Pay Period End Date • Emp ID • Payroll Name The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: HR/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 200 plus customers in the […]

Read More +

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 +

Balance Groups in Oracle Fusion HCM

Balance Groups in HCM are amounts or hours that are aggregated based on Month, Quarter or Year. Balance Group and Balance Group Usages for the specific Balances can be created from the Payroll Calculation work area in the Oracle Fusion HCM environment. Oracle HCM Fusion provides us the option of using either Pre-defined balance groups or User-defined custom balance groups for our reports. Pre-defined Balance groups in HCM contain information about all the earnings and deductions but if we would like to see only the amounts or hours of a list of earnings. User-defined custom balance group can be created with the list of earnings that we require and use it in our custom extract to view only the values for those earnings. Data Terrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +