Category: Pre-built Reports

How to use Oracle HCM Report to view Clawback Funds

HR prebuilt reports

DataTerrain’s prebuilt report provides the details of employees whose claw back funds are returned to the firm properly. Clawback is a provision under which money that’s already been paid out must be returned to the employer or the firm.  This report can be run for the below parameters Effective Date Start Date Process Configuration Group 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 Supervisor Information, Process Date, Hired Date, Clawback Status of 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 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 +

How to view Personal Payment Method Details in Oracle HCM

Oracle Prebuilt reports

Report Description:DataTerrain’s Oracle HCM prebuilt report provides payment methods and historical payments processed for each employee. Personal Payment Method can be created only when Payroll is assigned to a person and valid payment methods are assigned to the Payroll. This report can be run for the below parameters● Effective Date● Start Date● Payroll● Consolidation Group● Process Configuration Group● Payroll Statutory Unit● Tax Reporting UnitThis Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Payment Type and Payment Details 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 be delivered weekly/bi-weekly and used 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 HCM Privileged Roles Audit Report

BIP Reports

Report Description:DataTerrain’s Prebuilt report is designed to display the details of the function and data security privileges granted to specific users or roles. This information is equivalent to the information that you can see for a user or role on the Security Console. This Prebuilt report is available as a BIP report.Output: The output data will have Roles of each employee.The output format of this report is Excel.Schedule: HR Team can also schedule the report 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 audit employee’s 401K Contribution Limit

401K Saving Plan

401K is a popular retirement saving plan provided by the employer which helps employees to save for their retirement years. Every year, there is a contribution limit set for the 401K plan which will be deducted from the Employee’s payment. This deduction should be done as per the defined limit and any employee who has contributed over the limit should check these before their annual tax filing, failing which will invite penalties. ReportDescription: DataTerrain’s Prebuilt report helps the Employer and the Employee to get quickly the list of employees who have contributed more than the limit set for a year. Parameters: This report can be run for a date range so that Users can view the contributions that occurred in a particular date range, generally for a financial year. Parameters available in the report are listed below: • Effective Start Date/End Date • Person Number • Legal Employer • Payroll This report is available as a HCM Extract and BIP report. Based on User’s preference, it can be run from a Checklist or BI Publisher Catalog.Prebuilt HCM Report to audit employees 401K Contribution Limit Output: The output data will have details regarding the person number, latest assignment number and status, […]

Read More +

How to view Contingent worker roster in Oracle HCM

Oracle HCM Prebuilt Reports

DataTerrain’s Prebuilt report is used to find the details of contingent workers and non-permanent workers who are hired on a per-project basis. This report can be run for the below parameters● Person Type● Segment● Organization● Division● Department● Region● Country● Assignment StatusThis Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have Department classifications, Job details, Contractor details, Sponsor’s information of each employee.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: HR Team can also schedule the report 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 Employees in Incorrect Paygroups

HCM Prebuilt

Report Description:DataTerrain’s Prebuilt report is designed to display the list of Hourly employees who are in Salaried pay group and Salaried employees who are in hourly paygroup. It will be helpful to find associates who are not assigned with their appropriate pay group.This report has following parameters❖ Start Date❖ End Date❖ Person Number❖ Payroll NameThis Prebuilt report is available as BIP/HCM Extract and hence it can be run from the Checklist and also this report can be built as a BIP Datamodel report. Output: The output data will have PayGroup information of each employee.The output format of this report is Excel.Schedule: HR/Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit to check if any employees are assigned an inappropriate paygroup. 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.. Sample Output:

Read More +

How to view Company Mismatch Job Checks using Oracle HCM reports

Oracle HCM

DataTerrain’s Prebuilt report is designed to identify the Employees details who were employed in a company but paid out of the different companies. This result used to find Retroactive Job Data Changes. 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 havePaycheck Company, Net Pay, Total Taxes, Earning and Deductions elements 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 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 +

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 +

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 +

How to view Earning Element Details in Oracle HCM

Earning element in oracle HCM

Report Description: DataTerrain’s Prebuilt report is designed to display the earning element details of employees in a particular Pay Period Date range. This report can be run for the below parameters • Pay Period Start Date • Pay Period End Date • Emp ID This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Output: The output data will have Earn Code, Department and Business Unit information of 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 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 an additional 70 customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +