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

Last updated on AUGUST 10, 2017

Applies to:

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



Symptoms

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.


Facts:


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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms