Advanced Search Functionality Not Working For Primary Attributes City State and Province

(Doc ID 1955315.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Site Hub - Version 12.2.1 and later
Information in this document applies to any platform.


While doing advanced search you find you are not able to search the sites with
Geography Name (City) , but able to do with Geography Code.

Site Management User -> Site Home -> Sites -> Advanced Search

Provide values for Primary attribute `Status' as Active and 'City' name

While clicking on search button no results are returned.

But if you provide values for Primary attribute `Status' as Active and City as  the geo-code, ie
`GH-SEG-AA-AC-ACC'  then results for the search are returned.

But the site returned shows the geo-code value for the 'City' name and not the actual name.

In the instance for TCA setup an Address flexfield was setup for field 'City', 'State', 'Province' and
'County'. Each of these fields were associated to the value sets.


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