DataVizMark
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 […]
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 […]
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 […]
Spatial analytics is a powerful tool that provides insights into geographical aspects of data. This technology can be employed to optimize delivery routes, visualize and interact with the geographical distribution of customers, or even plan sales campaigns based on locality. By applying spatial analytics, businesses can go beyond traditional analytics of knowing who their suppliers […]
Oracle Fusion Analytics Warehouse (FAW) extracts data from Oracle Cloud Applications via integration pipelines and surfaces that data in an Autonomous Data Warehouse. The data is structured into facts and dimensions which are modelled into structures called subject areas which are easy to visualise and explore using Oracle Analytics Cloud (OAC). A lot of pre-built […]
There is a new REST API connection available with the September 2022 release of Oracle Analytics. This is currently in preview so does need to be enabled in system settings. Once we’ve enabled this preview feature, the REST API connector is then made available in the list of connections. Selecting it brings up the following […]