Unable to search successfully with Equals operator on custom field of field type = Percentage (Doc ID 2113387.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

Issue as follows:

1. Create a custom field of type Percentage and then add this custom field to Simplified Pages > Create Account page in App Composer.

2. Navigate to Create Account page and add a value to the custom field (for example, 50 or 60). Save.

3. Go to Accounts list page in Simplified UI and add this custom field to the query panel.

4. Search on the value 50 or 60 with the Equals operator. No results are found. However, searching the custom percentage field using a value of '0.5' instead of '50' does work.

Why this is happening?

Solution

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