Migrating Search Page Configuration Data Using Application Data Sets
Oracle delivers an Application Data Sets (ADS) definition, PTS_CFGSRCH, to copy or migrate configurable search configuration data from one database to another.
For information on using ADS, see Understanding ADS Projects.
The following table lists the ADS definitions:
|
ADS Definition |
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'. |
|
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_CFG_SRCH |
Stores information about configured portal object name and associated CREF label. |
|
PS_PTS_LINK_DTL_A PS_PTS_LINK_DTL_S PS_PTS_LINKDTL_A_L PS_PTS_LINKDTL_A_S |
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. |