FUSION Fast Formula : GET_TABLE_VALUE Does Not Return Any Value In Absence Duration

(Doc ID 1579333.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 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.

      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

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