Blog

The same SQL query can return zero rows for one user and thousands for another. This guide explains Oracle Fusion's four security layers - Functional Roles, Data Roles, HCM Security Profiles, and Row-Level Security - and how they affect BI Publisher report development.

18 practical SQL queries for Oracle Fusion Finance - covering GL journals, period balances, AP invoices and payments, AR aging, Subledger Accounting AP-to-GL tracing, and cash management. With common pitfall warnings.

18 SQL queries for Oracle Fusion Procurement - covering approved POs, requisitions, open commitments by account, overdue lines, receipt tracking, supplier spend, three-way match analysis, and requisition-to-PO tracing.

When reproducing Oracle Fusion OTBI reports in BI Publisher or direct SQL, knowing which base tables each subject area commonly sources from is the essential first step. This reference covers HCM, Finance, and Procurement subject areas with common tables, join keys, and an explanation of why SQL and OTBI results often differ.

How to correctly handle effective-dated tables in Oracle Fusion SQL - current records, point-in-time snapshots, change history queries, and the 31-DEC-4712 sentinel value explained.

Slow BI Publisher reports are one of the most common Oracle Fusion frustrations. Here are 12 SQL optimization techniques Oracle Fusion developers actually use in production to make reports significantly faster.

Oracle Fusion has thousands of tables with no obvious foreign keys visible in the UI. This guide explains how HCM, Finance, and Procurement tables actually relate to each other - with correct join examples and cross-module query patterns.

Oracle Fusion Cloud has one of the most complex schemas in enterprise software. This guide covers the primary access methods, key schema patterns every developer needs to know, and practical starter queries to explore the schema.

20 practical SQL queries for Oracle Fusion HCM - covering active employees, headcount, hiring, attrition, salary by grade, org structure, absence tracking, tenure bands, and retirement eligibility. With effective-date pitfall warnings.

OTBI and direct SQL are complementary tools designed for different use cases in Oracle Fusion Cloud. This guide compares them across 9 dimensions and explains when - and how - to use both together.