SVC_EA_EVENTS
To maintain the notifications from events received by Engage Adapter from Fusion Service business objects create, update, and delete events. These events will handle Fusion routing requests and callbacks to and from Engage Adapter and Engage Services.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_EA_EVENTS_PK |
EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_ID | NUMBER | 18 | Yes | Primary key populated from a sequence. | |
| ROOT_EVENT_ID | VARCHAR2 | 64 | The unique identifier to connect event hierarchy. | ||
| EVENT_NUMBER | VARCHAR2 | 64 | Yes | The event public unique identifier. | |
| EVENT_TYPE | VARCHAR2 | 64 | Yes | Indicates the event type triggered by the source service. | |
| SOURCE_EVENT_ID | VARCHAR2 | 64 | The event identifier in the source service. | ||
| EVENT_OWNER | VARCHAR2 | 256 | Indicates the source service of this event. | ||
| OBJECT_NUMBER | VARCHAR2 | 256 | Business object number of the business object that triggered this event. | ||
| INTERACTION_TYPE | VARCHAR2 | 256 | Indicates what type of interaction or business object type associated with this event. | ||
| UWO_ID | NUMBER | 18 | Universal work object unique ID of the routing process associated to the business object. | ||
| PAYLOAD | CLOB | The representation of the payload received in this event. | |||
| STATUS | VARCHAR2 | 64 | Indicates the current status of the process that is received in this event. | ||
| STATUS_MESSAGE | VARCHAR2 | 256 | Any message associated to the status of this event. | ||
| BO_LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time when the business object was last updated in the source service. | |||
| EVENT_CREATION_DATE | TIMESTAMP | Yes | Indicates the date and time when the event originally started in the source service. | ||
| EVENT_LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time when the event was last updated in the source service. | |||
| PARENT_EVENT_ID | NUMBER | 18 | Parent event unique ID. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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 |
|---|---|---|---|
| SVC_EA_EVENTS_N1 | Non Unique | Default | PARENT_EVENT_ID |
| SVC_EA_EVENTS_N2 | Non Unique | Default | SOURCE_EVENT_ID, INTERACTION_TYPE |
| SVC_EA_EVENTS_N3 | Non Unique | Default | ROOT_EVENT_ID, INTERACTION_TYPE |
| SVC_EA_EVENTS_PK | Unique | Default | EVENT_ID |
| SVC_EA_EVENTS_U1 | Unique | Default | UPPER("EVENT_NUMBER") |