Technical Articles

Deep-dive technical guides, architecture patterns, SQL queries, and implementation details for Oracle Fusion HCM professionals.

Technical 7/2/2026

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...

Fast FormulaOracle HCM CloudTime & Labor

Read Article →

Technical 3/27/2026

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...

Fast FormulaHDLOracle HCM Cloud

Read Article →

Technical 12/20/2024

Fast Formula Advanced Techniques & Optimization Strategies

Master advanced Fast Formula development with real-world optimization techniques, performance tuning, and best practices for complex calculations.

Fast FormulaOracle FusionHCMDevelopmentPerformanceAdvanced

Read Article →

Technical 12/18/2024

HCM Data Loader: Best Practices for Efficient Data Migration

Complete guide to HCM Data Loader including configuration, validation, error handling, and best practices for successful data migration.

HCM Data LoaderData MigrationOracle FusionIntegrationETL

Read Article →