Absence Management
IV_ACCRUAL How it actually behaves inside a matrix accrual — not what the parameter list implies it should do.
About
Abhishek Mohanty
Oracle HCM Cloud Technical Architect
Over the last decade I have architected and delivered complex Oracle HCM Cloud implementations across the APAC region, most recently multi-country rollouts spanning six markets.
I work heavily on the techno-functional edge — close enough to the configuration to know what the business actually asked for, and close enough to the code to know why it won't do that yet.
Recent multi-country rollouts
TWTaiwan SGSingapore MYMalaysia PHPhilippines HKHong Kong THThailand
AIOUG · Active member ACE Associate 10+YEARS ON HCM CLOUD
6APAC MARKETS
10MODULES COVERED
30+FORMULAS DOCUMENTED
Why this site exists
The missing manual
Oracle's official documentation is excellent at telling you what a feature does. It is entirely silent on the edges — and the edges are where implementations actually fail. Three examples I've hit in production:
Release 26A · Logging
ESS_LOG_WRITE Why it blows up in 26A when called inside a Global Absence Carryover formula, and what to use instead.
Core HR · Global Transfer
PER_ASG_REL_ORIGINAL_DATE_OF_HIRE What realistically happens to it after a Global Transfer — as opposed to what the DBI description promises.
That gap is the whole reason this site is here. I document the exact behaviours, the traps, and the solutions I run into on live production rollouts — while they're still fresh enough to be accurate.
Coverage
What you will find here
Production-ready code
Fast Formulas with named-employee worked examples, traced line by line from input contract to RETURN.
Logging & debugging
Practical debug logging idioms for every formula type — and the profile options that silently discard them.
APAC architectural patterns
Multi-country leave policies, accrual matrices, and the TER/TCR frameworks that hold them together.
Data & UI notes
Advanced strategies for Redwood UI and HDL Transformation Formulas, including the mappings that aren't documented.
Core HR Absence Management Time and Labor Compensation Benefits Payroll Recruiting Redwood HDL OTBI
Hit one of these edges yourself?
Corrections and counter-examples are genuinely welcome — they make the notes better.
Notes on this site are personal and reflect the author's views, not those of any employer or client. Oracle and the Oracle product names referenced are trademarks of Oracle Corporation.