ATK_POPUP_ITEMS
Table to store notifications for users delivered by UMS.
Details
-
Schema: FUSION
-
Object owner: ATK
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ATK_POPUP_ITEMS_PK |
MESSAGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MESSAGE_ID | NUMBER | 18 | Yes | Generated Message Identifier. | |
| TASK_ID | VARCHAR2 | 64 | Unique Identifier from SOA | ||
| UMS_MESSAGE_ID | VARCHAR2 | 64 | Message Identifier provided from source of this notification (SOA/CRM). Used for diagnosing any delivery issues. | ||
| USER_GUID | VARCHAR2 | 64 | Yes | User Identifier. This is the user that the message is addressed to. | |
| TASK_DISPLAY_URL | VARCHAR2 | 2000 | This is the drilldown URL for viewing notification details. | ||
| TASK_DETAILS_AVAILABLE_FLAG | VARCHAR2 | 1 | Yes | Flag indicates whether notification details are available in source of this notification (SOA/CRM). | |
| TASK_STATE | VARCHAR2 | 20 | TASK_STATE | ||
| SOA_SERVER | VARCHAR2 | 128 | SOA Server name of the Human Workflow Task created | ||
| SOA_OUTCOMES | VARCHAR2 | 256 | Outcomes for the current Task used to complete custom actions inline | ||
| SOA_OUTCOMES_DISPLAY | VARCHAR2 | 256 | Outcomes names to be displayed to the user as inline custom actions | ||
| TASK_CREATOR | VARCHAR2 | 64 | FROM_USER | ||
| MESSAGE_CREATION_DATE | NUMBER | 18 | Yes | Message creation date in java long format. Indicates when the message was created in source of this notification (SOA/CRM). | |
| MESSAGE_EXPIRY_DATE | NUMBER | 18 | Message expiry date in java long format. Indicates when the message will be expired. | ||
| MESSAGE_SUMMARY | VARCHAR2 | 2000 | Notification summary. | ||
| THINGS_TO_FINISH_STATE | VARCHAR2 | 20 | Indicates whether the notification has to shown in things to finish section or not Valid values are null or HIDE. | ||
| STATUS | VARCHAR2 | 20 | Indicates whether the notification has been viewed by the user. Valid values are READ and UNREAD. | ||
| MSG_CREATION_DB_DATE | TIMESTAMP | Message creation date in database timestamp format. Indicates when the message was created in source of this notification (SOA/CRM). | |||
| SOURCE | VARCHAR2 | 30 | Indicates whether the notification is from SOA for human task delivered by UMS or if its from CRM for Calender Appointment/Task/Reminder. Valid values are 'SOA_HUMAN_TASK' and 'CRM_CALENDAR_APPOINTMENT' | ||
| RENDERED_EXPRESSION | VARCHAR2 | 1024 | Conditional Expression to check if the user has access to the particular Announcement notification or not. | ||
| NOTIFICATION_TYPE | VARCHAR2 | 30 | Indicates the type of Notification. Whether it will open up in a Dialog or Drill Down or no details at all. | ||
| ADDITIONAL_ATTRIBUTES | VARCHAR2 | 2000 | All the additional Attributes passed on from BPM. | ||
| NAVIGATION_URL_KEY | VARCHAR2 | 80 | 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 | The view id (as per the ui shell menu) for the workarea/page that contains the task flow for this notification. | ||
| 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 notification item's drilldown from Notification Bell Popup | ||
| 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 | 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ATK_POPUP_ITEMS_N1 | Non Unique | Default | USER_GUID, "MESSAGE_CREATION_DATE", STATUS |
| ATK_POPUP_ITEMS_N2 | Non Unique | Default | TASK_ID |
| ATK_POPUP_ITEMS_N3 | Non Unique | Default | TASK_CREATOR, TASK_STATE, STATUS, "MESSAGE_CREATION_DATE" |
| ATK_POPUP_ITEMS_N4 | Non Unique | Default | SOURCE, USER_GUID |
| ATK_POPUP_ITEMS_U1 | Unique | Default | MESSAGE_ID |