Applies to:

Oracle Fusion Absence Management Cloud Service - Version 11.1.9.2.0 and laterInformation in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Fast Formula

ACTUAL BEHAVIOR ---------------get_table_value function returns incorrect valueThe get table value function is used the retrieve the performance amount which is returning incorrect value

Run the process with person’grade is “M6”, and calll_amount = to_number(GET_TABLE_VALUE('PERFORMANCE_PAY_STANDARD', 'PERFORMANCE_AMOUNT',l_grade_name,'1000'))，the l_amount returned is 1000 but it should ideally return 780 which is defined in the table against grade 6

EXPECTED BEHAVIOR-----------------------Expect the get_table_value function to return the correct values

STEPS-----------------------The issue can be reproduced at will with the following steps:1. Define user defined table2. Call the function GET_TABLE_VALUE in the payroll formula

BUSINESS IMPACT-----------------------The issue has the following business impact:Due to this issue, users cannot start their UAT

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