SYMPTOMS:
A Cognos report based on "Configurable field history tracking" query subject displays the old descriptions/names for UDF code values for certain resources, instead of the current descriptions.

The UDF names are correct for the same resources in UI (e.g. User Setup page).

These UDFs had been renamed long time ago.

REASON:
The query subject "Configurable field history tracking" takes the values from the table "ReportUDFcodeHistory", which keeps track of the changes in UDF code values and descriptions. Therefore, any change that occurred before the renaming of the UDF will have the old UDF name, consequently the reports based on that table will display the old UDF names.


RESOLUTION:
If the current UDF names need to be displayed in the report, use either of the following methods:

1- Use the query subject of the entity itself, e.g. for resource code values use Resources query subject

2- Use SQL to fetch the current description from the CodeDetail table in Changepoint database