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.
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
.
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:
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.

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.
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 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 Element |
Description |
---|---|
Service Type |
Indicates what service handled the request. Options are:
|
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.