Debugging Oracle Fast Formula.
Writing just a fast formula is not enough, first it should get compiled successfully without any error and then it should also work as expected and deliver desired result. Since you have stumbled upon this article, we assume we have already written a nice fast formula and now struggling to fix the issue as its giving crazy result. Don’t worry, you are in safe hands now. Fortunately there are several ways to debug a formula, we will go them one by one..
Note : If you want to learn functional side of oracle fusion absence management, we recommend you to go through this article » Fusion Absence Management : Explained with examples
First Method : Troubleshoot using ESS_LOG_WRITE() function
Using this function you can write/display anything in the log file, which will help you to debug the formula. Anything you want to print just put them inside braces. You can print anything, simply write Hello World, as shown below or any local variable, database item, input values etc.
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.
