Oracle HCM Tables and Views: Which Reference Answers What?
Oracle HCM Tables and Views: Which Reference Answers What? The answer depends on whether you are documenting schema objects, building an integration, or re
Blog
59 articles
Why FF_FORMULAS_F Versioning Breaks Custom Fast Formula Logic in 2027
Why FF_FORMULAS_F versioning breaks custom Fast Formula logic comes down to one missed assumption: a formula ID or name does not identify one timeless defi
IRC_CANDIDATES vs PER_ALL_PEOPLE_F: tracking the applicant lifecycle in Oracle Fusion HCM tables (2026)
In 2026, your recruiting funnel does not “quietly” fill the database. It pours records into IRC_CANDIDATES, and if you do not control the join logic into P
PER_ALL_PEOPLE_F vs PER_ALL_ASSIGNMENTS_F: Which Drives Assignment Security? (Oracle Fusion HCM, 2026)
If your Oracle Cloud HCM security expectations feel “off by a lot” when you switch between PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, you’re not imagining
Understanding Oracle HCM PER_ALL_PEOPLE_F Table
Did you know that Oracle Fusion HCM Cloud has roughly 15,000 tables? Understanding Oracle HCM PER_ALL_PEOPLE_F Table is essential for accurate employee dat
PER_ALL_PEOPLE_F vs PER_ALL_ASSIGNMENTS_F: Mapping the Core Relationship in Oracle HCM Tables for Oracle Fusion Cloud HCM (2026)
When you’re building headcount, org reporting, or OTBI reporting logic on oracle fusion hcm, the biggest risk is assuming people and assignments are interc
PER_ALL_PEOPLE_F vs PER_ALL_ASSIGNMENTS_F: Which Drives Effective Dating? (Oracle Fusion HCM)
If your effective dating is “off,” your headcount math is usually off by architecture, not by intent. And here is the kicker: 9% of adults had used a datin
PER_ALL_PEOPLE_F vs PER_PERSON_NAMES_F: why name queries fail (Oracle Fusion HCM tables in 2026)
In 2026, we still see teams ship headcount and compliance extracts where the “name” they display is not the same person record you think you queried. That
How to Query Worker Data Using PER_ALL_PEOPLE_F Table: The Complete Oracle HCM Developer Guide
How to Query Worker Data Using PER_ALL_PEOPLE_F Table: The Complete Oracle HCM Developer Guide If you are building reports or writing SQL against Oracle Fusi...
Release 26A: Redwood Absence Management Schema Shifts Explained for HCM Developers
Release 26A: Redwood Absence Management Schema Shifts Explained for HCM Developers Release 26A: Redwood Absence Management Schema Shifts represent one of the...
20 ChatGPT Prompts for Oracle HCM That Actually Work (2026) | HCM Tables
20 tested ChatGPT and Claude prompts for Oracle Fusion HCM — OTBI queries, HDL error diagnosis, Fast Formula debugging, compliance reports, and more. Includes the schema context trick that makes AI 4x
30 Oracle HCM Data Quality Checks Before Your Next Migration or Audit | HCM Tables
30 SQL validation queries to run against Oracle HCM before any migration, audit, or go-live. Covers Core HR, Payroll, Absence, Compensation, and Recruiting tables with copy-paste SQL for each check.
7 Best Oracle HCM Alternatives in 2026 (With Honest Comparison) | HCM Tables
Tired of Oracle Fusion HCM complexity? Compare the 7 best Oracle HCM alternatives — BambooHR, Rippling, Workday, SAP SuccessFactors, UKG, Ceridian, and Paylocity — with pricing, migration tips, and ho
Best Oracle HCM Training Courses 2026 (Pluralsight, Udemy & More) | HCM Tables
The 8 best Oracle Fusion HCM training courses for 2026 — Pluralsight, Udemy, Oracle University, and LinkedIn Learning. Ranked by depth, hands-on labs, and value. Includes Oracle HCM certification prep
Build an Oracle HCM AI Assistant with Claude: System Prompt + Setup Guide (2026) | HCM Tables
How to configure Claude or ChatGPT as a private Oracle HCM AI assistant. Includes the exact system prompt for HDL errors, OTBI queries, and Fast Formula — tested against real Oracle HCM environments.
Complete Guide to PER_ALL_PEOPLE_F - Oracle HCM Person Table | HCM Tables
PER_ALL_PEOPLE_F is the most important Oracle HCM table. Learn its key columns, date-effective behavior, common joins, and real SQL query examples for reports and integrations.
HCM Data Loader (HDL) Complete Guide — .dat File Format, Templates & Troubleshooting | HCM Tables
Complete HCM Data Loader guide: .dat file format, METADATA lines, MERGE/DELETE operations, sample templates for new hire, termination, transfer, rehire, and mass updates. Troubleshooting common HDL er
HDL Error: Worker Assignment Not Found — Root Cause & Fix | HCM Tables
Fix the HDL 'Worker assignment not found' error in Oracle HCM Data Loader. Understand why assignment records fail validation and how to resolve PersonId, AssignmentNumber, and SourceSystemId mismatche
New to Oracle HCM? Write Your First Headcount Query (Step by Step) | HCM Tables
Step-by-step guide to writing your first Oracle HCM headcount SQL query. Covers PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M, date-effective joins, EFFECTIVE_LATEST_CHANGE, and common beginner mistakes.
OBIEE and OTBI Subquery Joins — Complete Guide with Logical SQL Examples | HCM Tables
Master OBIEE/OTBI subqueries and inline views. Learn when to use EXISTS, IN, scalar subqueries, and derived tables with Oracle HCM examples. Covers syntax, nQSError fixes, and the multi-dataset workar
OBIEE Assertion Failure: pCriteria != 0 — Root Cause & Fix | HCM Tables
Fix the OBIEE 'assertion failure pCriteria != 0' error. Covers root cause (multi-fact join), error codes E4T4O7MK and OPR4ONWY, and 4 copy-paste fixes for Oracle BI Server and OTBI.
OBIEE Federation & Subject Area Conflicts | HCM Tables
OBIEE federation and subject area conflicts explained. Learn common errors (nQSError 27002, 14025, 22024), RPD fixes for on-prem, and OTBI cloud workarounds using BI Publisher and Oracle Analytics Clo
OBIEE Logical SQL Join Syntax: Why LEFT JOIN Breaks and the Correct Patterns | HCM Tables
Standard SQL LEFT JOIN syntax fails in OBIEE Logical SQL — the BI Server resolves joins through the RPD, not your query. Learn the correct implicit join pattern, outer join syntax, FILTER() workaround
OBIEE nQSError 10058 — Column Not Found Fix | HCM Tables
Fix OBIEE nQSError 10058 'Column not found' error in OTBI and BI Publisher. Step-by-step guide with SQL examples, subject area validation, and debugging tips for Oracle HCM.
OBIEE nQSError 27002 — Syntax Error Fix | HCM Tables
Fix OBIEE nQSError 27002 'Near... Syntax error' in OTBI and BI Publisher. Learn the difference between logical SQL and physical SQL with step-by-step examples for Oracle HCM.
OBIEE nQSError 27042 — "At Most One Row Is Expected" Causes, Fixes & Diagnosis | HCM Tables
Fix OBIEE nQSError 27042 'At Most One Row Is Expected' errors. Covers initialization block fixes, scalar session variables, filter issues, and OTBI diagnostic steps with code examples.
OBIEE to Oracle Analytics Cloud Migration Guide 2026 | HCM Tables
Complete OBIEE to Oracle Analytics Cloud (OAC) migration guide for Oracle HCM. Covers breaking SQL changes, EVALUATE() workarounds, presentation variable differences, and a 4-week migration timeline.
OBIEE/OTBI Assertion Failure Errors — Causes, Fixes & SQL Examples | HCM Tables
Fix OBIEE and OTBI assertion failure errors fast. Covers nQSError 10058, nQSError 27002, column not found, syntax errors, and comma-join mistakes with copy-paste SQL fixes.
Oracle Absence Management Tables & Configuration Guide | HCM Tables
Complete guide to Oracle Fusion HCM Absence Management tables, configuration, and SQL queries. Master absence plans, entitlements, accruals with practical examples.
Oracle Fusion HCM Fast Formula Examples — Complete Guide with 10+ Working Formulas | HCM Tables
Working Oracle Fusion Fast Formula examples for payroll, absence, benefits, compensation, and extracts. Copy-paste formulas with syntax reference and debugging tips.
Oracle Fusion HCM Lookup Codes — Complete Reference Guide | HCM Tables
Complete reference of Oracle Fusion HCM lookup codes: ACTION_TYPE, ASSIGNMENT_STATUS, WORKER_TYPE, PERSON_TYPE, PHONE_TYPE, MARITAL_STATUS, and 15+ more lookup types with all valid values.
Oracle Fusion HCM OTBI Subject Areas — Complete Guide with Decision Tree | HCM Tables
Complete reference of Oracle Fusion HCM OTBI subject areas by module. Includes a decision tree for picking the right subject area, performance tips, and pitfall solutions.
Oracle Fusion Payroll Tables Complete Guide — PAY_ Schema & SQL | HCM Tables
Complete guide to Oracle Fusion Cloud Payroll tables. Covers PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, element entries, balances, and 8 production SQL queries.
Oracle Fusion Time and Labor Tables Complete Guide — HWM_ Schema & SQL | HCM Tables
Complete guide to Oracle Fusion Cloud Time and Labor tables. Covers HWM_TM_REP_TIMES, HWM_TM_TIME_CARDS, work schedules, timecard approval flow, and 6 production SQL queries for time reporting.
Oracle HCM + AI: 7 Problems AI Solves Right Now (2026 Guide) | HCM Tables
How AI is transforming Oracle Fusion HCM in 2026: AI-generated OTBI queries, HDL error debugging, patch readiness analysis, workforce forecasting, and the new wave of enterprise HR AI tools. Practical
Oracle HCM Benefits Tables & Configuration Guide — BEN_ Schema Deep Dive | HCM Tables
Complete guide to Oracle Fusion HCM Benefits tables. Covers BEN_PL_F, BEN_OPT_F, BEN_PRTT_ENRT_RSLT_F, plan types, enrollment flows, life events, and 10+ SQL queries for benefits reporting.
Oracle HCM Compliance Audit SQL Queries — 8 Production-Ready Scripts | HCM Tables
8 production-ready Oracle HCM compliance audit SQL queries: point-in-time headcount, termination reason audit, payroll variance, rehire detection, job change trail, absence balance audit, position aud
Oracle HCM HDL Integration Error Debugger — 3-Table Debug Chain | HCM Tables
Debug Oracle HCM Data Loader errors using the 3-table chain: HRC_INTEGRATION_BATCHES, HRC_INTEGRATION_DETAILS, HRC_INTEGRATION_ERROR_MESSAGES. Full SQL debug workflow covering 100% of HDL failure mode
Oracle HCM Implementation Cost 2026: Full Budget Breakdown | HCM Tables
Oracle Fusion HCM implementation cost by module, organization size, and consultant type. Includes consultant rates ($150–$500/hr), timeline ranges, hidden costs, and how to reduce your budget.
Oracle HCM Performance Management Tables Complete Guide | HCM Tables
Master Oracle HCM Performance Management tables (HRA_*): appraisals, goals, rating models, 360 feedback with practical SQL examples for Fusion reporting.
Oracle HCM Person vs Assignment vs Work Relationship Data Model Explained | HCM Tables
Master Oracle Fusion HCM's core data model: Person, Assignment, and Work Relationship entities. Learn the differences, relationships, and when to use each table with practical SQL examples.
Oracle HCM REST API Integration Guide: Authentication, Endpoints & Examples | HCM Tables
Complete guide to Oracle Fusion HCM REST API integration. Learn authentication, endpoints, error handling, and practical code examples for CRUD operations on HCM data.
Oracle HCM SOX Audit SQL Queries — 8 Compliance-Ready Scripts | HCM Tables
8 production-ready Oracle HCM SQL queries for SOX compliance: segregation of duties, privileged access review, payroll control validation, role change audit trail, and period-end headcount certificati
Oracle HCM SQL Query Library — 7 Production-Ready Queries | HCM Tables
Copy-paste SQL queries for Oracle Fusion HCM: active employees, headcount, turnover, new hires, contact directory, salary report, absence balances. Production-tested with proper date-effective joins.
Oracle HCM Table Suffixes Explained (_F, _TL, _VL, _ALL) | HCM Tables
What do _F, _TL, _VL, _ALL, _B, and _PEO suffixes mean in Oracle Fusion Cloud HCM tables? Complete guide with examples, use cases, and tips for choosing the right table.
Oracle HCM to Rippling Migration Guide 2026: Step-by-Step | HCM Tables
How to migrate from Oracle Fusion HCM to Rippling in 2026. Exact tables to extract (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M), data mapping, timeline, costs, and what to watch out for.
Oracle HCM vs BambooHR 2026: Mid-Market HRIS Comparison | HCM Tables
Oracle Fusion HCM vs BambooHR 2026 — honest comparison for mid-market companies. Implementation cost, ease of use, reporting, payroll depth, and which platform is right for your size.
Oracle HCM vs SAP SuccessFactors 2026: Enterprise Comparison | HCM Tables
Oracle Fusion HCM vs SAP SuccessFactors 2026 — honest comparison of implementation cost, payroll, talent management, reporting, and total cost of ownership. Written by Oracle HCM schema experts.
Oracle HCM vs Workday 2026: Head-to-Head Enterprise Comparison | HCM Tables
Oracle Fusion HCM vs Workday HCM 2026 — deep comparison of implementation cost, reporting, payroll, integrations, and total cost of ownership. Written by Oracle HCM schema experts.
Oracle Recruiting Cloud Tables and Data Model Complete Guide | HCM Tables
Master Oracle Recruiting Cloud (ORC) tables and data model. Learn requisitions, candidates, applications, interviews with practical SQL examples and reporting queries.
Oracle Workforce Compensation Tables Complete Guide | HCM Tables
Master Oracle HCM Workforce Compensation tables: salary management, compensation plans, merit increases, equity awards with practical SQL examples and reporting queries.
OTBI Calculated Fields & Custom Expressions — Complete Guide with Examples | HCM Tables
Master OTBI calculated fields in Oracle HCM Cloud. Covers CASE/WHEN, date math, TIMESTAMPDIFF, CAST, CONCAT, conditional logic, and 15+ real-world expression examples for HR reporting.
OTBI Comma Join Explained: Why Your Oracle Reports Return Too Many Rows | HCM Tables
The OTBI comma join is the #1 cause of inflated row counts in Oracle HCM reports. Learn what it is, why it happens, and the exact Logical SQL fix with before/after examples.
OTBI vs BI Publisher: When to Use Which for Oracle HCM Reporting | HCM Tables
OTBI and BI Publisher serve different reporting needs in Oracle HCM Cloud. This guide explains the architecture, use cases, and decision criteria for choosing the right tool for every report.
PER_ALL_ASSIGNMENTS_F in Oracle 24B: What Changed and How to Migrate | HCM Tables
Oracle 24B shifted HCM reporting best practices away from PER_ALL_ASSIGNMENTS_F toward PER_ALL_ASSIGNMENTS_M. Learn what changed, why your OTBI reports may break, and the exact SQL migration patterns
PER_ALL_ASSIGNMENTS_M Duplicate Rows — The Definitive Fix | HCM Tables
PER_ALL_ASSIGNMENTS_M returns multiple rows per employee? Here's the exact fix: EFFECTIVE_LATEST_CHANGE = 'Y'. Covers all root causes, SQL patterns, and OTBI report fixes with working examples.
PER_ALL_ASSIGNMENTS_M: Why Your Query Returns Multiple Rows Per Employee | HCM Tables
Fix Oracle Fusion HCM PER_ALL_ASSIGNMENTS_M queries returning 10, 15, or 20 rows per employee. Understand effective-dated rows, assignment types, and the exact WHERE clause filters to get one current
Top 50 Most Used Oracle Fusion HCM Tables (2026) | HCM Tables
The 50 most frequently used Oracle Fusion Cloud HCM tables across Core HR, Payroll, Benefits, Talent, and Recruiting. Each table with module, type, and description.
Why AI Tools Fail at OBIEE SQL — 5 Syntax Traps and How to Fix Them | HCM Tables
ChatGPT, Claude, and Copilot write standard SQL — not OBIEE Logical SQL. Learn the 5 syntax traps that break AI-generated OBIEE queries and the correct patterns for Oracle HCM reporting.