Using The Fast Formula Function With Effective Dates where sometimes NULL (GET_TABLE_VALUE)
(Doc ID 2132675.1)
Last updated on SEPTEMBER 10, 2020
Applies to:Oracle Fusion Workforce Compensation Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Compensation - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document