Oracle EBS Human Resources Reports

15 ready-to-run SQL reports for Oracle E-Business Suite Human Resources, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Human Resources tables in these reports are per_all_assignments_f, hr_all_organization_units_vl, hr_locations_all, per_all_people_f, per_jobs_vl, per_grades_vl.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Human Resources SQL Reports

Report Description
PER Employee Absences Employee absence and attendance records showing absence type, category, dates, duration in days and hours, reason, authorizing person, replacement person, and…
PER Employee Assignments Master data report showing the employee demographic information including name, gender SSN, birthdate, age, nationality, effective start date, and additional…
PER Employee Contacts and Dependents Employee contact relationships including dependents, beneficiaries, and emergency contacts. Shows contact person details (name, phone, email, address)…
PER Employee Grade Changes List of employees with their grade changes.
PER Employee Length of Service Active employees with calculated length of service in years and months, based on the adjusted service date (or hire date if not set). Shows milestone years…
PER Employee Salary Change Query to get the last Salary change details for employees. Can add: whether to look at just the recent salary change? or salary change history…. If yes, then…
PER Headcount by Organization Active employee and contingent worker headcount summarized by business group, organization, location, job, grade, and employment category. Includes gender…
PER Information Type Security  
PER Jobs and Positions Positions valid at the Effective Date with their job, organization, status, valid grades, FTE, maximum persons, headcount and incumbent FTE, plus the jobs that…
PER New Hires Employees hired within a specified date range, showing hire date, organization, job, position, grade, location, supervisor, employment category, and probation…
PER Organization Hierarchy Master data report showing hierarchical list of human resource organization structures including subordinate orgs.
PER Organizations Master data report showing organizations, classifications, address details and additional information attributes.
PER Position Hierarchy Position hierarchy showing the reporting structure of positions with hierarchy level, organization, job, grade, location, budgeted vs actual headcount, vacancy…
PER Security Profiles Security profiles and operating units that they give access to.
PER Terminations and Separations Terminated employees within a specified date range, showing termination date, leaving reason, length of service, last organization, job, position, grade, and…

← All Oracle EBS modules

© Enginatics GmbH