My Oracle Support Banner

Unable to use Database Items in Fast Formula for Leave of Absence (Doc ID 277441.1)

Last updated on DECEMBER 04, 2023

Applies to:

Oracle Human Resources - Version and later
Information in this document applies to any platform.
Leave of Absence screen when a Fast Formula is modified to use Database Items


While trying to update the BG_ABSENCE_DURATION formula, a call is made to the function having parameter employee number (to populate the working patterns of the employee).  For this the PER_EMP_NUMBER database item is used.  It will work fine from core Apps side, but through Self -Service (and on the final approval) there will be an error as follows:

Error: Data PER_EMP_NUMBER not found at line 55 of BG_ABSENCE_DURATION
Cause: A SQL SELECT statement, obtained from the application dictionary returns no row when executed . Action: Please refer to your local support representative.


Thus a Workaround is needed so that BG_ABSENCE_DURATION can calculate the leave duration based on individuals work patterns.


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.