In-depth guides to Oracle Fusion Cloud HCM tables, naming conventions, columns, and schema best practices.
What do _F, _TL, _VL, _ALL, _B, and _PEO suffixes mean in Oracle Fusion Cloud HCM tables? Learn the naming conventions that Oracle uses and how to pick the right table for your reports and integrations.
Everything you need to know about PER_ALL_PEOPLE_F, the most important table in Oracle HCM Cloud. Explore key columns, date-effective behavior, common joins, and real-world query examples.
A curated reference of the 50 most frequently used Oracle Fusion Cloud HCM tables across Core HR, Payroll, Benefits, Talent, and Recruiting modules. Includes descriptions and key column counts.
Pick the right OTBI subject area every time. Decision tree for common reporting needs, complete reference of 40+ subject areas across all HCM modules, and performance optimization tips.
Copy-paste Oracle Fusion Fast Formula examples for PTO accrual, overtime, benefits eligibility, payroll skip rules, and more. Includes syntax reference, DBI table, and debugging tips.
Complete guide to Oracle HCM Data Loader (HDL). Includes .dat file templates for Worker, Assignment, Salary, and more. Plus common errors and how to fix them.
Every lookup code you need: ACTION_TYPE, WORKER_TYPE, ASSIGNMENT_STATUS, PHONE_TYPE, MARITAL_STATUS, and 15+ more. Includes SQL queries to retrieve values programmatically.
Copy-paste SQL queries for Oracle Fusion HCM: active employees, headcount, turnover, new hires, contact directory, salary, and absence balances. All with proper date-effective joins.
Complete guide to Oracle Fusion HCM Absence Management tables, configuration, and SQL queries. Master absence plans, entitlements, accruals, and balance tracking with practical examples.
Complete guide to Oracle Fusion HCM REST API integration. Learn authentication, endpoints, error handling, and practical code examples for CRUD operations on HCM data.
Master Oracle Recruiting Cloud (ORC) tables and data model. Learn requisitions, candidates, applications, and interviews with practical SQL examples and reporting queries.
Master Oracle HCM Workforce Compensation tables: salary management, compensation plans, merit increases, and equity awards. Includes practical SQL examples and reporting queries.
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.
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.
Master the Oracle Fusion Payroll table schema: PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, element entries, balances, and cost allocations. Includes 8 production-ready SQL queries.