| 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
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 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:
Users needed additional custom fields, user-defined parameters, calculations, and tailored layouts beyond standard Oracle HCM reporting functionality.
Report files had to reach intended destinations in the required output formats, including delivery to an SFTP location.
The right Oracle HCM reporting tool was needed for each use case, whether formatted reports, interactive analyses, or structured outbound extracts.
The university needed validated report outputs and support in preparing internal teams to run and maintain the reports.
DataTerrain delivered the engagement in five stages, combining reuse of suitable reporting assets with custom report development.
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.
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.
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.
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.
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.
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.