Search 800 + Posts

Jun 14, 2026

An IT Architect's Guide to Implementing the Oracle Analytics Cloud AI Agent

What happens after the Business Analyst hands you the design — ADW views, ODI pipelines, dataset governance, security, and everything the agent needs to actually work in production.

This is Part 2 of a two-part series on OAC AI Agent design. Part 1 — The Business Analyst's Guide — covers discovery, dataset field design, knowledge document structure, and supplemental instructions from the BA perspective. This blog picks up where the BA handoff package ends and focuses on the IT Architect's implementation responsibilities.

If you have read Part 1 of this series, you know that a Business Analyst's job is to define what the OAC AI Agent needs — the questions it must answer, the fields it requires, the policies it must reference, and the vocabulary it must understand. A well-executed BA design produces a complete handoff package: field specifications, derived metric formulas, knowledge document drafts, vocabulary maps, and supplemental instructions ready to paste into OAC.

Download complete Guide from our linkedIn Page

The IT Architect's job is to make that design technically real — and to make it trustworthy at scale. Not just for the first agent, but for every agent the organisation will build after it. That requires a different mindset than building a dashboard or a report. It requires thinking about data lineage, pipeline governance, security boundaries, and the architectural foundation that determines whether AI answers can be trusted at all.

This blog covers the seven technical implementation decisions that separate a production-grade OAC AI Agent from a demo that works once and breaks in real life.

The core risk to understand upfront: An OAC AI Agent will give confident, fluent, well-formatted answers regardless of whether the underlying data is correct, governed, or complete. The agent has no way to tell the user "I am not sure about this number." It answers with the same confidence whether the data is perfect or wrong. The IT Architect's job is to ensure the data behind the agent is never the thing that fails.

Jun 12, 2026

What are the three essential components for a successful OAC AI agent?

A successful Oracle Analytics Cloud (OAC) AI Agent is built upon three essential components that function as the actual "product," while the agent itself is merely the container. These three components are:



Oracle OAC AI Agent : The Real Work Is Not Configuring the Oracle Analytics Cloud AI Agent

A Business Analyst's perspective on what actually makes an OAC AI Agent work — and what most implementations get wrong.

Oracle has made it genuinely easy to create an AI Agent in Oracle Analytics Cloud. Navigate to Create, select AI Agent, choose a dataset, paste some instructions, upload a document. You can have an agent running in under twenty minutes.

I know because I built one.

And here is what I learned quickly: the ease of setup is a trap.

The agent I built in twenty minutes could not answer half the questions I asked it in plain English. It answered the same question differently depending on how I phrased it. And when I rephrased those same questions using the exact field names from the dataset, it answered correctly every time.

The agent was not broken. The design was incomplete.

The three components that actually determine whether an OAC AI Agent works

An OAC AI Agent is built from three components — a governed Dataset, a Knowledge Document, and Supplemental Instructions. Oracle's configuration screen makes all three look equally simple to set up. They are not equally simple to design.

The Dataset is not just a table you point the agent at. It is a carefully designed flat view where every field is named in business language, every categorical value is meaningful without a lookup table, and every derived metric is pre-calculated using your organisation's specific business formula. A dataset designed for reporting will work for an AI Agent — but only if it was designed thoughtfully. Most datasets in production Oracle environments were not.


The Knowledge Document is not a policy PDF you upload. It is a retrieval index. The agent does not read it — it retrieves the most relevant chunks when a question touches on policy or business rules. A document written for human reading retrieves poorly. A document written for retrieval — short sections, specific rules, no cross-references, no legal language — retrieves accurately and produces answers that cite the right policy section every time.

The Supplemental Instructions are the bridge between how your business users speak and how your data is structured. Before writing a single instruction, the most valuable exercise a Business Analyst can do is build a vocabulary map — left column is what users say, right column is what the data contains. Every row in that map is a candidate instruction. The 6,000 character limit forces you to prioritise ruthlessly — which is exactly the right discipline.

Who should own this design work?

This is fundamentally a Business Analyst's responsibility — not an IT task. A BA who understands the business domain, can extract requirements from stakeholders, and can translate business language into data specifications is the right person to design all three components. IT implements the dataset in ADW and configures OAC. The BA defines what that implementation must deliver.

I have written a detailed guide covering the full design process — discovery questions, dataset field design principles, knowledge document structure, supplemental instruction frameworks, validation approach, and the IT handoff package a BA should produce.

If you are planning to build an OAC AI Agent — or if you have already built one and it is not performing as expected — the guide is worth reading before you touch the configuration screen again.

Read the full guide here: 

Shriram Gupta is an Oracle Solution Architect at BizInsight Consulting specialising in Oracle Analytics Cloud, Autonomous Data Warehouse, and Oracle E-Business Suite. Subscribe to this blog for practical Oracle implementation insights.

Tags: Oracle Analytics Cloud  |  OAC AI Agent  |  Business Intelligence  |  Oracle EBS  |  OCI GenAI  |  Business Analyst  |  Dataset Design  |  Knowledge Management  |  RAG  |  Supplemental Instructions

A Business Analyst's Guide to Designing OAC AI Agent components That Make It Work

A Business Analyst's Guide to Designing OAC AI Agent components That Make It Work

By Shriram Gupta  |  Oracle Solution Architect  |  BizInsight Consulting

Oracle has made it genuinely easy to create an AI Agent in Oracle Analytics Cloud. Navigate to Create, select AI Agent, choose a dataset, paste some instructions, upload a document. You can have an agent running in under twenty minutes. I know because I built one.

Download complete guide from our linkedin Page

But here is what I learned quickly: the ease of setup is a trap. The agent I built in twenty minutes could not answer half the questions I asked it in plain English. It answered the same question differently depending on how I phrased it. It gave me numbers I could not trust. And it had no idea what a late payment meant in the context of my organisation's AP policy — even though that definition was fundamental to everything the business needed.

The configuration of an OAC AI Agent is not the hard work. The design of the three components that feed it — the Dataset, the Knowledge Document, and the Supplemental Instructions — is where most implementations succeed or fail. And that design work is fundamentally a Business Analyst's responsibility, not an IT task.

Jun 10, 2026

When NOT to Use Oracle APEX in a Fusion Implementation — And What to Use Instead

Series: Oracle APEX in Fusion Implementations — Part 4 of 4 Published under: Oracle APEX | Oracle Fusion | OIC | VB Studio | Solution Architecture

The first three parts of this series made a clear case for Oracle APEX as a deliberate architectural layer in Oracle Fusion implementations. Custom transactional UIs, complex validation logic, integration monitoring dashboards — real use cases where APEX delivered something standard Fusion couldn't.

This post argues the other side.

Because the measure of good solution architecture isn't how often you apply your preferred tool. It's how clearly you know when not to. We've seen APEX misapplied on Fusion projects — used where Fusion Extensions would have been simpler, where OIC automation would have eliminated the need for a UI entirely, where Visual Builder Studio was the right fit and APEX added unnecessary complexity.

This post covers three scenarios where we'd steer you away from APEX, what we'd use instead, and the decision logic we apply at the start of every engagement.

Scenario 1: Small UI Adjustments to Existing Fusion Screens

The situation: A business user needs an additional field on the Purchase Order screen. Or the customer entry form needs a validation message phrased differently. Or a team wants to hide irrelevant fields on the supplier profile page to reduce confusion.

Jun 6, 2026

Building an OIC Integration Monitoring Dashboard in Oracle APEX — Without Touching the OIC Console

Series: Oracle APEX in Fusion Implementations — Part 3 of 4 Published under: Oracle APEX | Oracle Integration Cloud | Oracle Fusion | Solution Architecture

In Part 2 of this series, we walked through the architecture of a custom Sales Order UI in APEX — how we structured the three layers, where validation lived, and what the submission flow looked like end to end. That post was about improving what users put into Fusion.

This post is about what happens after. Specifically: how do you give a business operations team meaningful visibility into their integrations — without handing them access to a tool they were never meant to use?

Watch on YouTube" : https://youtu.be/5UlW6OJUuoE
The Problem: The OIC Console Is Not for Everyone

Jun 1, 2026

Building a Custom Sales Order UI in Oracle APEX for Oracle Fusion SaaS Order Management

This video post is a detail case study on improving the Oracle Fusion user experience by building a custom sales order interface using Oracle APEX. 

---

Read complete story at http://www.bizinsightconsultingblog.c...

---

The project addressed significant inefficiencies in the standard system, such as cluttered screens and high error rates, by implementing a streamlined three-layer architecture. This framework uses APEX for the front-end, Oracle Integration Cloud (OIC) for data transformation, and Fusion as the final system of record. Key technical enhancements include pre-submission validations for credit and inventory, along with an independent audit log for better troubleshooting. Ultimately, the new solution reduced order entry time by 60% and drastically cut down on the need for manual operational fixes. These materials highlight how targeted UI development can optimize complex enterprise workflows without altering the underlying data model.



Tags: Oracle APEX | Oracle Fusion Order Management | Oracle Integration Cloud | OIC | REST API | Solution Architecture | Low-Code | ERP | Digital Transformation

May 31, 2026

Building a Custom Sales Order UI in Oracle APEX for Oracle Fusion — Architecture, Decisions, and What We Learned

Series: Oracle APEX in Fusion Implementations — Part 2 of 4 Published under: Oracle APEX | Oracle Fusion | OIC | Solution Architecture

In Part 1 of this series, we laid out the case for Oracle APEX as a deliberate architectural layer in Oracle Fusion implementations — handling the user experience that standard Fusion UI can't deliver cleanly. In this post, we go deeper on one specific build: a custom Sales Order creation UI that we deployed for a distribution company running Oracle Fusion Order Management.

This post is about the decisions. Why we structured it the way we did, what we got right, and what we'd approach differently today.


Watch short video at our you tube channel : https://tinyurl.com/mr2ma8vn

The Starting Point: What Was Actually Broken