Blog Archive

  • 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

  • Intersection Rows as Multivalue Item

    End-users find multivalue page items intuitive for quick data entry, and APEX devs have many kinds to choose from. However, using multivalue items in the simplest way means storing data in a single column as a delimited string. While easy to do, this could complicate other aspects of your app processing. For a row in a book table, for example, often the multiple tags applied to the book are stored in an intersection table. Imagine a book_tag_xref table with foreign key values recording which tag ids are paired with which book ids. In this article, you’ll learn how to manage…