Monitoring Workflow Transactions

This topic describes how to use the Manage Process Instances page to resolve discrepancies between the Public Sector Compliance and Regulation system and the Oracle Integration Cloud instance (OIC).

Working with Workflow Transaction Logs

During normal transaction processing, it’s possible that either the Oracle Integration Cloud instance or the Oracle Public Sector instance can become momentarily unresponsive. While a rare occurrence, you need to be able to resolve any transactions that occurred during the down time to make sure the OIC instance and your Public Sector offering are synchronized.

For example, if OIC is unresponsive for a five minute period according to your system logs and notification system, you can use the Manage Process Instances page to isolate any transactions that occurred specifically during that time to make sure individual transaction statuses are in sync with the associated workflow process.

Note: In some cases, if OIC is momentarily unavailable, a process instance won't be assigned to an application. In this situation, a background process periodically checks for missing process instances and assigns them accordingly. While the application has no process instance assigned, its status will be set to Pending Submittal. For more information on the Pending Submittal status see "Managing Application Activity" in Managing Transactions.

Using the Mange Process Instances Page

Use the Details page to search for transactions created during a specific time range.

Access the Mange Process Instances page by selecting Workflow and Transaction Log > Manage Process Instances.

Page elements on the Mange Process Instances page.

Page Element

Description

Which system is restored

Select the system that was not available for a period of time and needed to be restored from a back up. Options are:

  • Public Sector Licensing and Permitting: select if the Public Sector Licensing and Permitting system was down.

  • OIC: select if the Oracle Integration Cloud instance was down.

If one of the systems is unavailable for a given period and needed to be restored, then the other system becomes the most current source of transaction status for any manual synchronization.

From/To

Use the date/time controls to specify a time range for isolating the affected transactions.

Workflow Instance ID

The workflow instance ID assigned for a specific transaction by the OIC system when that transaction is submitted.

Process Status

The current status of the process, such as CANCELLED, OPEN, COMPLETED, and so on.

Transaction

The unique ID of a specific submitted transaction, which is comprised of the topic type and the auto number rule.

Transaction Status

The current status of the individual transaction according to the corresponding workflow process definition, such as Submitted, Inspection, Plan Review, and so on.

Process Definition

The workflow process definition in OIC to which the specific transaction is associated. This value is comprised of the OIC instance name, the space name, and the workflow process application name as defined in OIC.

Transaction Update Date

The last time the transaction was updated.

Process Update Date

The last time the process was updated.

Using the Details Page

Use the Details page to drill into a specific transaction and take action to resolve any discrepancies between the OIC and Public Sector Licensing and Permitting systems. The Details page contains the transaction history in sequential order between the two systems for a given transaction.

Access the Details page by clicking on any row in the grid on the Manage Process Instances page.

This example illustrates sample data as it would appear in the Details page.

Inconsistent Instances Details page

At the top of the Details page the Oracle Integration Cloud and the Oracle Public Sector Compliance and Regulation sections display a high-level view of the current status for that transaction in the respective systems.

Depending on the information displayed, you may elect to perform different actions, which appear as buttons on the right hand side of the Details page.

Details page actions

Page Element

Done

Closes the Details page with no action taken. Equivalent to Cancel.

Cancel Workflow

Cancels the transaction association with the underlying workflow so the transaction can be resubmitted. All previous work would be lost.

Alter Workflow

Enables the system administrator to alter the workflow manually to ensure both systems are in sync in the event of an momentary unavailability of either system.

For more information on the options when altering workflow, see Using Workflow.

Resubmit Application

Enables the system administrator to resubmit an application.

Page elements on the Details page high-level section.

Page Element

Description

Process ID

The workflow instance ID assigned for a specific transaction by the OIC system when that transaction is submitted.

Transaction ID

The unique ID of a specific submitted transaction, which is based on the auto number rule.

Applicant ID

The unique ID of the applicant who submitted the transaction intake form.

Transaction Type

The transaction type as defined on the Transaction Type page. For example, for a permit this will be the Permit Type value.

Last Task

The last task in the workflow process definition that the transaction has reached. (Applies only to the OIC system.)

Last Action Taken

The action taken on the last task. (Applies only to the OIC system.)

Transaction Status

The current status of the transaction reflected in the Public Sector Licensing and Permitting system, such as In Process, Accepted, and so on.

Page elements on the Details page grid section.

Page Element

Description

Service Type

Indicates what service handled the request. Options are:

  • Public Sector Licensing and Permitting: indicates the Public Sector system.

  • OIC: indicates the Oracle Integration Cloud instance.

Task Information

The task information associated with the task defined in the workflow process definition.

Assigned By

The user name of the individual to who assigned the current task to the assignee.

Assigned To

The user name of the individual to whom the current task is assigned.

Updated By

The user name of the individual who updated the task.

Task Creation Date

The date and time the task in the workflow process definition was initiated for the current transaction.

Last Action Taken

The last action taken as reflected in the OIC system.

Transaction Status

The status of the transaction reflected in the Public Sector Licensing and Permitting system.

Last Updated Date

The date and time when the transaction was last updated.

Using the Workflow List

Supervisors and system administrators can use the Workflow List page to review in-process workflow instances and manage the process as needed, such as altering workflow.

To access the Workflow List page, select the Workflow List tile on the agency springboard.