At a Glance
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

Custom Oracle HCM Reporting and Automated Delivery for Creighton University

Customer Background

Oracle HCM Cloud at Creighton University

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 Challenge

Reporting That Fits University Processes

The university needed reporting solutions that reflected its business processes and could be used and maintained by its own teams:

Reporting Flexibility

Additional fields, filtering parameters, calculations, and layouts beyond what standard reports provide.

Operational Delivery

Report files in the right output formats, with delivery options including SFTP destinations.

Tool Selection

A suitable approach for formatted reports, interactive analyses, and structured outbound extracts.

Validation and Ownership

Accurate outputs, plus guidance for the users responsible for running and maintaining the reports.

Request Backlog

Outstanding user requests and issues affecting the university's use of Oracle HCM needed to be cleared.

Our Approach

Five-Stage Delivery from Requirements to Handover

DataTerrain delivered the engagement in five stages, reusing suitable reporting assets where possible and building custom reports where standard ones were not enough.

1
Requirements Assessment and Advisory Support

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.

2
Report Design and Tool Selection

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.

3
Report Customization and Development

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.

4
Delivery Configuration and Data Operations

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.

5
Validation, Deployment, and Knowledge Transfer

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.

Technology landscape

Reporting Needs Mapped to Oracle HCM Tools

Reporting Requirement Custom reports, layouts, and parameters
Technology and Solution BI Publisher for formatted reports
Reporting Requirement Interactive dashboards and filters
Technology and Solution OTBI for analyses and visualizations
Reporting Requirement Scheduled weekly and monthly extracts
Technology and Solution HCM Extracts for larger recurring data extraction
Reporting Requirement Report delivery to designated locations
Technology and Solution SFTP for file delivery
Reporting Requirement Legacy PBL file conversion
Technology and Solution Translation formulas for automated HDL file creation
Reporting Requirement HR and compensation data loading
Technology and Solution HDL and HSDL for data loading
Results & Outcomes

Outcomes the University Can Use and Maintain

Reporting Backlog Cleared

DataTerrain cleared outstanding user requests and delivered reports aligned with the university's HR, payroll, compensation, and benefits needs.

Scheduled Delivery and Automation

Periodic extract schedules, SFTP delivery, and automated PBL-to-HDL conversion supported the university's reporting and data workflows.

Reuse and Internal Ownership

Extending existing extracts avoided unnecessary duplication, and documented mappings and knowledge transfer helped internal teams use and maintain the reports.

24x7 Global Delivery

A remote-first global team kept priority items moving around the clock.

Bottom Line

Why Choose DataTerrain

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.

"The University is pleased to partner with DataTerrain for HCM reporting, extracts, HDL and configuration assistance. DT'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." Creighton University
Higher Education