Category: Pre-built Reports

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 audit changes in Payment methods

In Fusion, Personal Payment methods of employees are defined when payroll is created. Each employee can have more than one payment method associated with him. If no personal payment method is added to an employee, he will receive his pay by the default payment method of their payrolls. These personal payment methods do not change often for employees. The changes in the employee’s personal payment methods should be checked recurrently in order to prevent the payment being transferred to any incorrect bank accounts which can happen during phishing attacks. Report Description: DataTerrain’s Prebuilt report lists the changes in the personal payment methods of the employees in the past 7 days. This report takes the current date as the input and gets the payment changes in the last one week’s period. This report can also be modified to run for a date range so that Users can view the changes 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 details regarding the old and new bank branch number, account numbers if the personal payment method has changed. The […]

Read More +

Prebuilt HCM Report to view Active employees with no Net/Gross Pay

At times, in an Organization, few employees do not receive pay for a particular pay period but still are active on the Payroll. An Employee may be on a break for a particular pay period due to various reasons such as illness or planned absence. HR and Payroll team has to keep track of the list of employees who are not receiving pay during a pay period for tracing any inaccuracies in payment processing. DataTerrain’s Prebuilt report: The Prebuilt report Active No Pay will provide the Users with a list of active employees who has no NET Amount and Gross Amount for any given payroll period. Users can run this report with the below parameters, 1. For an Organization 2. For a single Person 3. For a Date Range 4. For a Payroll 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 respectively, as per their preference. Output: The output data lists the active employees and his organization, assignment details, pay period start/end dates, Gross and NetPay amounts. The output format of this […]

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 Payroll Summary

HCM prebuilt reports

Payroll teams in an organization would like to view a summary report that provides information on the count of employees who is processed in payroll by each Earning/Deduction element. Report Description: DataTerrain’s Prebuilt report displays the count of employees processed in each payroll cycle based on each earning/deduction/tax element. This report fetches both the current payroll and the previous payroll counts thus can be used for auditing the difference between the last 2 payrolls. This prebuilt report can be run for the below parameters • Effective Date(or Current Payroll Process Date) • Start Date(or Previous Payroll Process Date) • Organization • Employee The effective date will be the current payroll’s process date and the start date entered will be the previous payroll process date, which is mandatory to be passed. This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Output: The output data will have both previous payrolls element names, count of employees processed in current and previous payrolls based on individual elements, current and previous hours worked and the variance between them. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: Payroll […]

Read More +

How to view Employee Roster Register in Oracle HCM

Oracle HCM

DataTerrain’s prebuilt report provides the list of roster employees along with position and demographic data and assignment information. 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, Annual Salary, Work Schedule 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 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 contr

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 +

Prebuilt HCM Report to Audit Employee’s Payroll Hours

Tracking the correct number of working hours of each employee is a significant step in the process of calculating the payments in an Organization. Employees may have worked over the standard hours set for payroll or some would have worked less than the expected standard working hours. The differences between the standard hours and actual hours the employee worked must be recorded properly in order to avoid over/underpayments. Report Description: DataTerrain’s Prebuilt report lists the employee’s assignment, payroll details along with actual hours he worked and the standard working hours corresponding to his payroll. This prebuilt report can be run for the below parameters Effective Date(or End Date) Start Date Payroll Name Organization Employee This report can be run for a date range or a particular effective date based on User’s preference. This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist but if required, this can be created as a BI Publisher report too. Output: The output data will have both Actual hours worked and the standard working hours of each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: Payroll Team […]

Read More +

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 +