Migrating Search Page Configuration Data Using Application Data Sets
Oracle delivers Application Data Sets (ADS) definitions to copy or migrate configurable search configuration data from one database to another.
For information on using ADS, see Understanding ADS Projects.
Oracle delivers the ADS definition PTS_CFGSRCH for Configurable Search.
The following table lists the Record Names:
|
Record Name |
Description |
|---|---|
|
PS_PTS_SRCH_ASGN |
You can query this table to check whether configuration exists for a particular CREF or not; returns value 'A' if active configuration exists, otherwise returns 'I'. |
|
PTS_CSRCH_FCT PTS_CSRCH_FCT_L |
Stores facet configurations for keyword search. |
|
PS_PTS_SRCH_DEFN |
Common table that stores some of the information about search and add configurations. You can query this table to get information about configured search record/definition, add search record, page title and instructions, maximum number of recent and saved searches, display view options etc. |
|
PS_PTS_SRCH_DTL_S PS_PTS_SRCHDTL_S_L |
Stores search criteria fields for standard search. |
|
PS_PTS_ADD_DTL PS_PTS_ADD_DTL_L |
Stores information about add page fields and their configuration. |
|
PS_PTS_SRCH_DTL_E PS_PTS_SRCHDTL_E_L |
Stores search criteria fields for keyword search. |
|
PS_PTS_LINK_DTL_A PS_PTS_LINK_DTL_S PS_PTS_LINKDTL_A_L PS_PTS_LINKDTL_S_L |
Stores links configured for particular CREF on the Add or Search page. |
|
PS_PTS_SRCH_DEF_L |
Related language table for page title and page instructions. |
Oracle delivers the ADS definition PTS_CSRCH_OPTN for Configurable Search Options.
The following table lists the Record Names:
|
Record Name |
Description |
|---|---|
|
PTS_CSRCH_OPTN |
Stores all system configuration values. |