Categories
AI APEX

APEX 26.1 App Enhancements With APEXlang

In this article we will generate a APEX 26.1 app using an AI and then direct an AI to edit that application in VS Code and push it back to the app builder to run it. This is made possible by the new feature of APEX 26.1 APEXlang, which is described by Oracle as “…an […]

Categories
APEX

Oracle APEX 26.1 IR Row Selector

It looks like it’s a small tweak, but it’s a highly significant enhancement that APEX 26.1 adds a native row selection for Interactive Reports. Previously this could be done in multiple ways, but it it really makes development a lot easier having this capability as a native component. In this article we are going to […]

Categories
AI APEX GenAI

Oracle APEX 26.1 AI Agents

AI Agents are proliferating across many tools and now Oracle APEX 26.1 introduces built in both AI Agents and AI Tools. To demonstrate this facility, I will use the EMP and DEPT tables from my Oracle 26ai database and build a small People Cost Review page within an application which invokes an AI agent supported […]

Categories
APEX GenAI

Oracle APEX 26.1 AI Interactive Reports

One of the “marquee” features of the new Oracle APEX 26.1 release is the ability to add natural language queries to Interactive Reports (IR). So, as well as having full IR ability, the user can ask a question like “show me all employees in Sales earning more than 1500” as an alternative to manually setting […]

Categories
APEX GenAI

First Look at APEX 24.1 AI 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 […]

Categories
APEX

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
APEX

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 […]

Categories
APEX ORACLE CLOUD ERP Oracle Fusion Applications

Oracle APEX and Oracle Cloud SaaS REST APIs

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 […]

Categories
APEX Oracle Analytics Oracle Spatial

Oracle APEX and Analytics with Oracle Database Geocoded Data

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 […]

Categories
APEX Oracle Spatial

APEX 21.1 Maps – Nearest Neighbours (with Spatial Studio)

The new sample map application that has been provided for Oracle APEX 21.1 is full of great ideas. After reviewing the application, one example I was keen to try for myself was the ‘Nearest Neighbour’ capability. I had an existing map demo (see previous articles on this site) showing customers in proximity to a restaurant, […]