View Activity Stream Logs in Oracle Log Analytics

Publish human in the loop activity stream logs to Oracle Log Analytics to view them beyond the standard retention period in Oracle Cloud Console. Oracle Log Analytics provides long-term log retention for auditing and compliance, along with dashboards that help you analyze workflow activity, identify trends, and troubleshoot workflow issues.

Prerequisite: Before you can view activity stream logs in Oracle Log Analytics, complete the required configurations and enable publishing of logs to Oracle Log Analytics in the Oracle Cloud Console. See Enable the Option to Publish Human in the Loop Logs to Oracle Log Analytics in Provisioning and Administering Oracle Integration 3.

Topics:

• About Activity Stream Logs Published to Oracle Log Analytics
• View Activity Stream Logs

About Activity Stream Logs Published to Oracle Log Analytics

Activity stream logs are generated and published to Oracle Log Analytics for the following state changes of workflow and its components.

• Workflow: Created, Completed, Faulted
• Start Event: Created, Completed
• Task: Created, Unassigned, Assigned
• End Event: Created, Completed
• If Else: Created, Completed

Activity stream logs are published in JSON format to Oracle Log Analytics. The predefined parser for human in the loop activity stream logs is used to parse the JSON log source file into log entries, and then parse those log entries into Oracle Log Analytics fields. The table below gives the mapping between JSON field names and the Log Analytics field names.

JSON Field	Log Analytics Field	Data Type	Description
time	Time	TimeStamp	Time stamp at which the log record was captured in human in the loop activity stream.
processDefinitionId	Definition	String	Unique identifier (GUID) of the deployed workflow.
processDefinitionName	Process Name	String	Name of the workflow.
processDefinitionKey	Key	String	Key identifier of the corresponding workflow which is in the format <OICProjectID>--<WorkflowVersion>--<WorkflowName>
processDefinitionVersion	Version	String	Workflow version
processInstanceState	Process State	String	State of the workflow record.
processInstanceId	Instance	String	Unique identifier (GUID) of the specific running or completed workflow instance.
activityType	Event Type	String	Type of workflow activity being executed (for example, task, start event, end event, and so on)
activityInstanceState	Event State	String	Current state of the activity instance (For example, Created, Assigned, Completed, and so on).
startTime	Start Time	TimeStamp	Date and time when the activity instance began execution.
endTime	End Time	TimeStamp	Date and time when the activity instance completed.
activityInstanceId	Event Instance ID	String	Unique identifier (GUID) of the specific execution instance of a workflow activity.
activityId	Event ID	String	Unique identifier (GUID) of the activity as defined in the workflow model.
activityName	Event	String	Name of the workflow activity.
userTaskOutputPayload.taskExec.approverDisplayName	Approver	String	Display name of the user who approved or acted on the task.
userTaskOutputPayload.taskExec.approver	Approver ID	String	ID of the user who approved or acted on the task.
assigneeName	Assignee	String	Display name of the user or group currently assigned to the task.
assigneeId	Assignee ID	String	Unique identifier of the user or group assigned to the task.
assigneeType	Assignee Type	String	Type of assignee, such as User or Group.
taskId	Task ID	String	Unique identifier of the task instance.
oicProjectId	Project ID	String	Unique identifier of the Oracle Integration project containing the workflow.
updatedTime	Update Time	TimeStamp	Date and time when the task or activity was last updated.
candidateUsersAndGroups.[*].name	User Names	String, Multi-valued	Names of a users or groups who can claim and take action on the task.
processInstanceDuration	Duration	Float	The total time taken by the process instance from start to completion.
activityInstanceDuration	Event Duration	Float	Total time taken by the activity instance.
taskOutcome	Result	String	Final outcome of the task (for example, Approve, Reject or Submit).
faultCode	Error ID	String	Error or fault code associated with the activity or task execution, if any.
taskSubtype	SubType	String	Subtype or classification of the task.
activityInstanceSubState	Sub Status code	String	More detailed status of the activity instance.
userTaskOutputPayload.taskExec.approverComment	Comment	String	Comments provided by the approver while completing the task.
candidateUsersAndGroups[*].type	User Types	String, Multi-valued	Types of candidate assignee, such as Users and Groups.
deploymentId	Deployment ID	String	Unique identifier (GUID) of the deployed workflow corresponding to the activation.
serviceInstanceOCID	OCI Resource OCID	String	Oracle Cloud Identifier (OCID) of the service instance where the workflow is deployed.

View Activity Stream Logs

1. Sign in to the Oracle Cloud Console.
2. From the navigation menu, select Observability & Management, and then under Log Analytics select Log Explorer.

   The Log Explorer page (with the default query) opens.

   
   

   

   
   

   The visualization type, log source, and total count of log records are displayed on the main pane.

3. To view details of the log records, right-click the log source link OIC Integration – HITL Activity Stream Logs and select Drill down.

   Each log record is displayed in the original JSON format in which it is published.

   • Click the more... link at the end of a log record to view the JSON log record with the parsed log entries in a separate pane.
   • Expand Log Source to view the Log Analytics fields created from the parsed log entries.
4. On the top right of the Log Explorer page, select a time range in the drop-down field, and then click Run.
   Log records from the selected time range are displayed.
5. On the left Fields pane, expand Pinned and Other to view all the Log Analytics fields created from the log records.
6. Create custom queries using various filter criteria from the Log Analytics fields. See Filter Logs by Pinned Attributes and Fields in Oracle Log Analytics documentation.

   You can also use the query language commands supported in Oracle Log Analytics to perform specific actions on the search results. See Query Language Command Reference in Oracle Log Analytics documentation.