APP-33008: Unknown function 'GET_TABLE_VALUE' used in statement at line in Oracle Payroll

GET_TABLE_VALUE is a seeded Fast Formula text function which returns the value of a cell in a user-defined table. 

GET_TABLE_VALUE(table_name, column_name, row_value [,effective date])

The third operand is the row_value,  however its value must be in text format when used in the function call. Example (Formula may look like the following):

DEFAULT FOR ASG_GRADE IS 'X'

GTL_TABLE = 'TRANSPORTATION ALLOWANCE'

GTL_TABLE_COLUMN = /**/ 'ENTITLEMENT' /**/

TRANSPORTATION_ALLOW = GET_TABLE_VALUE (GTL_TABLE, GTL_TABLE_COLUMN,'ASG_GRADE')

RETURN TRANSPORTATION_ALLOW

NOTE: if you are passing Numeric data, first convert it to character and then pass it to the function.

e.g. to_char(PER_END_OF_YEAR_AGE))

Fast Formula errors with: APP-FF-33005: The local variable ABC was used before being initialized

Leave a comment for any query.