Articles
Technical guides, deep-dives, and practical solutions.
ISNULL and WAS DEFAULTED in Oracle Fast Formula — Concepts
Oracle Fast Formula has three distinct missing-data states — uninitialized, holds a value, holds NULL — and each one needs its own detection mechanism. Here's the mental model that actually works.
Oracle Recruiting Cloud Fast Formulas — The Complete Guide
Every CSP (Candidate Selection Process) Fast Formula type in Oracle Recruiting Cloud, with worked examples for scoring, routing and validation.
Oracle Fast Formula: NULL Doesn't Exist — Use WAS DEFAULTED
A big shoutout to Mr. Scott Klein — who, after reading my Fast Formula blog series, pointed out a concept that every developer searches for but never finds in the docs: how to check for NULL. This one's inspired by that conversation.
Where to Check Fast Formula Logs — ESS Process Names & Navigation Paths
A practical guide to finding Fast Formula debug logs in Oracle HCM Cloud — ESS process names, navigation paths, and log locations for Absence, Payroll, Compensation, Benefits and OTL.
Participation & Rate Eligibility Formula with CHANGE_CONTEXTS and Array DBIs
Oracle HCM Cloud Fast Formula for Participation and Rate Eligibility — CHANGE_CONTEXTS, WAS DEFAULTED null handling, and PER_EXT_ORG array DBI looping.
Debugging Oracle Fast Formula: 5 Logging Patterns Every HCM Cloud Consultant Must Know
Your formula compiled successfully. It even runs without errors. But the result is wrong — and you have no idea why. Welcome to the world of Fast Formula debugging, where the only tool you have is a single function: ESS_LOG_WRITE.
Oracle Fast Formula Array DBIs: A Beginner-to-Expert Guide to Indexing, Looping & CHANGE_CONTEXTS
Most Fast Formulas work with single values — one hire date, one assignment status, one accrual amount. But what happens when a person has multiple assignments, multiple date-tracked rows, or matrix bands with multiple accrual tiers? That's
The 7 Pillars in Action: How a Philippine Leave Formula Brings Every Concept to Life
You can't write a formula without a Formula Type. You can't attach it without knowing which column expects it. And you can't debug it without understanding the contexts and input variables tied to it. In this post, I'll use a real-world Abs
Fast Formula Deep Dive: Contexts, DBIs, Routes & the 7 Building Blocks Oracle Docs Don't Explain Clearly
If you've ever tried to write a Fast Formula and wondered what the difference is between a Context, an Input Value, and a Database Item — this post is for you. Let's break down the 7 core building blocks that every FF developer needs to und