FFS_MSG_AGENT
Stores a list of delivery channels.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_MSG_AGENT_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 10 | Yes | An unique ID of outbound_configuration. | |
| STATUS | VARCHAR2 | 5 | The external interface status . | ||
| IS_EXTERNAL | VARCHAR2 | 5 | Is External System. Values - 'false', 'true'. | ||
| NAME | VARCHAR2 | 1020 | The External Interface Name. Madatory unique field. | ||
| DESCRIPTION | VARCHAR2 | 1020 | The server description (optional). | ||
| METHOD | VARCHAR2 | 15 | The Message Sending Method. Values - 'email', 'external_system', 'bics', 'dbaas', 'ics', 'oac', 'ocx', 'knowledge', 'oce', 'okm', 'hcm', 'ocm', 'oci', 'fusion', 'oauth'. | ||
| SUBMETHOD | VARCHAR2 | 40 | Additional identifier for message method 'external_system'. | ||
| DETACH | VARCHAR2 | 5 | This flag defines if the a standalone thread should be used to process messages of this type (values: 1 - yes, 0 - no) . | ||
| PATTERN | VARCHAR2 | 4000 | The SOAP message content template. Please note that the message pattern can also be defined using the Agent tag body. . | ||
| BULK_SIZE | NUMBER | 10 | Yes | The maximal number of messages per request . | |
| HAS_GET_INFO | VARCHAR2 | 5 | This flag defines if the agent supports the get_info SOAP function (1 - yes, 0 - no) . | ||
| SEND_MESSAGE_SOAP_ACTION | VARCHAR2 | 1020 | It is the value of the 'SOAPAction' header for the send_message call. (NONE - suppress the header) . | ||
| DROP_MESSAGE_SOAP_ACTION | VARCHAR2 | 1020 | It is the value of the 'SOAPAction' header for the drop_message call. (NONE - suppress the header) . | ||
| GET_MESSAGE_STATUS_SOAP_ACTION | VARCHAR2 | 1020 | It is the value of the 'SOAPAction' header for the get_message_status call. (NONE - suppress the header) . | ||
| TLS | VARCHAR2 | 5 | Message agent TLS encyption flag. | ||
| TLS_VERSION | VARCHAR2 | 7 | It defines a security protocol to be used for the HTTPS connection. (works if tls = 1; default - auto select) . | ||
| COMPANY_ID | VARCHAR2 | 1020 | Deprecated. Will be removed soon. | ||
| WATERMARK | TIMESTAMP | Yes | Datetime of the last modification. | ||
| DISABLE_WEAK_PASSWORD_HASH | NUMBER | 3 | Yes | Obsolete field that specified whether the MD5 algorithm hash is used to validate the password. MD5 algorithm is not used for hashing anymore. | |
| ALLOW_HTTP_BASIC | NUMBER | 3 | Yes | Allow to send http basic authentication headers. | |
| HTTP_VERSION | VARCHAR2 | 20 | Yes | HTTP version for delivery channel. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_MSG_AGENT_PK | Unique | DATA | ID |
| FFS_MSG_AGENT_U1 | Unique | DATA | NAME |
| FFS_MSG_AGENT_U2 | Unique | DATA | METHOD, SUBMETHOD |