| Industry | Higher Education |
| Organization | Creighton University |
| Platform | Oracle HCM Cloud |
| Challenge | Reports beyond the standard Oracle HCM set, with custom fields, parameters, layouts, and file delivery for HR, payroll, compensation, and benefits |
| Scope | 50+ reports enhanced, customized from prebuilt reports, or newly built, plus delivery configuration, HDL and HSDL data loads, and legacy PBL-to-HDL conversion |
| Approach | Requirements assessment, tool selection, development, validation, deployment, and knowledge transfer, delivered remotely with 24x7 global coverage |
CREIGHTON UNIVERSITY | HIGHER EDUCATION
Creighton University had implemented Oracle HCM Cloud to manage its human resources, compensation, and payroll operations. Its teams needed reporting beyond the platform's standard reports, including custom fields, user-defined parameters, tailored layouts, and file delivery to designated destinations.
The university engaged DataTerrain to enhance existing reports, adapt suitable prebuilt reports, and develop new reports where required. The engagement combined report development with delivery configuration, data-loading support, and knowledge transfer, and it also cleared a backlog of user requests and resolved issues affecting the university's use of Oracle HCM.
The university needed reporting solutions that reflected its business processes and could be used and maintained by its own teams:
Additional fields, filtering parameters, calculations, and layouts beyond what standard reports provide.
Report files in the right output formats, with delivery options including SFTP destinations.
A suitable approach for formatted reports, interactive analyses, and structured outbound extracts.
Accurate outputs, plus guidance for the users responsible for running and maintaining the reports.
Outstanding user requests and issues affecting the university's use of Oracle HCM needed to be cleared.
DataTerrain delivered the engagement in five stages, reusing suitable reporting assets where possible and building custom reports where standard ones were not enough.
DataTerrain documented fields, filters, calculations, layouts, and delivery destinations with university stakeholders. Domain experts advised users on alternatives where standard functionality was insufficient, reviewed reusable prebuilt reports, and consulted Oracle support through the university when needed.
Requirements were mapped to Oracle HCM, with BI Publisher for formatted reports and delivery, OTBI for interactive analyses and dashboards, and HCM Extracts for outbound data. The team designed Fast Formulas and value sets where applicable, documented previously unmapped flexfields, and extended an existing HCM Extract with additional columns to avoid creating a new extract unnecessarily.
The team enhanced existing reports, adapted suitable prebuilt reports, and built new reports with custom fields, parameters, layouts, and business logic. Examples included payroll payment changes audit reports, personal activity reports, salary reports by organization, 403(b) audit reports, and benefits setup reports.
DataTerrain configured report formats and SFTP delivery and scheduled extracts at defined frequencies. The team also created and ran HR and compensation data loads through HDL and HSDL, used translation formulas to automate legacy PBL-to-HDL file conversion, and corrected existing HDL template errors and data-load defects.
Reports were tested against agreed cases covering data, custom fields, parameters, layouts, and delivery, and university users validated them in test and production before handover. Documentation and knowledge transfer supported internal maintenance, while the global delivery team kept priority items moving around the clock to clear the reporting backlog.
Through report enhancement, new development, delivery automation, and knowledge transfer, DataTerrain gave Creighton University Oracle HCM reports and delivery options built around its own processes and internal support needs. With 17+ years and 400+ clients, DataTerrain brings Oracle HCM reporting depth and a global delivery model to every engagement.