Contains audit logs for both V5.0-style processes and processes based on the Business Process Execution Language (BPEL).
Contains audit logs for BPEL-based processes only.
To read the content of the audit trail, use SQL or any other administration tool that supports the reading of database tables and views.
Audit events are related to process entities. The audit event types depend on the entity to which the event refers. The audit event types include:
For a list of the possible audit event type codes, see Process choreographer - audit event types.
The following table describes the structure of the AUDIT_LOG audit trail view. It lists the names of the columns, the event types, and gives a short description for the column. The BPEL column specifies whether the information is also shown in the AUDIT_LOG_B view.
Name | BPEL | PTE | PIE | AIE | VAR | CLE | SIE | Description |
---|---|---|---|---|---|---|---|---|
ALID | x | x | x | x | x | x | x | Internal ID and primary key for a row. |
EVENT_TIME | x | x | x | x | x | x | x | Timestamp of when the event occurred in Coordinated Universal Time (UTC) format. |
AUDIT_EVENT | x | x | x | x | x | x | x | For a list of audit event codes, see Process choreographer - audit event types |
PTID | x | x | x | x | x | x | x | Process template ID of the process that is related to the current event. |
PIID | x | x | x | x | x | x | Process instance ID of the process instance that is related to the current event. | |
PROCESS_TEMPL_NAME | x | x | x | x | x | x | Process template name of the process template that is related to the current event. | |
PROCESS_INST_NAME | x | x | x | x | x | x | Process instance name of the process template that is related to the current event. | |
TOP_LEVEL_PI_NAME | x | x | x | x | Name of the top-level process that is related to the current event. | |||
TOP_LEVEL_PIID | x | x | x | x | x | x | Identifier of the top-level process that is related to the current event. | |
PARENT_PI_NAME | x | x | x | x | x | Name of the parent process instance. | ||
PARENT_PIID | x | x | x | x | x | x | Process instance ID of the parent process, or null if no parent exists. | |
VALID_FROM | x | x | x | x | x | x | x | Valid-from date of the process template that is related to the current event. |
ACTIVITY_NAME | x | x | Name of the activity on which the event occurred. | |||||
ACTIVITY_KIND | x | x | Kind of the activity on which the activity
occurred. It can have the following values. For V5-style (FDML) processes:
For BPEL processes:
These are the constants defined for ActivityInstanceData.KIND_* |
|||||
ACTIVITY_STATE | x | x | State of the activity that is related to
the event. Possible values are:
These are the constants defined for ActivityInstanceData.STATE_* |
|||||
CONTROL_LINK_NAME | x | x | Name of the link that is related to the current link event. | |||||
IMPL_NAME | x | Name of the activity implementation. This is only applicable for elemental activities. | ||||||
PRINCIPAL | x | x | x | Name of the principal that requested the API-call related to the event; applicable for these events (but only if directly called over the API). | ||||
TERMINAL_NAME | x | Name of the fault terminal that is set, applicable for ACTIVITY_SET_FAULT_MESSAGE | ||||||
VARIABLE_DATA | x | x | Data for variables for variable updated events. | |||||
EXCEPTION_TEXT | x | x | x | Exception message that caused an activity
or process to fail. Applicable for:PROCESS_FAILED ACTIVITY_FAILED |
||||
DESCRIPTION | x | x | x | x | x | x | Description of activity or process, containing potentially resolved replacement variables. | |
CORR_SET_INFOR | x | x | The stringified form of the correlation set that was initialized at process start time. | |||||
USER_NAME | x | x | x | The name of the user whose work item has been changed,
applicable for:
|
||||
VARIABLE_NAME | x | x | The name of the variable related to the current event. | |||||
SIID | x | x | The ID of the scope instance related to the event. | |||||
ATID | x | x | The ID of the activity template related to the current event. | |||||
OBJECT_META_TYPE | x | x | x | x | x | x | Specifies whether the audit log refers to a BPEL process
or an V5-style (FDML) process:
|