Error : Have you ever encountered this error?
The Oracle error is: ORA-20000: ORA-20001:ORA-20001: A compiled version of the formula 67000 cannot be found. Check that it exists and has been compiled before attempting to run it..
Sometime you might get this error and run here and there to find out the reason behind it, although the solution is very simple but still its enough to kill your crucial hours!!
Error is not just linked to OTL or any other particular modules as mentioned here. we are more concerned about the line “compiled version of the formula xxxx cannot be found”
Cause : What is the reason?
The most common reason is there is one fast formula, which is not complied. The id of that fast formula is also mention in the error. Now, our job is to get the actual name of the formula and for that we need to run following query
select formula_name from ff_formulas_f where formula_id = 67000
After running the query you will get the formula name.
Fix : What is the step to fix the issue?
Once you get the formula name, navigate to HRMS Manager » Total Compensation » Basic » Write Formulas » Search for the formula
You will notice that Verified checkbox is not checked.
Now click on the Edit icon and click on verify and save the formula. Now the check box will be selected.