SEARCH OUTPUT IS NOT CONSISTENT IN ADVANCE SEARCH - ACCOUNT DCL FIELD (Doc ID 2287287.1)

Last updated on JULY 25, 2017

Applies to:

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

Goal

Business scenario

1. Created custom object and related it with Accounts.
2. Newly created custom object records have to be linked with account records.

There are several accounts with the same name but different letter capitalization (e.g. capital account / CAPITAL ACCOUNT)
When going to Advanced search of the Custom Object and searching for Accounts - the search does not show the wanted results when querying for specific accounts.
 

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