My Oracle Support Banner

UK Payroll: Error On Entering Sickness And Maternity Absence: JBO-29000 Formula ORA_HRX_GB_ABS_HOURS_CONVERSION cannot be executed / ORA-20500: PLS-00302: component 'GET_SHIFT_TYPE' must be declared (Doc ID 2396630.1)

Last updated on APRIL 17, 2019

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Country/Region Legislations

When attempting to enter Sickness and Maternity absence,
the following error occurs:

JBO-29000 Unexpected eception caught: oracle.apps.fnd.applcore.messages.ApplcoreException, msg=JBO-FF_FFCR_FORMULA_NOT_COMPILED: FF-1605201Formula ORA_HRX_GB_ABS_HOURS_CONVERSION cannot be executed because it is not compiled.
A formula must be compiled before it can be executed.

The issue can be reproduced at will with the following steps:
1. go to Maintain Absence Records;
2. Add Absence Record > Absence Type: Sickness / Start Date Duration: Full day
3. Submitting the Absence;
4. Error is received.

Below is the list of test cases for which the mentioned issue is faced:
1.Line manger adds a start date for the absence in HCM and selects 'sickness' as the type.
2.Employee or line manager add the end date for the absence when the employee returns to work.
3.When the employee goes on maternity leave their LM update HCM with the start date of their maternity leave

User tried to compile formulas and got:
AFDICT_APP_PREFIX-FF-1605069: The compile failed for the formula type Global Absence Plan Duration named ORA_HRX_GB_ABS_HOURS_CONVERSION with an effective start date of 0001/01/01 00:00:00.
AFDICT_APP_PREFIX-FF-1605039: Formula ORA_HRX_GB_ABS_HOURS_CONVERSION compilation failed while creating the formula PL/SQL package FFP300000001631097_01010001.
AFDICT_APP_PREFIX-FF-1605071: A system error occurred. The following Oracle error occurred for table DDL_EXECUTE: -20500. Your help desk was notified. (2=ORA-20500: PLS-00302: component 'GET_SHIFT_TYPE' must be declared
PL/S) (3=107)
ORA-20500: PLS-00302: component 'GET_SHIFT_TYPE' must be declared
PL/SQL: Statement ignored
ORA-06512: at "FUSION.ADM_DDL", line 217
ORA-06512: at line 2

User additional remarks:
I think this is to do with UK Statutory Sick Pay, etc
Is there some seed data missing?

The issue has the following business impact:
Due to this issue, users cannot submit Sickness and Maternity absences


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

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