At a Glance
Industry Higher education
Organization A leading private university
Platform Oracle HCM Cloud
Challenge Reports beyond the standard Oracle HCM set, with custom fields, parameters, layouts, and SFTP delivery for HR, payroll, compensation, and benefits
Scope Report enhancement, prebuilt report customization, custom report development, and delivery configuration with BI Publisher, OTBI, and HCM Extracts, plus HDL and HSDL data loading and legacy PBL to HDL conversion
Approach Requirements assessment, tool selection, development, validation, deployment, and knowledge transfer

A LEADING PRIVATE UNIVERSITY | HIGHER EDUCATION

Custom Oracle HCM Reporting and Automated Delivery for a Leading Private University

Customer Background

Oracle HCM Cloud at a Leading Private University

An established private university had implemented Oracle HCM Cloud to manage its human resources, compensation, and payroll operations. The standard reports in the Oracle HCM platform did not fully meet its specific reporting and operational requirements.

The university engaged DataTerrain for Oracle HCM reporting support, including enhancing existing reports, developing custom reports, and configuring report delivery options aligned with its business processes. The engagement also covered HCM data loading support and knowledge transfer to the university's internal teams.

The Challenge

Reporting that Fits University Processes

The university's HR and payroll teams needed more flexibility than standard Oracle HCM reports provided, along with solutions their internal teams could use and maintain:

Reporting Flexibility

Users needed additional custom fields, user-defined parameters, calculations, and tailored layouts beyond standard Oracle HCM reporting functionality.

Operational Delivery

Report files had to reach intended destinations in the required output formats, including delivery to an SFTP location.

Appropriate Tool Selection

The right Oracle HCM reporting tool was needed for each use case, whether formatted reports, interactive analyses, or structured outbound extracts.

Validation and Ongoing Ownership

The university needed validated report outputs and support in preparing internal teams to run and maintain the reports.

Our Approach

A Five-stage Delivery from Requirements to Handover

DataTerrain delivered the engagement in five stages, combining reuse of suitable reporting assets with custom report development.

1
Requirements Assessment and Advisory Support

DataTerrain worked with university stakeholders to document the required data fields, filtering parameters, calculations, report layouts, and delivery destinations. The team recommended alternatives where standard functionality fell short and reviewed its prebuilt Oracle HCM report repository for reports that could be adapted.

2
Report Design and Tool Selection

The team mapped reporting requirements to the Oracle HCM data model and selected the appropriate tool for each use case. BI Publisher (Oracle Analytics Publisher) supported custom data models, formatted layouts, parameters, and file delivery; OTBI (Oracle Transactional Business Intelligence) supported interactive analyses and dashboards with user-selectable filters; and HCM Extracts supported structured data extraction and file-based outbound requirements. The design addressed both report content and how users would access or receive the output.

3
Report Customization and Development

DataTerrain enhanced existing reports, customized suitable prebuilt reports, and developed new reports wherever required, adding custom fields, report parameters, modified layouts, and business-specific reporting logic. Reports spanned HR, payroll, compensation, and benefits, including payroll audit reports, salary reports by organization, and benefits setup reports.

4
Delivery Configuration and Data Operations

DataTerrain configured report output formats and delivery settings, including SFTP delivery of report files to designated locations. Alongside the reporting work, the team supported HR and compensation data loading using HCM Data Loader (HDL) and HCM Spreadsheet Data Loader (HSDL), and converted legacy PBL files to HDL format.

5
Validation, Deployment, and Knowledge Transfer

University users validated reports against agreed test cases covering data, custom fields, parameters, layouts, and delivery. After user acceptance, the team deployed reports to production and delivered documentation and knowledge-transfer sessions to enable internal teams to run and maintain them.

Technology landscape

Reporting needs mapped to Oracle HCM tools

Reporting Requirement Custom reports, layouts, and parameters
Technology and Solution BI Publisher for formatted reports and file delivery
Reporting Requirement Interactive dashboards and filters
Technology and Solution OTBI for interactive analyses and dashboards
Reporting Requirement Structured outbound data files
Technology and Solution HCM Extracts for structured data extraction
Reporting Requirement Report delivery to designated locations
Technology and Solution SFTP for report file delivery
Reporting Requirement Legacy PBL file conversion
Technology and Solution Legacy PBL files converted to HDL format
Reporting Requirement HR and compensation data loading
Technology and Solution HDL and HSDL for data-loading processes
Results & Outcomes

Outcomes Universities Can Use and Maintain

Reports Aligned with University Needs

Custom fields, parameters, and layouts gave users Oracle HCM reporting outputs suited to their HR, compensation, payroll, and benefits processes.

Delivery Suited to Business Workflows

SFTP report delivery and configured output formats ensured report files reached their intended destinations, supported by HDL and HSDL data-loading work.

Right Tool for Each Need

Matched BI Publisher, OTBI, and HCM Extracts to formatted reports, interactive analysis, and outbound data across four functional areas.

Reuse and Internal Ownership

Customizing existing and prebuilt reports focused development effort where it was needed, and documentation and knowledge transfer equipped internal teams to use and maintain the reports.

Bottom Line

Why Choose DataTerrain

DataTerrain helped the university extend its Oracle HCM implementation with reporting capabilities tailored to its operational needs. By combining report customization, new report development, delivery configuration, and knowledge transfer, the engagement addressed requirements beyond the platform's standard reports. With 17+ years and 400+ clients, DataTerrain brings Oracle HCM reporting depth and a structured delivery process to every engagement.

"The University is pleased to partner with DataTerrain for HCM reporting, extracts, HDL, and configuration assistance. DataTerrain's approach of a dedicated resource billed at an attractive fixed monthly cost keeps us on budget. If we need something outside our assigned resource's area of expertise, DataTerrain has a deep bench of in-house expertise upon which to draw. Highly recommended." A Leading Private University
Higher Education