Unable to search successfully with Equals operator on custom field of field type = Percentage
Last updated on AUGUST 01, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms