#1139 - AI Database Private Agent Factory

I am revisiting Private Agent Factory, after a couple of months, and notice lots of new features.

As to be expected, my focus is on how easy it is for this AI Agent framework to leverage OIC tools; so that is where I'll begin.

As you can see, It's simple to create a connection to my OIC based MCP Server - 

The OIC MCP Server allows access to my order processing agentic tools, which execute tasks, such as create order in Netsuite, create order in SAP etc. 

The MCP Server configuration requires client id, secret etc. For this, I created a new integrated application (confidential app) in IDCS.

I added the usual OIC instance scopes -

The MCP Server configuration in PAF - 

then add the usual OIC scopes - 

Then save and authorize - 

Let's go through some more Settings -

I'm using the OCI GenAI based grok model.

Enable SSO - in my case, this allows me to grant transparent access to the users in my IDCS domain. This greatly simplifies use management -  

Define Data Sources -

 

Now let's create an Agent - 

I use the following Custom instructions: 

### Order Processing Steps

the processing steps are as follows -

1. check for duplicates - use the get order tool for this

2. validate the order - use the validate order tool for this

3. check inventory to ensure product ordered is in stock - use the check inventory tool for this

4. create order in ERP system - for Irish orders use Netsuite, for German orders use SAP

5. email confirmation to customer - use the notify customer tool for this

6. finally, detail exactly what you did and end with a quote from the great stoic, Marcus Aurelius

Test in Playground -

I test with the following input - 

create order with the order number 310138 for Ireland customer Niall Mac Cumascaigh, for the product, iBike, price is 4567. Customer email is niall.commiskey@oracle.com

OIC Tools are invoked - 

No output is shown, so let's add chat output - 

I run again - 

I check my email - 

Now lets process new orders from our Orders DB - 

The workflow design is as follows - 

Note the use of the SQL Query component - this will execute the SQL to retrieve new orders - 

SELECT   orderNr,  customer,  email,

  country,  orderDate,  status,  product,

  price

FROM orders

WHERE status = 'NEW'

  AND NVL(processed_flag,'N') = 'N'

ORDER BY orderDate

The Agent Custom instructions have been updated as follows - 

### Order Processing Steps

Process the orders provided in the input from the SQL Query step using the Order Processing Steps.

The processing steps are as follows -

1. check for duplicates - use the get order tool for this

2. validate the order - use the validate order tool for this

3. check inventory to ensure product ordered is in stock - use the check inventory tool for this

4. create order in ERP system - for Irish orders use Netsuite, for German orders use SAP

5. email confirmation to customer - use the notify customer tool for this

6. finally, detail exactly what you did and end with a quote from the great stoic, Marcus Aurelius

Let's test this in Playground - 

Tool execution starts and the 3 orders are created in Netsuite -

..and so on.

All well and good, you may say; another variation on a theme. So why consider using this specific agent framework?

Why choose Private Agent Framework?

While Oracle offers several agentic frameworks, Private Agent Factory is uniquely designed for organizations that want to build AI where their data already lives. If your goal is to create high-performance, data-centric agents—specifically for structured data analysis or knowledge-based RAG—PAF is the definitive choice.

Why it stands out:

Deep Database Synergy: Unlike generic frameworks, PAF treats Oracle AI Database features as first-class citizens. You get immediate, native access to new database-level AI innovations as soon as they drop.

OOTB Intelligence: It ships with pre-built, "ready-to-work" agents designed for the most common enterprise needs, such as deep knowledge search and complex data analytics.

Fortified Data Privacy: Security isn't an afterthought. PAF runs on a compute node within your own tenancy, ensuring sensitive business data never leaves the OCI perimeter. It inherits the robust, multi-layered security protocols of the Oracle AI Database.

Democratized AI (No-Code): You don't need a team of developers to get started. Its intuitive no-code interface allows "citizen developers" and business analysts to build and deploy sophisticated agents alongside technical teams.

Uncompromising Flexibility: You get the best of both worlds: the high-speed performance of a native Oracle stack and the freedom to choose your preferred LLM—whether it's OCI Generative AI or a local model.

Niall's Verdict: If you need to turn your private enterprise data into an actionable AI workforce without the overhead of moving data or writing complex glue code, Private Agent Factory is your go-to framework.

Summa Summarum

Private Agent Factory is Oracle’s premier framework for building secure, data-centric AI agents directly within the enterprise data perimeter. It bridges the gap between raw business data and actionable AI by integrating agentic logic directly into the Oracle AI Database stack.

These agents can easily leverage OIC based tools, for integrating with enterprise apps and technologies; this is our sweet spot, with our 130+ adapters.