What is PER_ALL_PEOPLE_F in Oracle HCM?

PER_ALL_PEOPLE_F is the main table storing person records in Oracle HCM Cloud. It contains employee personal information including names, dates, and person types.

How do I find Oracle Fusion table columns?

Use HCM Tables search to instantly find columns across all Oracle Fusion tables. Search by column name like PERSON_ID or ASSIGNMENT_ID to see which tables contain that field.

What Oracle HCM tables are available?

Oracle HCM Cloud includes 35,000+ tables covering Core HR (PER_*), Payroll (PAY_*), Benefits (BEN_*), Talent Management, Recruiting, and more.

35,000+ Tables indexed

Oracle Cloud Tables

Instantly search Oracle Fusion Cloud schema documentation

HCM • Financials • SCM • CX Sales • Common Features

Try PER_ALL_PEOPLE_F or PERSON_ID

—

Tables

—

Views

—

Columns

—

Modules

Why use this instead of Oracle Docs?

Instant Search

Search across all tables and columns instantly. No navigating through nested dropdowns.

Column Search

Find which tables contain a specific column. Essential for building reports and integrations.

Cross-Module

Search across HCM, Financials, SCM, and more in one unified interface.

Fast & Clean

No bloated pages. Just the schema info you need, beautifully presented.

Popular Tables

PER_ALL_PEOPLE_F PER_ALL_ASSIGNMENTS_F PER_ADDRESSES_F HR_LOCATIONS_ALL PAY_PAYROLL_ACTIONS PAY_RUN_RESULTS_F HZ_PARTIES HZ_CUST_ACCOUNTS

Browse by Module

Join Path Finder

Enter two table names to find the JOIN columns between them.

↔

Results

Oracle HCM Consulting

Need Help Implementing Oracle HCM?

Connect with vetted Oracle HCM consultants. Get free quotes from implementation partners who specialize in your exact use case.

HCM Cloud implementations
Payroll & Benefits setup
Custom integrations & HDL
OTBI & reporting
Data migration & go-live support

Get Free Implementation Quotes →

Free to submit · No obligation · Responses in 24–48 hrs

FREE DOWNLOAD

Oracle HCM Schema Reference PDF

14,950 tables with key columns, suffixes, and module breakdown — formatted for offline reference. Free for implementers, consultants, and developers.

Get the PDF — Free →

We'll email it within 24 hours · No spam · Unsubscribe anytime

☕

Find this useful?

This tool is free forever. If it saved you time, consider buying me a coffee.

Support This Project

Pay what you want • $1.50 minimum