Category: Pre-built Reports

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 +

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 view Personal and assignment data

Report Description: DataTerrain’s Prebuilt report is designed to fetch personal and assignment related data of suspended/terminated and transferred employees in order to verify the transactions that are to be carried out appropriately such as ending or moving deductions as per the Assignment Action of each employee. . This report can be run for the below parameters • Effective Date • Start date This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Effective Date is a mandatory parameter. Output: The output data will have the data related to Employees and their assignment. 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 US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long term binding contracts. Sample output:

Read More +

Prebuilt HCM Report to audit Full Time/Part Time transition of employees

Tracking the workforce by their employment type (i.e., Full Time/Part Time) is important to have a clear record of the payroll elements processed to these employees. Appropriate Payroll elements should be processed by the Organization for each employee type. This report provides a list of employees who had a change in their employment type in the date range we run. Report Description: DataTerrain’s prebuilt report helps an Organization to identify the employees who had a recent change in Employment types such as transferring from full time to part-time or vice versa. Parameters: This report can be run for a date range or even a single effective date so that Users can view the employment type changes that occurred in a particular date range. Parameters available in the report are listed below: • Effective Start Date/End Date • Person Number • Payroll • Legal Employer This report is available as BIP report and hence it can be directly run the BI Publisher Catalog itself. Output: The output data will have details regarding the person number, latest assignment number and status, Effective start and end dates of the latest assignment, Hire/Rehire Date, Current employment type, Previous employment type, Current and previous hourly […]

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 LOA Summary Details in Oracle HCM

Pre-built reports

Report Description: DataTerrain’s Oracle HCM Prebuilt report provides employees who began, ended or were on LOA during the dates selected. A leave of absence (LOA) is an extended period off from your job depending on the organization. You may simply be able to ask for time off from work for a variety of reasons: from personal or family health problems, the birth or adoption of a child, etc. This report can be run for the below parameters ● Begin Date ● End Date ● Segment ● Organization ● Division ● Department ● Region ● Country ● Assignment Status This Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have Department Classification, Supervisor’s information, LOA details of each User.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 200 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 Tax Errors

Report Description: DataTerrain’s Prebuilt report is designed to capture Tax related error conditions such as • Invalid SSN • Negative Gross amounts • The conditions that were available in the Oracle HRMS report “Unacceptable Tax Balance report” to list out the employees with issues in their balances. This report can be run for the below parameters • Effective Date • Person • Organization This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Effective Date is a mandatory parameter. Output: The output data will have Employee number, Employee Name, SSN and the reason for the errorThe 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 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 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 +