• 31 July 2026

Oracle HCM Pay Union Report – Canada

Canadian payroll teams require detailed visibility into employee earnings, hours, deductions, and union-related payroll information for a selected pay-period range. Although Oracle Fusion HCM stores this information across payroll results, balances, employee assignments, and organizational records, retrieving it in one consolidated output requires a customized reporting solution.

DataTerrain developed a customized Oracle HCM Pay Union Report that accepts Pay Period Start Date and Pay Period End Date as runtime parameters and displays employee-level earnings and deduction information for the selected period.

oracle-hcm-pay-union-report
  • Share Post:
  • LinkedIn Icon

Customer Profile

A Canadian organization using Oracle Fusion HCM Payroll required a recurring union payroll report containing employee identification, earnings, working hours, deductions, union codes, location information, and accumulated payroll values.

The report was required for payroll review, union-related reconciliation, and validation of current, month-to-date, quarter-to-date, and year-to-date earnings and deductions.

Business Requirement

The customer needed a consolidated report that displayed employee earnings, earning hours, union information, and deduction details for a selected pay-period range. Users needed to enter the following runtime parameters:

  • Pay Period Start Date
  • Pay Period End Date

Based on the selected dates, the report had to retrieve the relevant employee payroll records and display only the predefined columns required by the business.

Without this customized report, the process would have involved:

  • Extracting employee payroll results for the required period
  • Retrieving earning amounts and hours separately
  • Identifying the associated union and deduction information
  • Retrieving current, MTD, QTD, and YTD balances
  • Combining the extracted data manually
  • Validating employee-level earnings and deductions
  • Preparing a consolidated report for payroll review

Solution Overview

DataTerrain developed the Pay Union Report in Oracle Fusion HCM to provide a structured employee-level payroll output for the selected period. When running the report, the user enters:

  • Pay Period Start Date
  • Pay Period End Date

The report retrieves payroll records within the selected pay-period range and combines employee, company, payroll group, earning, deduction, union, check-date, and location information for the set of union codes pre-filtered in the Extract.

The same report can be reused for different payroll periods without changing the underlying report logic.

Report Output

The report displays only the columns required by the customer.

Employee and Payroll Details

  • Field
  • Company/Legal Employer
  • PayGroup
  • Pay Period End
  • Employee ID
  • Name
  • GL Pay Type
  • Earning Hours
  • Earning Amount
  • Union Code
  • Deduction Code
  • Check Date
  • Location Code

Earnings Balances

  • Field
  • Current Amount Earnings
  • Current Hours Earnings
  • MTD Amount Earnings
  • MTD Hours Earnings
  • QTD Amount Earnings
  • QTD Hours Earnings
  • YTD Amount Earnings
  • YTD Hours Earnings

Deduction Balances

  • Field
  • Current Amount Deduction
  • MTD Amount Deduction
  • QTD Amount Deduction
  • YTD Amount Deduction

This structure gives payroll users both the payroll-period transaction details and the accumulated earnings and deduction balances in one output.

Understanding the Report Columns

Company and Employee Information

The report identifies the company, payroll group, employee ID, and employee name associated with each payroll record.

Payroll Period Information

The Pay Period End and Check Date columns help users identify the payroll period and payment date associated with the reported earnings and deductions.

Earnings Information

The report displays the employee's earning hours and earning amount together with the associated GL Pay Type. It also provides accumulated earnings values for different reporting periods:

  • Current
  • Month-to-Date
  • Quarter-to-Date
  • Year-to-Date

Both earning amounts and earning hours are available for these periods.

Union and Deduction Information

The report displays the Union Code associated with the employee's payroll record, together with the applicable deduction and code. Deduction balances are shown for:

  • Current Period
  • Month-to-Date
  • Quarter-to-Date
  • Year-to-Date

Location Information

The Location Code helps payroll users identify the employee's associated work or payroll location where that information is available in Oracle HCM.

Reporting Approach

The report can be developed using Oracle HCM Extracts because the requirement includes:

  • Requirement
  • Employee-level payroll data
  • Earnings and deduction results
  • Current, MTD, QTD, and YTD balances
  • Payroll hours and amounts
  • Runtime date-range filtering
  • Recurring report execution
  • Potentially high payroll-data volumes

HCM Extracts provides a scalable approach for retrieving payroll results and balances across multiple employees and payroll periods.

BI Publisher can be used with the HCM Extract to produce the final structured output with the required column sequence and business-friendly formatting.

Report Execution Flow

