Accounts: Custom Lists (Saved Search) Return Accounts In Wrong State

(Doc ID 2265063.1)

Last updated on MAY 19, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
If you create a custom list searching by the native State field (operator Equals = Tx) it returns Accounts not in Tx.


EXPECTED BEHAVIOR
-----------------------
It is expected that if you do this search, it will only return accounts which are in Texas.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to the Accounts page
2. Go to Advanced Search
3. Add field State
4. Search State Equals 'Tx'
5. See that the accounts returned are not all from Tx.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can be confused as to why there are accounts being returned that are not from Tx.

Cause

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