FUSION Fast Formula : GET_TABLE_VALUE Does Not Return Any Value In Absence Duration (Doc ID 1579333.1)

Last updated on AUGUST 29, 2016

Applies to:

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

Symptoms

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')
          THEN
          (
          duration = '4'
       )
       ELSE
        (
          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.

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