29 articles
Fix OBIEE and OTBI federation errors when combining data from multiple subject areas. Covers nQSError 27002, grain conflicts, BI Publisher data model workarounds, and the right way to join Workforce + Absence data in Oracle HCM.
Write inline views, correlated subqueries, and scalar subqueries in OBIEE Logical SQL. Covers EXISTS/NOT EXISTS patterns, mandatory alias rule, RANK() window functions, and 4 production HCM examples for headcount, payroll, and absence reporting.
Fix nQSError 27042 in OBIEE and OTBI — "at most one row is expected in the result set." Covers initialization block SQL returning multiple rows, FETCH FIRST fix, MAX() aggregation, LISTAGG for multi-value variables, and BI Server log diagnosis.
PER_ALL_ASSIGNMENTS_M returns multiple rows per employee? The fix is EFFECTIVE_LATEST_CHANGE = 'Y'. Covers all 4 root causes, SYSDATE vs EFFECTIVE_LATEST_CHANGE comparison, production SQL patterns, and OTBI duplicate row fixes.
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 more accurate.
How AI is transforming Oracle Fusion HCM in 2026: AI-generated OTBI queries, HDL error debugging, patch readiness analysis, and the new wave of enterprise HR AI tools. Practical guide for Oracle HCM implementers.
Debug Oracle HCM Data Loader errors with the complete 3-table chain: HRC_INTEGRATION_BATCHES, HRC_INTEGRATION_DETAILS, HRC_INTEGRATION_ERROR_MESSAGES. 6 production SQL queries covering 100% of HDL failure modes.
8 canonical Oracle HCM compliance audit SQL queries: point-in-time headcount, termination reason audit, payroll variance detection, rehire detection, job change trail, absence balance audit, position audit, and costing distribution.
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 including PRIMARY_FLAG and effective date traps.
Oracle Fusion HCM vs BambooHR — honest comparison for mid-market companies (200-5,000 employees). Implementation cost, ease of use, reporting, payroll depth, 5-year TCO, and migration guide.
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
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
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.
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
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.
Complete guide to Oracle Fusion HCM Absence Management tables, configuration, and SQL queries. Master absence plans, entitlements, accruals with practical examples.
Working Oracle Fusion Fast Formula examples for payroll, absence, benefits, compensation, and extracts. Copy-paste formulas with syntax reference and debugging tips.
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.
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.
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.
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.
Complete guide to Oracle Fusion HCM REST API integration. Learn authentication, endpoints, error handling, and practical code examples for CRUD operations on HCM data.
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.
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 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.
Master Oracle Recruiting Cloud (ORC) tables and data model. Learn requisitions, candidates, applications, interviews with practical SQL examples and reporting queries.
Master Oracle HCM Workforce Compensation tables: salary management, compensation plans, merit increases, equity awards with practical SQL examples and reporting queries.
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
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.