DOO_EVENT_DETAILS
This table defines the details of the criteria that control whether or not to raise a business event when that criterion is met. This applies to fine-grained business events such as Jeopardy, Orchestration Order Status Update, and Orchestration Order Update.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
DOO_EVENT_DETAILS_PK |
EVENT_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_DETAIL_ID | NUMBER | 18 | Yes | Unique Identifier of the Event Details. | |
| EVENT_CRITERIA_ID | NUMBER | 18 | Yes | Generic reference to the detailed criteria that needs to be evaluated as a precondition for raising a business event. For the Jeopardy business event, this refers to a specific jeopardy priority value whose event enabled setting is controlled by the record. In the case of the Orchestration Order Status Update business event, this refers to a specific value of the orchestration order status while for the Orchestration Order Update business event, it refers to a specific attribute in DOO_OBJECT_ATTRIBUTES_B. | |
| EVENT_CODE | VARCHAR2 | 30 | Yes | Refers to the business event trigger point to which the event details are applicable. Thus this property distinguishes records applicable to Jeopardy, Orchestration Order Status Update, and Orchestration Order Update business events from each other. | |
| EVENT_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether the business event corresponding to the EVENT_CODE is enabled for the detailed criteria referenced by the EVENT_CRITERIA_ID. If the value is ???Y???, then a business event would be raised when the event criteria is met during order orchestration. | ||
| EVENT_EMAIL_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether the business event corresponding to the EVENT_CODE is enabled for sending automatic email notifications. If the value is Y, then an email notification is sent when this business event is raised | ||
| 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. | ||
| 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 |
|---|---|---|---|
| DOO_EVENT_DETAILS_N1 | Non Unique | Default | UPPER("EVENT_CODE"), UPPER("EVENT_ENABLED_FLAG") |
| DOO_EVENT_DETAILS_PK | Unique | Default | EVENT_DETAIL_ID, ORA_SEED_SET1 |
| DOO_EVENT_DETAILS_PK1 | Unique | Default | EVENT_DETAIL_ID, ORA_SEED_SET2 |
| DOO_EVENT_DETAILS_UK1 | Unique | Default | EVENT_CRITERIA_ID, EVENT_CODE, ORA_SEED_SET1 |
| DOO_EVENT_DETAILS_UK11 | Unique | Default | EVENT_CRITERIA_ID, EVENT_CODE, ORA_SEED_SET2 |