Universal approach to debug any fast formula
In this article we will learn a universal way to debug any fast formula, we have already seen in this article How to Debug Oracle Absence Management Fast Formulas using ESS_LOG_WRITE method. However, problem with that approach is that it doesn’t work for all fast formula types, for example Performance Rating Calculation. There is no way to check log generated by function ESS_LOG_WRITE which you might have written inside formula type Performance Rating Calculation.
We have talked about the problem, but now lets also discuss about the solution. Thankfully, we have another function called ADD_RLOG(), which can be used to debug any fast formula types. Similar to ESS_LOG_WRITE, ADD_RLOGS also prints debug message but stores them in a table HWM_RULE_FF_WORK_LOG therefore we never have any challenge in accessing logs generated by formula that we are trying to debug.
How to use ADD_RLOG function to debug any fast formula
Approach to use add_rlog function to print log message inside our fast formula is slightly different than function ess_log_write. Let’s assume that you want to print person number of an employee, which is stored in the variable l_person_number, you will use below code inside your formula to print the variable.
Subscribe Now to Unlock Premium Content!
Choose a plan that fits your needs and stay ahead in your career with our expertly curated premium content.
