Category: Pre-built Reports

Pre-Built HCM Report to Audit Job Changes of Employees

Oracle HCM

In general, HR Audit reports are critical to have a clear review and comply to standards of how the workforce is utilized in an Organization. The Prebuilt HCM Job Audit report has excellent functionalities to tracks all changes that occurred in an Employee’s Assignment/Job during a date range that we run the report for. This Prebuilt report can be run for a date range or by default for the past 30 days which could be scheduled and delivered to a FTP Server/Email as per the User’s requirement. Enhancements such as adding new parameters or conditions to this report is simple. The output type, by default, is Excel which is also customizable to any other format. DataTerrain’s Pre-built reports usually are built in the below 3 reporting formats: 1. HCM Extract 2. BI Publisher Data model reports 3. OTBI Some Users prefer to run the report from CheckList which would require the report to be built as Extract and some run directly from BI Publisher Catalog for which reports should be BIP/OTBI. We have developed this report in both an HCM Extract report and BI Publisher Data model report which users can make use of as per their needs. The Pre-built […]

Read More +

Pre-built – HCM Report to Track Payroll and TRUs

The Prebuilt Multi-Org Transfer Report has excellent functionalities to tracks all changes that occurred in an employee that has transferred between TRUs (Tax Reporting Unit) and/or Payrolls. This Prebuilt report can be run for an effective date or organization name or employee number which could be scheduled and delivered to an FTP Server/Email as per the user’s requirement. Enhancements such as adding new parameters or conditions to this report are simple. The output type, by default, is Excel which is also customizable to any other format. DataTerrain’s Prebuilt reports usually are built in the below 3 reporting formats: 1. HCM Extract 2. BI Publisher Data model reports 3. OTBI Some users prefer to run the report from CheckList which would require the report to be built as Extract and some run directly from BI Publisher Catalog for which reports should be BIP/OTBI. We have developed this report in both an HCM Extract report and BI Publisher Data model report which users can make use of as per their needs. The Pre-built Multi Org Transfer Report captures the following major functionalities and it is customizable: The existing seeded Payroll Activity Report or Employee Active Balance Report do not list out employees […]

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 +

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 view all Transfer details

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 +

Prebuilt HCM report to reconcile PayCheck Details

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 +

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 +

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 +