Latest
Home » Oracle » Common Issues » ORA-20000:A compiled version of the formula 67000 cannot be found
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..

ORA-20000:A compiled version of the formula 67000 cannot be found

⚡ Must Read Fusion Article : Learn Fusion Workforce Compensation Step By Step – Part1

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..

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.

Fast Formula

Now click on the Edit icon and click on verify and save the formula. Now the check box will be selected.

Oracle HRMS Fast formula

☑ What to read next :
Question and answer forum of iavinash.com
☑ Related Job : Oracle Core HR (Payroll) – Openings with Accenture – Bangalore

Check Also

Holiday Calendar - APP-HXT-39163 FRM - 41830 List of Values contains no entries.

Earning Type not available while creating holiday calendar in OTL

Holiday Calendar Issue Navigation : OTL Application Developer » OTL Time Accounting » Time Setup and Maintenance …