Category: Oracle Fusion HCM

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 +

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 +

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 +

How to Block Email Delivery if Oracle HCM report returns no data

Oracle HCM customers mostly setup E-mail delivery for their custom/pre-built BI and OTBI reports. There would be a requirement where the report should be delivered to the End User only if it satisfies criteria. Usually, we can add these criteria to the BI Query/OTBI Filter section and restrict the report from displaying the data but we should also block the Email Delivery of this report or else the End User will receive an empty attachment which would be an inconvenience. We can use Event Triggers in BI and Rowcount in OTBI to restrict this blank file delivery to End User’s mailbox. In the BI report, create an “EventTrigger” of “Schedule” Type in the data model and specify the criteria which decide the row count of the report. BI report will initially check whether these criteria return any rows and if not, the report is not scheduled at all. Similarly in the OTBI report, on the report properties, under ‘More’, we can schedule it conditionally by providing the row count condition under the ‘Condition’ tab. We can set the schedule based on the condition row count is not zero in order to block the Email delivery. DataTerrain with years of experience […]

Read More +