The report follows a straightforward execution process:

  1. An authorized user opens the Pay Union Report.
  2. The user enters the Pay Period Start Date.
  3. The user enters the Pay Period End Date.
  4. The report identifies payroll records within the selected period.
  5. Oracle HCM retrieves the employee and payroll details.
  6. Earnings, hours, deductions, union codes, and balance values are retrieved.
  7. Current, MTD, QTD, and YTD values are included in the output.
  8. The final report is generated in the required Excel format.

Data Flow

Input

  • Pay Period Start Date
  • Pay Period End Date

Source

  • Oracle Fusion HCM employee and assignment data
  • Payroll group and payroll-period data
  • Payroll run results
  • Earning and deduction elements
  • Payroll balances
  • Union Code
  • GL Pay Type
  • Check Date
  • Location Code

Processing

  • Pay-period date filtering
  • Union codes pre-filtered (this varies per customer)
  • Employee-level payroll-result retrieval
  • Earnings and earning-hours retrieval
  • Deduction retrieval
  • Current, MTD, QTD, and YTD balance retrieval
  • Union, GL Pay Type, and location mapping

Output

Structured Pay Union Report containing employee, earnings, hours, deductions, union, and accumulated balance information.

Security and Access Control

The Pay Union Report respects Oracle Fusion HCM role-based security. Users can access only the employee and payroll information permitted by their:

  • Security Profiles
  • Legislative Data Groups
  • Legal Employer Access
  • Payroll Security Roles
  • Data Access Roles

Because the report includes employee-level payroll, earnings, and deduction information, access should be restricted to authorized payroll, HR, finance, and compliance users.

Expected Business Impact

The Pay Union Report provides payroll users with a single, reusable source for reviewing union-related earnings and deductions across a selected pay-period range. Potential outcomes include:

  • Faster retrieval of union-related payroll information
  • Consolidated earnings, hours, and deductions in one report
  • Improved visibility into current, MTD, QTD, and YTD balances
  • Reduced manual combination of payroll extracts
  • Consistent report output across payroll periods
  • Faster employee-level payroll reconciliation
  • Reduced risk of spreadsheet errors
  • Improved support for payroll and union-related reviews

Actual time savings depend on the number of employees, payroll groups, earning elements, deduction elements, and payroll periods included in the report.

Typical Implementation Scope

Development of the Pay Union Report generally includes:

  • Requirements review
  • Confirmation of Pay Period Start Date and End Date logic
  • List of union codes expected to be filtered
  • Employee and payroll-field mapping
  • GL Pay Type mapping
  • Union Code mapping
  • Earning-element mapping
  • Deduction-element mapping
  • Current, MTD, QTD, and YTD balance mapping
  • Check Date and Location Code mapping
  • HCM Extract development
  • BI Publisher layout development
  • Payroll-result and balance reconciliation
  • Security validation
  • User acceptance testing
  • Production deployment and scheduling

Implementation effort depends on the number of payroll groups, earning and deduction elements, union codes, balance definitions, and historical payroll periods involved.

Organization-Specific Configuration

Every organization has different payroll groups, union codes, GL Pay Types, earning elements, deduction elements, locations, and balance definitions. The report can therefore be configured based on:

  • Pay-period date logic
  • Payroll group structure
  • GL Pay Type configuration
  • Union Code configuration
  • Earning and deduction elements
  • Current, MTD, QTD, and YTD balance definitions
  • Location Code mapping
  • Required output format
  • Security and data-access requirements

Conclusion

The Oracle HCM Pay Union Report provides a consolidated view of employee earnings, working hours, union information, and deductions for a user-selected pay-period range.

By accepting Pay Period Start Date and Pay Period End Date as runtime parameters, the report can be reused across payroll cycles without modifying the extraction logic.

The inclusion of current, month-to-date, quarter-to-date, and year-to-date earnings, hours, and deduction balances gives payroll users a comprehensive output for reconciliation and union-related payroll review.

DataTerrain designs, develops, and enhances Oracle HCM reports for payroll, tax, employee, benefits, compensation, absence, and other enterprise HR reporting requirements.

Need a Custom Oracle HCM Pay Union Report?

Whether you need union payroll reports, earnings and deduction reports, payroll balance reports, or custom Oracle HCM payroll reporting solutions, DataTerrain develops parameter-driven Oracle HCM reports that automate payroll validation, consolidate union-related payroll data, and improve reporting accuracy for payroll, finance, and compliance teams.

Talk to Our Oracle HCM Reporting Experts

Related Resources