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

Last updated on MARCH 21, 2024

Applies to:

Goal

Using the Fast Formula Function with Effective Dates

User is using the GET_TABLE_VALUE function to get the values from an user table. User 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.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.