OTL
17 articles in this category.
OTL
17 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: 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 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,...