My Oracle Support Banner

Advanced Search Functionality Not Working For Primary Attributes City State and Province (Doc ID 1955315.1)

Last updated on MARCH 09, 2019

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.