Oracle Fast Formula: How to Generate Logs in OTL — Setup, Code, and Where to Find the Output
Fast Formula Time and Labor Logging TER & TCR Oracle Fast Formula: How to Generate Logs in OTL — Setup, Code, and Where to Find the Output Abhishek Mohanty · April 2026 · 14 min read · Oracle HCM Cloud If you have ever written an OTL Fast Formula, deployed it, saved a timecard, and then opened the rule processing page expecting to see your debug lines — only to find the page empty — this post is for you. OTL logging fails for two reasons. Either the setup chain is incomplete and the formula never fires. Or the visibility switch is off and the engine throws your log lines away before saving them. The order matters. Most posts jump straight to the add_log function call, but if the rule never fires, no function call inside it can ever produce a line. This post walks the chain in the right order: setup first, then the formula, then the profile that makes everything visible. TCR Setup — The Calculation Engine We start with the TCR (Time Calculation Rule) becau...