Salary Range DFFs in Job Requisition is pulling incorrect values.

Hi Oracle World,

We are trying pull the Maximum and Minimum Salary range values from Grade Rates. However, it is fetching incorrect values. We tried validating it by SQL query but it returns multiple rows which is not expected.

When multiple records are available, the expressions are retrieving the Minimum and Maximum values from the first grade-rate record reached through this path. Ex: We are trying to fetch Salary Range for Job Code 545500 for India Location. But when we run the SQL query, our Grade Rate "IN-545500-001" shows up in row number 780. However, the salary range is being pulled from the first record. Below mentioned is SQL query used for validating.