Many organizations desire to have as real-time as possible analytic systems that give them the capability to analyse their data sourced from various core business systems, at quite a granular level with all the built in governance and security to keep that data secure. I am being asked with increasing frequency about how users can […]
In the previous article we looked at MCP with Oracle SQLcl and analysed data from an Oracle 26ai autonomous database. Now in the Oracle Analytics Cloud November 2025 update, an MCP server is also available, and we will look at this in action. Mike Durran and Ravi Bhuma wrote a great article on setting up […]
In this article I am going to use an Oracle 26ai database, an MCP server, an agent and a LLM to ask a bunch of questions of my data and even create a chart in python – all without me having to write any code. This is not a fully detailed process for installation as […]
Oracle Fusion Data Intelligence (FDI) allows us to enhance the out of the box offering by bringing in additional data from the source Fusion Cloud Applications system. From the available data stores, called PVOs, we can select additional columns and create an augmentated dataset which can be used in extraction pipelines. With this technique, additional […]
The September 2024 release of OAC introduced the new AI Assistant. The on-line help gives a great introduction to the process of the rollout of the AI Assistant and also some caveats, most importantly “Always verify the results and consult your primary data sources before making critical decisions based on results generated by the Assistant.” […]
Oracle APEX 24.1 introduced the ability to use an AI Assistant. This can help with tasks from generating applications to providing an AI “Digital Assistant” for user interaction. In this article I show how to set up the AI Assistant and a couple of examples of it in use. Note that I chose to use […]
GenAI is clearly a hugely transformative technology. In this example I show how I used a GenAI model (in this case OpenAI) to process questions from the user of the OAC workbook and return both numeric and text responses which can then be visualised. There is a really useful guide here which explains the steps […]
Categories
Oracle APEX Background Process Chains
I was architecting an APEX extension for an Oracle EBS customer where there was a need to call some standard APIs. These took a little while to run, and as the customer was using an APEX version prior to 23.1 we decided to submit these processes as concurrent programs. They could therefore execute asynchronously and […]
Categories
Oracle APEX 23.2 New Image Upload Facility
Added : February 5th 2024 On a recent customer project I was able to use Oracle APEX 23.2.2 which has a significant number of new capabilities. One facility was the new Image Upload, which provides a wide range of options to allow users to easily take/select images and crop, format and upload and then tag […]
Oracle APEX is a low-code development tool which is marvellous for developing responsive cloud applications. Oracle Cloud SaaS Applications (aka Fusion Applications) are a comprehensive suite of SaaS applications which are used by many leading organisations to manage their HCM, Finance, Procurement, etc functions. With the release of Oracle APEX 23.2 we now have the […]