Blog Archive

  • Edit Collection with Interactive Grid

    An Oracle colleague asked how to create an editable Interactive Grid against an APEX collection. I share the solution here along with a few observations I learned while creating it. Client Side Grid Model An interactive grid manages an in-memory record set in the browser. This is called the model. An editable grid’s model also tracks rows the end user has added, modified, and deleted. When the user submits the page or clicks the grid toolbar’s (Save) button, the changes in the model are sent to the server for processing by the Interactive Grid – Automatic DML page process. The…

  • Collecting Data in Human Tasks Orchestrated by a Workflow

    When an APEX workflow assigns a human task to one or more potential owners, it shows up in their “Universal Task List” page of “todo” items. Sometimes an action task or an approval task requires the task owner to input additional data to inform the business process the workflow is orchestrating. The task detail page that you generate from the task definition edit page is the page end-users will navigate to when they act on a task in their “inbox”. This page is your starting point for exposing as much or as little of the built-in APEX human task functionality…

  • New JSON, Workflow, and Fusion Apps Features in APEX 24.2

    Thanks to everyone who came out to see my talk at APEX Alpe Adria in Zagreb. Here are the slides I presented. Hope to see you next year! All of the sample apps I showed during the talk require an Oracle 23ai database, although the Books Against JSON Collection can work fine against a table containing a JSON CLOB/BLOB column in 19c. The two Books-related sample apps require a couple of APEX fixes that are in the APEX 24.2.5 patch set. You can download the three sample apps from here:

  • Dynamic Behavior Buffet #JoelKallmanDay

    To commemorate Joel Kallman Day, I dive into four interesting APEX ideas related to dynamic behavior that my dev team colleagues John Snyders and Stefan Dobre taught me recently. We’ll explore how to: Download the sample to follow along in APEX 24.1, or read first and download later. Let’s get started. Note: To see any figure in its original size, right-click on it and open it in a new browser tab. Configuring Cascading Lists Cascading lists are a pair of LOV-driven page items where the value of a “parent” list influences the choices available in a “child” list. For example,…

  • Oracle APEX 24.1 Product Tour

    Watch this webinar to see the broad set of Oracle APEX features you can use to quickly deliver and maintain beautiful, functional solutions that add immediate business value. Enjoy end-to-end or expand the YouTube description for a detailed topic timeline to view just a segment. See below for a list of what you’ll learn… Studying an app for a fictional medical clinic, you’ll see & learn about: Productive Development Easy User Interfaces and Reporting Simple Business Processes, App Logic, and Integration Hassle-free Dev Ops and Application Lifecycle