The University of Alabama at Birmingham

Oracle HR - Reports on Demand

Running Reports in Oracle HR & Finance

Ad hoc (on demand) reports are available on an as needed basis when using the UAB HR Officer Responsibility. The chart below lists the report names as they appear in the Run Reports > Submit Processes > Submit Request LOV, as well as the report format and output location. Click on the report name for instruction on setting report parameters and further explanation of the report you wish to generate.

Reports Available on Demand

Report Name

Report Description

Delivery Location

Delivery Format

ADMUAB Report Responsibilities RPTADM100Identifies the access responsibilities set up in Oracle based on one of three parameters: by Organization, by Responsibility, or by Person. This report is available under the UAB HR Officer responsibility.View OutputPDF
HRUAB ACT Docs Transaction ReportThe HR ACT DOCS TRANSACTION REPORT provides detailed information on ACT transactions in “Complete” status as of the run date of the report. This report includes: select Person Data information, transactional Assignment/Salary information, and Element Payments as they appeared on the ACT transaction.UAB Report ViewerExcel
HRUAB ACT Hire Docs in ProgressThe ACT HIRE DOCS IN PROGRESS REPORT is a listing of all ACT Hire Type Documents (to include: New Hire, Rehire and New Trainee) currently in OPEN, READY, or USER_APPROVED status as of the date the report is generated.EmailExcel
HRUAB ACT Term Docs CompletedThe ACT TERM DOCS COMPLETED REPORT is a listing of all ACT Termination Type Documents (TERMINATE EMPLOYEE, END A TRAINEE and END A VOLUNTEER) with a document effective date within a selected period of time. Only termination type documents with a document status of “Complete” will display on the report.EmailExcel
HRUAB Ad Hoc Supervisor ReportThe HRUAB Ad Hoc Supervisor Report provides a listing of employee assignment and position along with supervisor information which includes name, assignment, status, and org.
UAB Report ViewerExcel
HRUAB Basic ReportA basic HR report that includes some commonly requested HR data fields. Available on-demand to all users with the HR Officer responsibility. This report returns active, primary assignments only.UAB Report ViewerExcel
HRUAB Employees Assignment Level Details Report
This report returns a listing of employee assignments based on parameters selected as of the selected effective day of the report.

HRUAB Employee Assignment Salary History Details

NEW - Description coming soon!UAB Report Viewer
HRUAB Employee End Date Reminder Adhoc Report

The HR UAB EMPLOYEE END DATE REMINDER AD HOC REPORT is a listing of employees with an expired assignment end date or a pending assignment end date.
Employees are returned based on the org security of the HR Officer responsibility under which the report is generated. Expired end dates are as of the report RUN DATE and pending end dates are projected 45 days in advance of the report RUN DATE. The assignment end date is available in ACT in the PROJECTED LAST DAY OF WORK field on the TERMINATION TAB of the PERSON DATA form.
UAB Report Viewer
HRUAB Ludicrous Report

The HRUAB LUDICROUS REPORT provides detailed information for employees in a specified organizational unit as of the run date of the report. This everything but the kitchen sink report has over 80 data fields which includes Person Data, Assignment, Salary, and basic Faculty Appointment (where available) information, as it appears in the person’s Oracle employment record. This report is available to HR Org Admins ONLY.UAB Report ViewerExcel
HRUAB Program NO PAY REPORT FOR 04s AND 06s - (Excel) PKGHR126The HRUAB 04 06 NO PAY REPORT provides a list of active 04 Irregular Part-Time and 06 Student employees within an organization that have not been compensated through UAB Payroll Services within the specified period of time. The purpose of this report is to assist organizations in identifying assignments that could potentially be “ended” or “terminated” via an ACT document due to no payroll activity.UAB Report ViewerExcel
HRUAB Program Voluntary Faculty Staff Appointments PKGHR124The HRUAB PROGRAM VOLUNTEER FACULTY STAFF APPOINTMENTS REPORT provides a list of individuals with an “active” 60-Volunteer assignment within an organization as of the report effective date. Data in report also identifies whether individual has active faculty appointment. The purpose of this report is to assist organizations in identifying volunteer assignments that could potentially be “ended” via an ACT document.UAB Report ViewerExcel
HRUAB Report UAB Report Internal Organizations RPTHR516The UAB INTERNAL ORGANIZATION REPORT is a listing of all internal organizations by Name, Organization Number, HR Contact and Phone Number, DEO and DEO Phone Number.View OutputPDF
HRUAB University Departmental Position SummaryThe HRUAB UNIVERSITY DEPARTMENTAL POSITION SUMMARY REPORT is designed to be used by UAB University Organizations; it provides a listing of all active and frozen positions in the Oracle HR Administrative System as of a defined date.UAB Report ViewerExcel
LDUAB Program Assignment Level Labor Distribution Report PKGLD089The ASSIGNMENT LEVEL LABOR DISTRIBUTION REPORT provides a listing of the current assignment labor distributions for an organization’s employees. The report information is current as of the day the report request is submitted.UAB Report ViewerExcel
LDUAB Report Cumulative Salary Status RPTLDCSSRThe CUMULATIVE SALARY STATUS REPORT is a cumulative listing of salary entries for individuals who are required to certify effort provided directly or indirectly to sponsored programs. Included on this report are the monthly payroll salary entries and salary adjustments made by departments pertaining to the designated quarter. The purpose of this report is to assist departments with monitoring activities ultimately related to the certification of an effort report.View OutputPDF
PRUAB Departmental Secondary Assignment Details ReportThe PRUAB DEPARTMENTAL SECONDARY ASSIGNMENT DETAILS REPORT, based upon the end users HR Organizational Hierarchy, provides a listing of employees/trainees with active non-exempt secondary assignments. Assignment detail and supervisor information, for each active assignment, is included on the report. This report is designed to assist Timekeepers in identifying employees/trainees with active non-exempt secondary assignments outside of the end users HR Organizational access in order to determine appropriate timekeeping procedures.UAB Report ViewerExcel
PRUAB Report Position Hospital RPTPR210The POSITION HOSPITAL CONTROL REPORT is for use by UAB Hospital/LLC Organizations only; it provides a listing of the current UAB Hospital Position Strings along with the mirrored LLC Position Strings. The POSITION HOSPITAL CONTROL REPORT also provides Oracle HR Data on the employees occupying the UAB Hospital/LLC Position Strings.UAB Report ViewerExcel
WFUAB Report Workflow Officer by Organization Report ALL RPTWF151The WF UAB REPORT WORKFLOW OFFICE BY ORGANIZATION REPORT ALL report displays a list of all workflow officers per Organization. The parameters are submitted based on default values. The report will display Organization Number, Organization Name, and Workflow Officer.View OutputPDF
WFUAB Report Workflow Officer by Organization RPTWF150A report can be generated to identify the Approvers set up in Oracle based on one of two parameters: by Organization and by Workflow Officer. This report is available under the UAB HR Officer responsibility. The report will display Workflow Officer, Approvers, and Notify Person for specified Organization and all Document Types (HR & FN), along with threshold approval amounts for FN Documents.View OutputPDF
Inflight ACT Documents Department ReportReport coming soon!

∎ End of article | Modified on: Thu, 25 Jan, 2024 at 3:03 PM

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.