Oracle HCM Cloud
Abhishek Mohanty
Technical deep-dives into Oracle HCM Cloud — Fast Formulas, HDL, Benefits & beyond.
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 that are easy to conflate, especially for developers coming from PL/SQL. Each one needs a different detection mechanism, and choosing the wrong one is a common source of subtle bu
Oracle Fast Formula: Post Election Edit — How to Validate Cross-Plan Dependencies Using CHANGE_CONTEXTS and BEN_PEN Array DBIs
Oracle Fast Formula: Post Election Edit — Cross-Plan Enrollment Validation with Waiting Period Logic
Oracle Recruiting Cloud Fast Formulas — The Fast Formula Guide Every HCM Cloud Consultant Needs
Oracle Fast Formula: The Complete Guide to Recruiting CSP Formulas
Oracle Benefits Rate Periodization Formula — Mid Year Proration with YTD Cap and CHANGE_CONTEXTS
@import url('https://fonts.googleapis.com/css2?family=Open+Sans:ital,wght@0,400;0,500;0,600;0,700;0,800;1,400&display=swap');
Step-by-step WSA implementation and complete code of Oracle HCM Cloud HDL Transformation Fast Formula — WSA_EXISTS, WSA_GET, WSA_SET for Person caching and MultipleEntryCount tracking, full formula with INPUTS ARE, OPERATION routing, METADATA, GET_VALUE_SET, SourceSystemId, LINEREPEATNO, and ElementEntry .dat output. Part 3 of 3.
WSA Implementation and Complete HDL Transformation Fast Formula Code
Step-by-step code walkthrough of Oracle HCM Cloud HDL Transformation Fast Formula — INPUTS ARE declaration, GET_VALUE_SET parameter construction, ISNULL checking, SourceSystemId resolution, ESS_LOG_WRITE tracing, LINEREPEATNO pass logic for ElementEntry and ElementEntryValue, and Cancel end-dating with ReplaceLastEffectiveEndDate. Part 2 of 3.
Oracle HCM Cloud HDL Transformation Fast Formula — Line-by-Line Code Walkthrough
Step-by-step explanation of Oracle HCM Cloud HDL Transformation Fast Formula — OPERATION routing, METADATA arrays, MAP steps, WSA caching, LINEREPEATNO, MultipleEntryCount, and ElementEntry output. Part 1 of 3.
@import url("https://fonts.googleapis.com/css2?family=Open+Sans:wght@400;600;700;800&display=swap");
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.
Oracle HCM Cloud Fast Formula — Where to Check Logs: ESS Process Names, Navigation Paths & Prerequisites for Absence, Payroll, Compensation, Benefits, OTL, HCM Extract & Talent Management
You added `ESS_LOG_WRITE` to your formula. You ran the process. Now you're staring at the screen wondering where the output went. This post is for that moment.
Oracle HCM Cloud Fast Formula - Participation and Rate Eligibility formula with CHANGE_CONTEXTS, WAS DEFAULTED null handling, PER_EXT_ORG array DBI loop
The business says "exclude workers in Puerto Rico and Washington DC." Simple — until you realize that the worker's work state can come from three different places in Oracle HCM depending on whether they work from home, whether their departm
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
Breaking Down a PH Vacation Leave Accrual Matrix Formula — Section by Section
.am-blog{font-family:'Segoe UI',Tahoma,Geneva,Verdana,sans-serif;color:#1a1a1a;line-height:1.8;max-width:780px;margin:0 auto}
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