Oracle Taleo Enterprise Edition: Converting a Flex Field (UDF) from String Type to Numeric Type in Reporting (Doc ID 2979323.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Taleo Platform Cloud Service - Reporting and Analytics - Version 23C and later
Information in this document applies to any platform.

Problem Description:

A user-defined field (UDF) is set up as a number type field, but the values are not sorting in numerical order in Reporting.

Example: when values are displayed in a column, they appear in the order of 1, 10, 100, 2, 20, 200, ...

If the Flex Field column for the UDF is used in a filter, the results are not accurate.

When the Flex Field column for the UDF is used in a custom formula, one of the following errors occur:

	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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.