Fusion Compensation : Using The Fast Formula Function With Effective Dates where sometimes NULL (GET_TABLE_VALUE)

(Doc ID 2132675.1)

Last updated on APRIL 29, 2018

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

Using the FF Function with Effective Dates

I am using the GET_TABLE_VALUE function to get the values from an user table. We want to retrieve the value as of an effective date, but also need to have a default because, it will be null some times.
How can we achieve that.

Following is the notes from documentation that says we can use only one of them.
---
GET_TABLE_VALUE(table_name, column_name, row_value [,default_value])

GET_TABLE_VALUE(table_name, column_name, row_value, effective date)

Returns the value of a cell in a user-defined table on the effective date of the session or process. The first three text operands identify the cell. An optional fourth parameter does one of the following, depending on its data type:

Text: Returns a text default value if no data is found.
Date: Returns the value of the cell on the specified date.
Example: GET_TABLE_VALUE('WAGE RATES', 'Wage Rate', Rate_Code, 'DEFAULT') would return the row_value for Wage Rate or DEFAULT if no row was found.
 

(http://docs.oracle.com/cloud/latest/globalcs_gs/OAPFF/OAPFF1426936.htm#OAPFF311968)

Solution

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