#1133 OIC Agent for Scheduled Integrations

Introduction

This is a customer ask - How could an agent simplify the management of OIC scheduled integrations?
I started thinking, very dangerous at my age, but sometimes it has to be done. What sort of management tasks are we talking about? I came up with the following, to begin with -

• Monitoring- how many runs of integration NN in the last day?
• how many successful?
• how many errored?
• has the execution time increased?
• if so, why?
• Management
• stop a schedule - aborts current run, no new runs can be submitted
• start a schedule
• pause a schedule - allows current run to complete, no new runs can be submitted
• update a schedule

To do this within the context of AI Agents, I need tools; tools that leverage the OIC factory api.

These tools are integrations, here are some of them -

 

I begin with the following - 

• Get Schedule - for a specific integration
• Stop Schedule - for a specific integration
• Start Schedule - for a specific integration
• Update Schedule - for a specific integration
• Retrieve Integration Instances - for a specific integration
• Retrieve Activity Stream - for a specific integration

I also include a simple scheduled job as our guinea pig - 

All it does is wait NN secs. The duration is determined by a schedule parameter. Each run increased the wait parameter by 300 secs.

Monitoring

Now to my agent - it has the following tools - 

and the following guidelines - 

I ask the following - 

get me the start and end times for all the runs of integration ONBOARDING_RUN, with version number 01.00.0000 from the project AA_SCHEDULEJO_AGENT in the last day (1d). If you see execution time is increasing then check and tell me what is happening.

The agent response -

Net, net - the Wait action is taking longer over time. 

I ask - how can I fix this? And I get some cogent suggestions.

I then ask - will my future runs be impinged, if I don't fix this? And I get a positive response - yes, the current schedule of every 10 minutes will not be adhered to. I'm again advised to fix the problem. 

However, I'm from LOB so what I want to do now is just change the schedule to every 45 minutes. I don't have access to OIC, but, I do have my tried and trusted agent.

My agent has been augmented with a tool - Invoke Approval Workflow. This is implemented as an integration that invokes HITL (Human-in-the-Loop). 

Managing

The agent needs to be able to do the following, in the case of updating an integration schedule.

• accept the update request from the user
• invoke HITL to get OIC Admin approval
• if approved
• check if the schedule is active
• if active
• then stop the schedule
• update the schedule
• start the schedule

Human-in-the-Loop (HITL) in Oracle Integration Cloud (OIC) is a functionality that enables, manages, and automates human interaction with agentic AI workflows. It allows for the integration of human judgment, approval, and oversight into automated processes to improve accuracy, safety, and compliance.

For more background, Raison d'être etc. - please check out the detailed post from my esteemed colleague, Stan.

To implement HITL, I need a UI (form) and a workflow(who should approve what etc.).

Let's check out the form, this is the UI you know and love from OIC Process.

Now to the Workflow - this is essentially the Human Task from OIC Process.

I define the input payload - 

Here's the response payload - 

Now to the Human Task - 

Here I assign the UI the use, my form, of course! I also define the possible outcomes e.g. APPROVE, REJECT. I can set the task title; this will be surfaced in the Workspace app. Finally, I define the assignee - 

Yours truly, in this case.

The Data Associations ensure the workflow input is surfaced in the form, as well insuring the task outcome is returned.

This Workflow needs to be wrapped in an integration - 

Note, the integration is async.

This integration is then exposed as an agent tool.

Now to the agent, which now has 8 tools -

The agent guidelines have been augmented for the update schedule use case - 

Testing this out

The current schedule is as follows - 

every 10 minutes. Let's request this be upped to 30 minutes.

update the schedule for the integration ONBOARDING_RUN, version 01.00.0000, in project AA_SCHEDULEJO_AGENT. Set the schedule to MINUTELY, every 30 minutes

Note, the human approval has been invoked, so let's move to Process Workspace and check out the request.

Then click on Tasks - 

Note the buttons top right - 

I click Approve - then return to project observability for the agent - 

As you can see, the agent has received the response from HITL; the OIC admin has approved the request to update the schedule. The next steps the agent executes are - 

GET_SCHEDULE - to check if the schedule is active.

It is active so the agent now calls the STOP_SCHEDULE tool -

We also see the UPDATE_SCHEDULE and START_SCHEDULE tools have been invoked.

Finally, I see the agent summary and the quote from Marcus Aurelius - 

Summa Summarum

What I've described is a very simple example of using an AI Agent to manage and monitor scheduled integrations. It is, naturally, a simple POC, combining integration based tools that leverage the OIC factory api, along with our HITL feature.

I can envisage the productization of such within OIC itself, but that's for another day/release etc. 

Finally, let's check out our updated schedule -