Oracle HCM Cloud Fast Formula
Architecture & Design
- Time FF
- Global FF
- Absence FF
- Loops
- Conditions
- Variables
- Context_A
- Context_B
- Evaluations
Latest
34 articlesOracle HCM Cloud Fast Formula: Debug Logging with ADD_RLOG, the Log Level Profile Trap, and the Final RETURN — Series Finale
Why ADD_RLOG is the right way to log from a TCR, why the ORA_HWM_RULES_LOG_LEVEL profile is the piece everyone forgets to set, why ESS_LOG_WRITE silently does nothing in real-time formulas — and what the RETURN statement finally sends home. Series closes.
Start readingOracle HCM Cloud Fast Formula: TCR Indexing Anatomy — What nidx Actually Is, the Parallel-Indexing Contract, and Why You Increment It Yourself
The variable that walks the parallel arrays. Nine parts of the series used nidx in every code sample — this one stops to explain what it is, how the same index reaches into every parallel track simultaneously, why Fast Formula makes you increment it by hand, and the bounds-and-guard patterns that keep the loop honest.
Oracle HCM Cloud Fast Formula: The 12-Tier OT Counter Cascade — Why the TCR Unrolls Instead of Loops
Twelve sequential IF blocks, one per accumulated OT threshold, each firing its own recognition trigger. Why Fast Formula's variable-naming constraint forces the unrolled pattern, why a WHILE loop can't replace it, and what happens when the accumulator finally clears the top tier.
Oracle HCM Cloud Fast Formula: OT Claim Reconciliation in a TCR — GET_PLAN_BALANCE Inside a CHANGE_CONTEXTS Block
How the TCR reconciles OT hours it just allocated against previously-claimed OT balances stored in the absence plan, why GET_PLAN_BALANCE must run inside a CHANGE_CONTEXTS block, and how the reconciliation delta keeps re-runs of the TCR idempotent.
Oracle HCM Cloud Fast Formula: Night OT Spillover in a TCR — IS_DATE_BETWEEN, the StopTime+24 Midnight Wrap, and the Four-Bucket Night Allocation
Oracle HCM Cloud Fast Formula: Night OT Spillover in a TCR — IS_DATE_BETWEEN, the StopTime+24 Midnight Wrap, and the Four-Bucket Night Allocation
Oracle HCM Cloud Fast Formula: Night Surcharge Detection in a TCR — The PayrollTimeType Match, UPPER() Case-Insensitive Compare, and the Dual Daily/Period Night Accumulators
Oracle HCM Cloud Fast Formula: Night Surcharge Detection in a TCR — The PayrollTimeType Match, UPPER() Case-Insensitive Compare, and the Dual...
Oracle HCM Cloud Fast Formula: Regular and OT Bucket Allocation in a TCR — The Day-Type Branch, the l_total Threshold Cascade, and the l_ot_counter Tracking Pattern
Oracle HCM Cloud Fast Formula: Regular and OT Bucket Allocation in a TCR — The Day-Type Branch, the l_total Threshold Cascade, and the l_ot_counter...
Oracle HCM Cloud Fast Formula: Absence Integration in a TCR — The AbsenceType Array, the GET_VALUE_SET Claim Lookup, and the Back-Fill WHILE Loop
Oracle HCM Cloud Fast Formula: Absence Integration in a TCR — The AbsenceType Array, the GET_VALUE_SET Claim Lookup, and the Back-Fill WHILE Loop
Oracle HCM Cloud Fast Formula: The Main Iteration Loop in a TCR — HWM_CTXARY Parallel Arrays, aiRecPosition Phase Markers, and the Defensive raise_error Guard
Oracle HCM Cloud Fast Formula: The Main Iteration Loop in a TCR — HWM_CTXARY Parallel Arrays, aiRecPosition Phase Markers, and the Defensive...
Oracle HCM Cloud Fast Formula: Day-Type Branching in TCR Calculations with GET_DATE_DAY_OF_WEEK, CALL_FORMULA Holiday Resolution, and the PER_ASG_FULL_PART_TIME Fork_TCR Part-2
Oracle HCM Cloud Fast Formula: Day-Type Branching in TCR Calculations with GET_DATE_DAY_OF_WEEK, CALL_FORMULA Holiday Resolution, and the...
Oracle HCM Cloud Fast Formula: Deriving Daily Working Hours from PER_ASG_WORK_SCH_WORKDAY_PATTERN in TCR Calculations
Oracle HCM Cloud Fast Formula: Deriving Daily Working Hours from PER_ASG_WORK_SCH_WORKDAY_PATTERN in TCR Calculations
Oracle Fast Formula: The TER State Machine — Continuous-Hours Tracking, Setup Dependencies, and a Full End-to-End Trace
The two-state machine that makes the TER formula stateful, why Julian Day arithmetic is non-negotiable for night shifts, the twelve setup artefacts that must exist before the formula fires, and a complete trace of a broken timecard from Submit to error markers. Series finale.
Oracle Fast Formula: The TER Algorithm — Setup, Per-Line Routing, and the Pairwise Overlap Test
The five setup blocks that run before the loop, the routing tree that decides which validation applies to each timecard row, and the day-boundary overlap test — including the strict less-than that separates a usable formula from an unusable one.
Oracle Fast Formula: The TER Input Contract — Marker Rows, Parallel Arrays, and Why Every Read Needs an .exists() Guard
OTL doesn't hand your formula a timecard object. It hands you six parallel arrays with shared row indexes, wrapped in marker rows the worker never sees. Part 2 dissects the data shape, every input variable, and the naming conventions that keep production TER code maintainable.
Oracle Fast Formula: Time Entry Rules in OTL — Where TER Sits, Why Cross-Row Validation Needs Code, and a Timecard That Fails Three Rules
Where Time Entry Rules sit in OTL's submission pipeline, why declarative validation can't express cross-row rules, and a worked example of a four-row timecard that trips the continuous-work cap, the meal-break window, and the overlap check.
Oracle Fast Formula ALIAS: How the Compiler Resolves Long DBI Names at Parse Time
ALIAS is a compile-time reference, not a runtime variable — and that distinction decides whether your formula returns the right answer inside CHANGE_CONTEXTS. Statement order, what you can and cannot alias, reference-versus-snapshot semantics, WAS DEFAULTED compatibility, and the three compiler errors you'll actually hit.
Oracle Fast Formula: GET_PLAN_BALANCE, GET_ABSENCE_COUNTS, and the Two Traps That Quietly Ship the Wrong Number
Oracle Fast Formula: GET_PLAN_BALANCE, GET_ABSENCE_COUNTS, and the Two Traps That Quietly Ship the Wrong Number
Oracle Fast Formula: How to Generate Logs in OTL — Setup, Code, and Where to Find the Output
Why OTL logging fails in two distinct ways — an incomplete setup chain, or a visibility switch left off — and how to fix both. Covers TCR and TER template configuration, add_log and add_rlog, the profile option that gates everything, and working skeletons for both rule types.
Oracle HCM Fast Formula Series:GET_CONTEXT and CHANGE_CONTEXTS: The Two Context Statements You Actually Need
Oracle HCM Fast Formula Series:GET_CONTEXT and CHANGE_CONTEXTS: The Two Context Statements You Actually Need
ISNULL and WAS DEFAULTED in Oracle Fast Formula — Concepts
ISNULL and WAS DEFAULTED in Oracle Fast Formula — Concepts
Oracle Fast Formula: Post Election Edit — Cross-Plan Validation with CHANGE_CONTEXTS and BEN_PEN Array DBIs
Why a Post Election Edit that reads enrollment at today's date lets invalid elections through, and how a waiting-period calculation plus CHANGE_CONTEXTS fixes it. Includes the full formula, four worked employee scenarios, and the amount check no configuration can do.
Oracle Recruiting Cloud Fast Formulas — The Fast Formula Guide Every HCM Cloud Consultant Needs
Oracle Recruiting Cloud Fast Formulas — The Fast Formula Guide Every HCM Cloud Consultant Needs
Oracle Benefits Rate Periodization Formula — Mid Year Proration with YTD Cap and CHANGE_CONTEXTS
Oracle Benefits Rate Periodization Formula — Mid Year Proration with YTD Cap and CHANGE_CONTEXTS
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.
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...
HDL Transformation Formula Deep Dive — Part 2: The Code, Line by Line
The actual formula code — INPUTS ARE and DEFAULT FOR, GET_VALUE_SET parameter string construction with pipe delimiters and triple quotes, why ISNULL returns 'N' for null, the lookup-or-construct SourceSystemId pattern, ESS_LOG_WRITE tracing, and the LINEREPEATNO passes including the Cancel end-dating branch. Part 2 of 3.
HDL Transformation Formula Deep Dive — Part 1: OPERATION Routing, METADATA Arrays, MAP Steps, WSA Caching, and LINEREPEATNO
How an HDL Transformation Formula turns one vendor CSV row into an ElementEntry header plus up to six ElementEntryValue rows — the OPERATION handshake, METADATA column definitions, the five MAP steps, why WSA caching is a correctness requirement and not just a performance one, and how LINEREPEATNO drives the passes. Part 1 of 3, concepts only.
Oracle Fast Formula: NULL Doesn't Exist — Use WAS DEFAULTED
Oracle Fast Formula: NULL Doesn't Exist — Use WAS DEFAULTED
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
Oracle HCM Cloud Fast Formula — Where to Check Logs: ESS Process Names, Navigation Paths & Prerequisites for Absence, Payroll, Compensation, Benefits,...
Oracle HCM Cloud Fast Formula - Participation and Rate Eligibility formula with CHANGE_CONTEXTS, WAS DEFAULTED null handling, PER_EXT_ORG array DBI loop
Oracle HCM Cloud Fast Formula - Participation and Rate Eligibility formula with CHANGE_CONTEXTS, WAS DEFAULTED null handling, PER_EXT_ORG array DBI loop
Debugging Oracle Fast Formula: 5 Logging Patterns Every HCM Cloud Consultant Must Know
Debugging Oracle Fast Formula: 5 Logging Patterns Every HCM Cloud Consultant Must Know
Oracle Fast Formula Array DBIs: A Beginner-to-Expert Guide to Indexing, Looping & CHANGE_CONTEXTS
Oracle Fast Formula Array DBIs: A Beginner-to-Expert Guide to Indexing, Looping & CHANGE_CONTEXTS
The 7 Pillars in Action: How a Philippine Leave Formula Brings Every Concept to Life
The 7 Pillars in Action: How a Philippine Leave Formula Brings Every Concept to Life
Breaking Down a PH Vacation Leave Accrual Matrix Formula — Section by Section
A production Philippine vacation leave accrual matrix formula, walked through block by block — DEFAULT handling, DBIs versus input values, the l_process flag pattern, the monthly frequency guard, and the three-phase accrual logic with its one-time January credit.
Fast Formula Deep Dive: Contexts, DBIs, Routes & the 7 Building Blocks Oracle Docs Don't Explain Clearly
The seven components every Fast Formula rests on — Formula Type, Contexts, Input Values, Database Items, Routes, Functions, and Return Variables. What each one does, how they connect, and the practical details that cause most compilation errors and runtime surprises.