Fusion HCM Extract: Error Compiling Fast Formula When Using GET_TABLE_VALUE Function (Doc ID 1629591.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Fusion Global Payroll - Version 11.1.7.0.0 and later
Oracle Fusion Global Human Resources - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

Trying to use GET_TABLE_VALUE function and getting a compile error.

Error Message: Formula SS_TEST_UDT_FF, line 38, syntax error at character position 90.

Tried using GET_CONTEXT('2104/01/01','0001/01/01 00:00:00'(date)) for the date parameter but it is still not compiling.

Fast Formula has the following syntax:

ELEMENTNAME = GET_TABLE_VALUE('TEST_TABLE','TEST_COL','TEST_ELE_NAME',GET_CONTEXT('2014/01/01','0001/01/01 00:00:00'(DATE)))

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