Tuesday, August 26, 2025

#1081 OCI Log Analytics - Leveraging LoganAI for OIC insights

I've been a great advocate of OCI Log Analytics for a very long time. As you all probably know, it is very easy to push your OIC activity stream logs to OCI Log Analytics. And there the magic begins!

LoganAI is a new capability that allows you to interpret your log data via a chat interface, i.e. no more need for constructing complex MQL queries - just ask and you shall receive!

For those new to OCI Log analytics, I suggest you check out the plethora of posts available here.

For those that want a deep dive into LoganAI first, then check out the excellent post from Kumar here.

All read up? Then let's start with the following project in OIC and the 4 order processing integrations we'll look at -

The integrations themselves are banal - the only one with any logic is validateOrder. 
All 4 integrations have the following tracking fields - orderNr, product, customer. 


I trigger a couple of instances of each integration - 

Now to OCI Log Analytics - 

I query on the OIC activity stream log group - 

'Log Source' = 'OCI Integration Activity Stream Logs' and 'Log Group' = My_OIC_LogGroup | fields -Entity, -'Entity Type', -'Host Name (Server)', -'Problem Priority', -Label, -'Log Source', -'Log Group' | fields 'Integration ID', OICStatus, Message | timestats count as logrecords by Integration | sort -logrecords


Notice the highlighted icon - 

It knows the type of log file were looking at, It tells me that the integrations are related to order processing and it suggests a couple of follow-up questions.

But I have my own questions - 

  • did any integrations fail?
1 integration failed, validateOrder,  and I now have the identifier of that flow and also the reason for the failure - "Invalid Country".

  • what is the orderNr of the failed instance? 
So orderNr 4 failed 

  • How many orders did I process in the last 3 hours?

11 orders? now let me ask a more precise question - 

  • How many orders were created in the last 3 hours?
According to OIC Observability -

What does Log Explorer show?

  • what are the order numbers of the orders created in the last 3 hours?

  • are there any duplicate order numbers for create order?
Looks like we have a duplicate - order nr 3.

  • Did any orders fail validation? 
  • Which order took the longest to fulfill? Please also return the orderNr.
  • give me the orderNr of the order that was fulfilled fastest
  • give me the order numbers of the orders that have passed validation, but have not yet been shipped
Yes, orderNr 2 has been validated, but not yet shipped.

Now I will look at the average execution time of the createOrder flows - 

I check one of the instances in OIC -

There are 2 ways to look at average here, depending on what you take as the starting point. For this case, I will use Wire Message received as the start event. Because this includes the internal wait time. The flow, shown in the screenshot, took 250 msecs.

  • what's the average execution time of the createOrder integration? Use the Message Received action as the start event.
I'm sure you've got the idea at this stage.

Finally, I save the query in Log Explorer

I can now drill into this - 

and click the above icon to start the AI chat.

Summa Summarum

This is a great addition to the wider OIC Observability toolkit. Do check it out and see how easy it really is to drill into your activity stream logs.

Kudos to my OCI Log analytics colleagues Zubair & Kumar - well done guys!



 













 

Friday, August 22, 2025

#1080 OIC 25.08 New Features

25.08 has a plethora of new features.
So, without further ado, let's check some of them out.

Project Creation

It's starts with Project creation.

Here you can do the following - 
  • choose one of the recipes shown
  • enter your requirements in natural language and see what's offered
  • New Project - create your new project from scratch
Here I enter the project requirements - 

I need to synchronise won opportunities from Salesforce with sales orders in Netsuite. I need to create a new sales order for every won opportunity.

Check out the results - 

I can now select this recipe - 

AI Driven Integration documentation 

Many developers are somewhat averse to writing documentation, with 25.08 we have the solution for you!

I've opened the project and started editing the integration -



Also available via the menu - 

New Adapter for Anthropic

Before we actually create the connection, let's chat with Claude - 

I asked Claude to do sentiment analysis on the following email -

I am writing this mail to complain about your sales department. They promised me that my iBike would be shipped within 24 hours. I only received it 3 weeks later. The iBike is great, but your sales and communication sucks.

The result - 

Now back to our Anthropic connection - I just need to add my api key from Anthropic.


What do each of these models offer?

  • Haiku for speed
  • Sonnet for balance
  • Opus for complex reasoning

Let's go thru the target fields - 
  • Role - can be set to user or assistant
I set this to user.
  • Service Tier can be set to auto or standard_only.
I set this to standard_only.

  • max_tokens - default is 1024, I will up this to 2000.
  • system - here I can set the scene for the assistant e.g. you are an expert on analysing the sentiment of emails.

  • temperature - a value from 0.0 to 1.0. 0.0 = deterministic to 1.0 = random, creative.
That's it! So let's run the integration - 

The response - 



File Server Update

There has been a steady uptake of file server by OIC customers. It's a no brainer really, for your file based integration scenarios.

25.08 now includes support for the File Downloaded event. -







B2B

The highlight for me here is the ability to share B2B documents between projects. This brings us very close to our goal of allowing every Project artefact to be shared. The first screenshot shows the creation of the shared B2B document. The second shows it being referenced in a different project - 














Summa Summarum

The above is just some of my highlights for 25.08. Please check out the official Oracle 25.08 post here.