Null Handling
5 articles in this category.
Null Handling
5 articlesOracle 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.
Start readingISNULL and WAS DEFAULTED in Oracle Fast Formula — Concepts
ISNULL and WAS DEFAULTED in Oracle Fast Formula — Concepts
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.
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 - 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