ATK_WATCHLIST_SETUP
Watchlist Seeded Items Reference Data This table stores the reference/seed data for watchlist items and is used for item count calculation. The translation for item name is using FND_LOOKUPS. This table needs to contain data for all watchlist items (even user created saved search items - the item code needs to be passed when calling the watchlist api during saved search promotion to watchlist).
Details
-
Schema: FUSION
-
Object owner: ATK
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ATK_WATCHLIST_SETUP_PK |
WATCHLIST_ITEM_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WATCHLIST_ITEM_CODE | VARCHAR2 | 100 | Yes | Watchlist Item Identifier. | |
| ITEM_LOOKUP_CODE | VARCHAR2 | 30 | Item Lookup Code: reference to FND_LOOKUPS.LOOKUP_CODE . Product teams to seed lookup code with meaning for the parent category lookup type. The translated lookup meaning is shown in the watchlist ui with the count appended. Required if WATCHLIST_ITEM_TYPE != USER_SAVED_SEARCH. | ||
| CATEGORY_CODE | VARCHAR2 | 100 | Yes | Category Code: reference to ATK_WATCHLIST_CATEGORIES.WATCHLIST_CATEGORY_CODE . | |
| WATCHLIST_ITEM_TYPE | VARCHAR2 | 20 | Yes | Defines the watchlist item type. Valid values are: SEEDED_QUERY (Seeded Query) SEEDED_SAVED_SEARCH (Seeded Saved Search) USER_SAVED_SEARCH (User-created Saved Search) TXN_FLOW_BASED (Transaction Flow Based - product teams calculate and pass the count) HUMAN_TASK (Worklist Based - count is determined by calling worklist api) | |
| DRILLDOWN_VIEW_PAGEDEF | VARCHAR2 | 600 | Yes | This defines the complete page definition path for the drilldown workarea page and is used for checking security. The watchlist item is visible only if the user has region permission to view this page. | |
| HUMAN_TASK_DEF_ID | VARCHAR2 | 200 | Human Task Definition Identifier. Required if WATCHLIST_ITEM_TYPE = HUMAN_TASK | ||
| HUMAN_TASK_STATE | VARCHAR2 | 100 | Human Task State Identifier. Required if WATCHLIST_ITEM_TYPE = HUMAN_TASK | ||
| REFRESH_AGE | NUMBER | 9 | Yes | Defines the age for item count in seconds. After this many seconds have passed since the last refresh time, the watchlist UI would issue count recalculation request. Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK) . | |
| VIEW_OBJECT | VARCHAR2 | 400 | Complete path of the View Object that needs to be executed for count calculation. Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK). | ||
| SUMMARY_VIEW_ATTRIBUTE | VARCHAR2 | 400 | Indicates the VO attribute name if using a summary view object for watchlist count calculation (on execution, this VO returns only one row with the watchlist item count). Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK) and this is a summary VO. | ||
| APPLICATION_MODULE | VARCHAR2 | 400 | Complete path of the Application Module that contains the View Object instance that needs to be executed for count calculation. Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK) . | ||
| AM_CONFIG_NAME | VARCHAR2 | 400 | The AM Configuration Name for creating an instance of the Application Module from code. This is typically AMLOCAL. Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK) . | ||
| VIEW_OBJECT_INSTANCE | VARCHAR2 | 400 | The Instance Name for the View Object in the Application Module. Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK) . | ||
| VIEW_CRITERIA_ID | VARCHAR2 | 400 | The View Criteria that needs to be applied when executing the VO. Required if WATCHLIST_ITEM_TYPE NOT IN (TXN_FLOW_BASED, HUMAN_TASK) . | ||
| NAVIGATION_URL_KEY | VARCHAR2 | 80 | Yes | This is the key to determine the host, port, context root, etc. to construct the url for the UI drilldown from watchlist item. Reference to FND_DEPLOYMENTS.DEPLOYMENT_NAME . This will be used for the applcore ui shell navigate api that will be used for UI navigation across applications. | |
| VIEW_ID | VARCHAR2 | 400 | Yes | The view id (as per the ui shell menu) for the workarea/page that contains the task flow for this watchlist item's drilldown from Watchlist UI. | |
| PAGE_PARAM_LIST_STRING | VARCHAR2 | 400 | Parameters list for the page. If the target workarea page accepts page parameters, this is a semicolon delimited String of name value pairs. | ||
| TASKFLOW_ID | VARCHAR2 | 400 | The task flow for this watchlist item's drilldown from Watchlist UI. | ||
| TF_KEY_LIST_STRING | VARCHAR2 | 400 | Key list to pass into the task flow to open in the target workspace. This is a semicolon delimited keys or key-value pairs. For example, "key1;key2=value2". | ||
| TF_PARAMETER_STRING | VARCHAR2 | 400 | Parameters list to pass in to the task flow to open in the target workspace. This is a semicolon delimited String of name value pairs. For example, "param1=value1;param2=value2" For user created saved search, the view criteria id will be appended to this string (the string will need to end with <paramName>= for saved search). Required if WATCHLIST_ITEM_TYPE IN (SEEDED_SAVED_SEARCH, USER_SAVED_SEARCH) . | ||
| TASK_TAB_LABEL | VARCHAR2 | 400 | Yes | Label for the task flow to open in the target workspace. This should be an EL expression with fully qualified resource bundle reference within the target application. | |
| ENABLED | VARCHAR2 | 1 | Yes | Enabled Flag - indicates if this watchlist item is enabled/active. | |
| 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ATK_WATCHLIST_SETUP_N1 | Non Unique | Default | WATCHLIST_ITEM_CODE, ITEM_LOOKUP_CODE, CATEGORY_CODE, WATCHLIST_ITEM_TYPE, REFRESH_AGE |
| ATK_WATCHLIST_SETUP_PK | Unique | Default | WATCHLIST_ITEM_CODE, ORA_SEED_SET1 |
| ATK_WATCHLIST_SETUP_PK1 | Unique | Default | WATCHLIST_ITEM_CODE, ORA_SEED_SET2 |
| ATK_WATCHLIST_SETUP_U1 | Unique | Default | WATCHLIST_ITEM_CODE, CATEGORY_CODE, WATCHLIST_ITEM_TYPE, ORA_SEED_SET1 |
| ATK_WATCHLIST_SETUP_U11 | Unique | Default | WATCHLIST_ITEM_CODE, CATEGORY_CODE, WATCHLIST_ITEM_TYPE, ORA_SEED_SET2 |