Category: Pre-built Reports

How to use Oracle HCM Report to view Exempt and Nonexempt employees

HCM Extract

DataTerrain’s prebuilt report provides the legal classifications of employees (Exempt and Nonexempt status) used to distinguish between different types of employees. 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 an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Payroll information, Exempt and Non-Exempt details for a given date range.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 have 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 use Oracle HCM Report to view Pre and Post Tax Insurance Deduction

Payroll tax

Report Description:DataTerrain’s Pre-built report gives the paycheck details of each employee including Pre and Post tax deduction. This report can be run for the below parameters● Effective Date● Start Date● Payroll● Consolidation Group● Process Configuration Group● Payroll Statutory Unit● Tax Reporting Unit● Department● Location● Payroll Relationship Group● Person Name● ProcessThis Pre-built report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Deduction Element Classification, Element Description, Element Name, Deduction Amount for given pay period range.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 Element Costing Details in Oracle HCM

payroll reports

DataTerrain’s prebuilt report calculates costing for prepayments, QuickPay prepayments, and external payments, along with void, canceled, unreconciled, and reconciled payments. This report can be run for the below parameters● Process Start Date● Process End DateThis Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have Element details, Credit and Debit amount.The output format of this report is Excel and can also be rendered as PDF/CSV.Schedule: Payroll Team can also schedule the report to be delivered weekly/bi-weekly and use 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 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 +