FUSION Fast Formula : GET_TABLE_VALUE Does Not Return Any Value In Absence Duration
Last updated on AUGUST 29, 2016
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Fast formula of type "Payroll Access to HR" is created to fetch data from user-defined tables (UDT) using GET_TABLE_VALUE function.
This function is called from from Absence Duration Formula for validation. The Absence Duration formula gets compiled successfully.
LDG = GET_CONTEXT(LEGISLATIVE_DATA_GROUP_ID,0)
CHANGE_CONTEXTS (LEGISLATIVE_DATA_GROUP_ID = LDG) (
var1 = '0'
var1 = GET_TABLE_VALUE('XXDIV_HOLIDAYS', 'Y2013', '01-02')
IF (var1 = 'NEWYEAR')
duration = '4'
duration = '8'
However when employee creates an absence, system ignores the Absence Duration Formula and throws the error on the Manage Absence Records page:
STRINGMANAGER: StringManager java.sql.DQLException: ORA-20001: Formula CORE_ABSENSE_DURATION, line 295, no data returned.
ORA-06512: at "FUSION.PER_UTILITY_FF_FUNCTIONS", line 161 ORA-06512: at "FUSION.PER_ABS_DUR_CALC_FF", line 41 ORA-06512: at line 2
(oracle.javatools.resourcebundle.ResourseBundleRT) exception java.lang.ArrayIndexOutOfBoundsException: 1.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms