Introduction
In Oracle Fusion HCM, understanding workforce metrics is critical for HR reporting, workforce planning, and compliance. One such important concept is the FTE (Full-Time Equivalent) and how it is stored and derived from the FTE table in Oracle Fusion HCM.
In real implementations, consultants often face questions like:
- “Why is headcount different from FTE?”
- “How do we extract FTE for reporting?”
- “Which table stores FTE values?”
This blog provides a deep, implementation-level understanding of the FTE table in Oracle Fusion HCM, including technical details, table structures, and real-world usage.
What is FTE Table in Oracle Fusion HCM?
FTE (Full-Time Equivalent) represents the ratio of an employee’s working hours compared to a full-time schedule.
- 1.0 FTE → Full-time employee
- 0.5 FTE → Half-time employee
- 0.25 FTE → Quarter-time employee
In Oracle Fusion HCM, FTE is not stored in a single isolated table. Instead, it is derived and stored across key tables such as:
| Table Name | Description |
|---|---|
| PER_ALL_ASSIGNMENTS_M | Stores assignment details including FTE |
| PER_ASSIGN_WORK_MEASURES_F | Stores work measures like FTE, headcount |
| PER_WORK_MEASURES | Defines types of measures (FTE, Headcount) |
👉 The most critical table for FTE is:
- PER_ASSIGN_WORK_MEASURES_F
Key Features of FTE in Oracle Fusion HCM
1. Dynamic Workforce Measurement
FTE is calculated based on:
- Working hours
- Standard hours
- Assignment type
2. Effective Dating Support
All FTE values are:
- Date-effective
- Historical tracking enabled
3. Multiple Assignments Support
An employee can have:
- Multiple assignments
- Different FTE values per assignment
4. Integration with Reporting Tools
FTE is used in:
- OTBI reports
- BI Publisher
- Workforce analytics dashboards
Real-World Business Use Cases
Use Case 1: Workforce Planning
A global company wants to track:
- Actual headcount = 100 employees
- Actual FTE = 85
This indicates:
- Many employees are part-time
👉 HR uses FTE instead of headcount for accurate planning.
Use Case 2: Budget Allocation
Finance allocates salary budgets based on FTE:
- Full-time → 100% budget
- Part-time → Pro-rated budget
👉 Payroll and finance integration depends heavily on FTE values.
Use Case 3: Compliance Reporting
In some countries, labor laws require:
- Reporting FTE instead of headcount
Example:
- Government compliance requires workforce strength in FTE terms.
Architecture / Technical Flow of FTE
FTE calculation and storage flow:
- Assignment Created
- Work hours defined
- Standard working hours defined
System calculates FTE:
FTE = Assignment Hours / Standard Hours- Value stored in:
- PER_ASSIGN_WORK_MEASURES_F
Key Tables and Columns for FTE
1. PER_ASSIGN_WORK_MEASURES_F
This is the primary FTE table.
| Column Name | Description |
|---|---|
| ASSIGNMENT_ID | Employee assignment |
| UNIT | Type (FTE / HEADCOUNT) |
| VALUE | FTE value (e.g., 1, 0.5) |
| EFFECTIVE_START_DATE | Start date |
| EFFECTIVE_END_DATE | End date |
👉 Important:
- UNIT = ‘FTE’ → identifies FTE records
2. PER_ALL_ASSIGNMENTS_M
Contains assignment-level FTE reference.
| Column | Description |
|---|---|
| FTE | Derived FTE value |
| NORMAL_HOURS | Working hours |
3. PER_WORK_MEASURES
Defines measure types:
| Column | Description |
|---|---|
| WORK_MEASURE_ID | Measure ID |
| NAME | FTE / Headcount |
Configuration Overview
Before FTE works correctly, the following setups must be configured:
- Work Schedules
- Standard Working Hours
- Assignment Types
- Employment Models (Full-time / Part-time)
Step-by-Step Configuration in Oracle Fusion
Step 1 – Define Work Schedules
Navigation:
Navigator → Setup and Maintenance → Manage Work Schedules
- Define:
- Working days
- Daily hours
Step 2 – Define Standard Working Hours
Navigation:
Navigator → Setup and Maintenance → Manage Legal Entity
- Set:
- Standard hours (e.g., 40 hours/week)
Step 3 – Create Employee Assignment
Navigation:
Navigator → My Client Groups → Hire an Employee
Enter:
- Working hours = 20
- Standard hours = 40
👉 System calculates:
- FTE = 0.5
Step 4 – Validate FTE Storage
Run SQL:
FROM PER_ASSIGN_WORK_MEASURES_F
WHERE UNIT = ‘FTE’;
Testing the FTE Setup
Test Scenario
- Employee working: 30 hours/week
- Standard hours: 40 hours/week
Expected Result
- FTE = 0.75
Validation Steps
- Check UI:
- Assignment screen → FTE field
- Check backend:
- PER_ASSIGN_WORK_MEASURES_F.VALUE = 0.75
Common Implementation Challenges
1. Incorrect FTE Calculation
Cause:
- Missing standard hours setup
Solution:
- Verify legal employer configuration
2. FTE Not Updating
Cause:
- Assignment changes not saved
Solution:
- Ensure effective-dated updates
3. Reporting Mismatch
Cause:
- Using PER_ALL_ASSIGNMENTS_M instead of work measures table
Solution:
- Always use:
- PER_ASSIGN_WORK_MEASURES_F for accurate reporting
4. Multiple Assignments Confusion
Scenario:
- Employee has 2 assignments:
- 0.5 + 0.5
👉 Total FTE = 1.0
Solution:
- Aggregate at person level
Best Practices
1. Always Use Work Measures Table for Reporting
Do not rely only on assignment table.
2. Maintain Standard Hours Consistently
Different legal entities should have:
- Clearly defined working hours
3. Validate Effective Dates
FTE is date-sensitive:
- Always check start and end dates
4. Use OTBI Subject Areas Carefully
Recommended:
- Workforce Management – Worker Assignment Real Time
5. Build Reusable SQL Views
Example:
pawmf.value AS FTE
FROM per_all_assignments_m paam,
per_assign_work_measures_f pawmf
WHERE paam.assignment_id = pawmf.assignment_id
AND pawmf.unit = ‘FTE’;
Frequently Asked Questions (FAQs)
1. Where is FTE stored in Oracle Fusion HCM?
FTE is primarily stored in:
- PER_ASSIGN_WORK_MEASURES_F table
It can also be referenced in PER_ALL_ASSIGNMENTS_M.
2. How is FTE calculated in Oracle Fusion?
FTE is calculated as:
Assignment Working Hours ÷ Standard Working Hours
Example:
- 20 / 40 = 0.5 FTE
3. Why is FTE different from headcount?
- Headcount = Number of employees
- FTE = Equivalent full-time workforce
Example:
- 2 part-time employees (0.5 each) = 1 FTE
Expert Consultant Tips
- Always validate FTE during data migration (HDL loads)
- Use FTE carefully in integration scenarios with payroll systems
- When building BI reports, filter:
- UNIT = ‘FTE’
- For global implementations:
- Align FTE definitions across countries
Summary
The FTE table in Oracle Fusion HCM is a critical component for workforce analytics, planning, and reporting. While many assume FTE is stored directly in assignment tables, the real source of truth is:
- PER_ASSIGN_WORK_MEASURES_F
Understanding how FTE is:
- Calculated
- Stored
- Retrieved
…is essential for any Oracle HCM consultant working on reporting, integrations, or workforce planning.
For deeper reference, consult Oracle documentation:
https://docs.oracle.com/en/cloud/saas/index.html