PER Employee Contacts and Dependents – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Employee contact relationships including dependents, beneficiaries, and emergency contacts. Shows contact person details (name, phone, email, address), relationship type, and flags for dependent, beneficiary, emergency contact, and third party payment. Useful for benefits administration, emergency preparedness, and employee records management.

Report Parameters

Business Group, Employee Name, Relationship Type, Organization

Oracle EBS Tables Used

per_phones, hr_all_organization_units_vl, per_all_people_f, per_contact_relationships, per_all_assignments_f, hr_locations_all, per_addresses, fnd_territories_vl

Report Categories

Enginatics

PER Employee Assignments, AP Supplier Upload, AR Customer Upload

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output None
Blitz Report™ XML Import PER_Employee_Contacts_and_Dependents.xml
Full SQL on Enginatics www.enginatics.com/reports/per-employee-contacts-and-dependents/

© 2026 Enginatics