My Oracle Support Banner

Unable To Initiate Appraisal Due To Error ORA-20001: The definition of the absence duration Fast Formula is incorrect On Java Stack Log (Doc ID 3015582.1)

Last updated on AUGUST 19, 2024

Applies to:

Oracle Performance Management - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

When user is trying to start the appraisal task from Manager Self Service responsibility, the following error occurs on Appraisal page:

 

You have encountered an unexpected error. Please contact the System Administrator for assistance.

 

Error from the java error stack as below:

ERROR
-----------------------
java.sql.SQLException: ORA-20001: The definition of the absence duration Fast Formula is incorrect.

Please ask your System Administrator to verify that the inputs and outputs of the formula are passed and that they are of the correct type.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 235
ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 430
ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 545
ORA-06512: at "APPS.HR_APPRAISALS_UTIL_SS", line 608



The issue can be reproduced at will with the following steps:

1. Go into the responsibility: Manager Self Service.

2. Navigate to Performance Management page.

3. Select Manage Appraisal task.

4. Click on Appraise option.

5. Get error.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.