Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle HRSS - BG_ABSENCE_DURATION FAST FORMULA issue

Jamal FarooqDec 16 2019 — edited Feb 9 2021

I am getting the following error after deleting the most current version from of BG_ABSENCE_DURATION fast formula.

here is what I did, I made some changes in BG_ABSENCE_DURATION and gave effective date 01-JAN-2010 so it's created a version from 01-JAN-1951 to 31-DEC-2018 and one from 01-JAN-2019.

When I delete the 01-JAN-2019 version and try to submit absent though HRSS, it's giving the following error message.

"Formula BG_ABSENCE_DURATION: ORA-20001: A compiled version of the formula BG_ABSENCE_DURATION cannot be found. Check that it exists and has been compiled before attempting to run it. Cause: During the PL/SQL execution part, an Oracle error was detected. Action: Please refer to your system administrator. "

I check few Oracle document related to same error and run "Bulk Compile Formulas" concurrent program which show me "QuickPaint:BG_ABSENCE_DURATION:1951/01/01 verified OK"

But still, I am facing the same error.

Really need a prominent reply as UAT is going on and I have to correct this ASAP. please see the attachment as well ..

JF

This post has been answered by Debojyoty_Sadhukhan on Dec 16 2019
Jump to Answer
Comments
Post Details
Added on Dec 16 2019
3 comments
232 views