ATK_WATCHLIST_CATEGORIES
Watchlist Category Seed Data Table: each category will be created by the owning product team as a lookup type in "Standard" lookups (VIEW_APPLICATION_ID = 0 and SET_ID = 0). The watchlist items belonging to each category will be created as lookup values in these lookup types.
Details
-
Schema: FUSION
-
Object owner: ATK
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ATK_WATCHLIST_CATEGORIES_PK |
WATCHLIST_CATEGORY_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WATCHLIST_CATEGORY_CODE | VARCHAR2 | 100 | Yes | Watchlist Category Code: unique code based on LBA Prefix. | |
| MODULE_ID | VARCHAR2 | 32 | 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. | ||
| CATEGORY_LOOKUP_TYPE | VARCHAR2 | 30 | Yes | Category Lookup Type: reference to FND_STANDARD_LOOKUP_TYPES.LOOKUP_TYPE based on the seeded lookup type with meaning for category (VIEW_APPLICATION_ID = 0 and SET_ID = 0). The translated lookup type meaning is shown in the watchlist UI for category. | |
| OWNING_MODULE_NAME | VARCHAR2 | 4000 | Yes | Owning Module Name: reference to FND_APPL_TAXONOMY.MODULE_NAME for the owning product/module. This is used for seed data purposes. | |
| OWNING_APPLICATION_ID | NUMBER | Yes | Owning Application Identifier: reference to FND_APPL_TAXONOMY.ALTERNATIVE_ID for the owning product/module. This is used for seed data purposes. | ||
| SECURITY_POLICY_STRIPE | VARCHAR2 | 10 | Yes | Indicates the security policy stripe for the owning application. Valid values are fscm, hcm, crm | |
| REFRESH_SERVICE_ENDPOINT_KEY | VARCHAR2 | 80 | Yes | Refresh Service Endpoint: indicates the key to determine the host, port, context root, etc. to construct the url for service endpoint (wsdl location). Reference to FND_DEPLOYMENTS.DEPLOYMENT_NAME . This is used for the applcore lookup api that will be used for determining the end point. | |
| REFRESH_SERVICE_NAME | VARCHAR2 | 400 | Yes | Refresh Service Name: indicates the service that needs to be invoked for count calculation (for refreshing the items in this category). | |
| REFRESH_SERVICE_NAMESPACE | VARCHAR2 | 2000 | Yes | Refresh Service Namespace: indicates the target namespace from the wsdl for the service that needs to be invoked for count calculation (for refreshing the items in this category). | |
| ENABLED | VARCHAR2 | 1 | Yes | Enabled Flag: indicates if this watchlist category is enabled/active. | |
| SHOW_STALE_COUNTS_FLAG | VARCHAR2 | 1 | Flag to indicate whether watchlist item counts ar shown to the user for this category when counts are considered stale(age of the count is more than the twice of the refresh age). By default, counts are always shown. This flag is set to N for external users. | ||
| REFRESH_SERVICE_PORT_NAME | VARCHAR2 | 400 | Refresh Service Port Name: indicates the name of the service port that is invoked. This name can be obtained from the port name present in the WSDL of the service being invoked. If no port name is specified, then the port name is considered as "<Refresh Service Name>SoapHttpPort" where "<Refresh Service Name>" is the name of the service as seeded in the column REFRESH_SERVICE_NAME of this table. | ||
| 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_CATEGORIES_N1 | Non Unique | Default | WATCHLIST_CATEGORY_CODE, CATEGORY_LOOKUP_TYPE, REFRESH_SERVICE_NAME, ENABLED, SHOW_STALE_COUNTS_FLAG |
| ATK_WATCHLIST_CATEGORIES_PK | Unique | Default | WATCHLIST_CATEGORY_CODE, ORA_SEED_SET1 |
| ATK_WATCHLIST_CATEGORIES_PK1 | Unique | Default | WATCHLIST_CATEGORY_CODE, ORA_SEED_SET2 |
| ATK_WATCHLIST_CATEGORIES_U1 | Unique | Default | WATCHLIST_CATEGORY_CODE, CATEGORY_LOOKUP_TYPE, ORA_SEED_SET1 |
| ATK_WATCHLIST_CATEGORIES_U11 | Unique | Default | WATCHLIST_CATEGORY_CODE, CATEGORY_LOOKUP_TYPE, ORA_SEED_SET2 |