FND_SEARCH_OPTIONS_B
The primary table storing Fusion Search Options. These options are passed to Oracle Fusion Search (Global Search) at runtime.
Details
-
Schema: SEARCH
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_SEARCH_OPTIONS_B_PK |
SEARCH_OPTION_ID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SEARCH_OPTION_ID | NUMBER | 18 | Yes | SEARCH_OPTION_ID - Unique internal id for primary key. | |
| SEARCH_OPTION_CODE | VARCHAR2 | 40 | Yes | SEARCH_OPTION_CODE - A unique code passed to Global Search task flows. | |
| PILLAR | VARCHAR2 | 20 | Yes | PILLAR - Where the Options will be used. | |
| MODULE_ID | VARCHAR2 | 32 | Yes | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |
| OPTION_ENABLED_FLAG | VARCHAR2 | 1 | Yes | OPTION_ENABLED_FLAG - Is this option enabled (Y/N). | |
| DEFAULT_OPTION_FLAG | VARCHAR2 | 1 | Yes | DEFAULT_OPTION_FLAG - Is this option the default (Y/N). Only one option can be the default. | |
| SEARCH_FIELD_CAT_ENA_FLAG | VARCHAR2 | 1 | Yes | SEARCH_FIELD_CAT_ENA_FLAG - Does the user see the search categories customization UI with the search field. This does not effect the filtering in the search results UI. | |
| SEARCH_FIELD_GRPS_ENA_FLAG | VARCHAR2 | 1 | Yes | SEARCH_FIELD_GRPS_ENA_FLAG - Does the user see the suggest groups customization UI with the search field. | |
| SEARCH_FIELD_MAX_LEN | NUMBER | 4 | Yes | SEARCH_FIELD_MAX_LEN - The maximum number of characters the search field can take. | |
| SEARCH_FIELD_MIN_LEN | NUMBER | 1 | Yes | SEARCH_FIELD_MIN_LEN - The minimum number of characters required in the search field for searching. | |
| SEARCH_FIELD_CLR_ON_SEARCH | VARCHAR2 | 10 | Yes | SEARCH_FIELD_CLR_ON_SEARCH - Is the search field value cleared after a search is performed, allowing clean input for the user next time. | |
| SEARCH_FIELD_SF_ENA_FLAG | VARCHAR2 | 1 | SEARCH_FIELD_SF_ENA_FLAG - Is the 'Search for' link enabled (Y/N). | ||
| SUGGEST_ONLY_FLAG | VARCHAR2 | 1 | SUGGEST_ONLY_FLAG - Does the search field only do suggestions (Y/N)? If 'Y', no Search Engine results are shown and it is assumed that autosuggest is sufficient for search needs. | ||
| SEARCH_CATEGORY_APP_STRIPE | VARCHAR2 | 20 | SEARCH_CATEGORY_APP_STRIPE - an allplication stripe to use if all categories for an application stripe are to be used. | ||
| SEARCH_CATEGORIES | VARCHAR2 | 4000 | SEARCH_CATEGORIES - A CSV list of appid:CAT_NAME | ||
| SAVED_SEARCHES_ENA_FLAG | VARCHAR2 | 1 | Yes | SAVED_SEARCHES_ENA_FLAG - Are saved searches enabled? | |
| RECENT_SEARCHES_ENA_FLAG | VARCHAR2 | 1 | Yes | RECENT_SEARCHES_ENA_FLAG - Are recent searches enabled? | |
| APPLIED_FILTERS_ENA_FLAG | VARCHAR2 | 1 | APPLIED_FILTERS_ENA_FLAG - Are the applied filters shown in the results UI? | ||
| FILTER_SUBCAT_ENA_FLAG | VARCHAR2 | 1 | Yes | FILTER_SUBCAT_ENA_FLAG - Are the subcategory filters shown in the Filters area of the search result? | |
| FILTER_FACETS_ENA_FLAG | VARCHAR2 | 1 | Yes | FILTER_FACETS_ENA_FLAG- Are the facet filters shown in the Filters area of the search result? Subcategories must be enabled for this to be relevant as facets are a child object of subcategories. | |
| FILTER_FACET_CNT_ENA_FLAG | VARCHAR2 | 1 | Yes | FILTER_FACET_CNT_ENA_FLAG - Are the facet counts shown in the Filters area of the search result? Facets must be enabled for this to be relevant. | |
| FILTER_CLEAR_ALL_ENA_FLAG | VARCHAR2 | 1 | Yes | FILTER_CLEAR_ALL_ENA_FLAG - Is the clear all filters button shown in the Filters area of the search result? | |
| FILTER_LOV_STYLE | VARCHAR2 | 10 | Yes | FILTER_LOV_STYLE - The style of filters used, either 'lov' or 'inline'. | |
| LAST_UPDATE_DATE_FILTER | VARCHAR2 | 4000 | LAST_UPDATE_DATE_FILTER - a CSV list of last update date filters to be shown to the user. If this is null, all values are shown. | ||
| RESULT_ICONS_ENA | VARCHAR2 | 10 | Yes | RESULT_ICONS_ENA- Are icons shown in the results UI when available? Vald values 'on' and 'off'. | |
| SUGGEST_GROUPS | VARCHAR2 | 4000 | SUGGEST_GROUPS - a csv list of suggest groups. | ||
| SUGGEST_TOP_SUGGESTIONS_ENA | VARCHAR2 | 10 | Yes | SUGGEST_TOP_SUGGESTIONS_ENA - Are top suggestions on or off? Top suggestions are those suggestions shown before there have been enough characters typed for meaningful suggestions based on the typed values to be shown. | |
| SUGGEST_GRP_HEADINGS_ENA | VARCHAR2 | 10 | Yes | SUGGEST_GRP_HEADINGS_ENA - Are the Suggest group headings shown - valid values 'on' and 'off'. | |
| SUGGEST_GRP_ICONS_ENA | VARCHAR2 | 10 | Yes | SUGGEST_GRP_ICONS_ENA - Are the Suggest group heading icons shown - valid values 'on' and 'off'. | |
| SUGGEST_MIN_CHARS_FOR_SUG | NUMBER | 2 | Yes | SUGGEST_MIN_CHARS_FOR_SUG - The minimum number of characters before search suggest takes over from top suggestions. | |
| SUGGEST_MAX_SUGGESTIONS | NUMBER | 3 | Yes | SUGGEST_MAX_SUGGESTIONS - The maximum total number of suggestions across all groups. This value applied for top suggestions and regular per-key autosuggest. | |
| SUGGEST_SYN_ENA_FLAG | VARCHAR2 | 1 | SUGGEST_SYN_ENA_FLAG - Are synonyms enabled for autosuggest in the search field? | ||
| SUGGEST_SYN_CONTEXT_CODE | VARCHAR2 | 30 | SUGGEST_SYN_CONTEXT_CODE - Optional code for supplying contextural striping for synonyms. | ||
| SUGGEST_SYN_OBJECT_TYPE | VARCHAR2 | 30 | SUGGEST_SYN_OBJECT_TYPE - a sub classification of CONTEXT_CODE for contextural striping for synonyms. | ||
| SEARCH_FACTORY_EXPRESSION | VARCHAR2 | 200 | SEARCH_FACTORY_EXPRESSION - Either a fully qualified class name of an AbstractSearchableFactory an EL expression that creates an AbstractSearchableFactory or null for the default ECSF Factory. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Seed data file from which the row originates. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| fnd_search_view_options | fnd_search_options_b | ENTERPRISE_ID, SEARCH_OPTION_ID |
| fnd_search_options_tl | fnd_search_options_b | ENTERPRISE_ID, SEARCH_OPTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SEARCH_OPTIONS_B_U1 | Unique | Default | ENTERPRISE_ID, SEARCH_OPTION_ID, ORA_SEED_SET1 |
| FND_SEARCH_OPTIONS_B_U11 | Unique | Default | ENTERPRISE_ID, SEARCH_OPTION_ID, ORA_SEED_SET2 |
| FND_SEARCH_OPTIONS_B_U2 | Unique | Default | ENTERPRISE_ID, SEARCH_OPTION_CODE, ORA_SEED_SET1 |
| FND_SEARCH_OPTIONS_B_U21 | Unique | Default | ENTERPRISE_ID, SEARCH_OPTION_CODE, ORA_SEED_SET2 |