Blog Archive

  • Enabling Debug on APEX Builder

    When reporting a problem in the forums or in an Oracle Support ticket, if that problem occurs in the APEX Builder itself, the first instinct is to report the error message received. For example, “I’m getting ORA-01722: Invalid Number.” Providing additional context about where that error occurs can greatly help members of the APEX community … Continue reading “Enabling Debug on APEX Builder”

  • Flexing Fusion Apps Filters

    I enjoyed returning to the APEX Alpe Adria conference to chat with and learn from members of the APEX community. If you joined me in Maribor, thanks for your interest in extending Fusion Applications with Oracle APEX. You can download the slides from my session here. In a nutshell, using Fusion Apps business objects in … Continue reading “Flexing Fusion Apps Filters”

  • APEX Dev Lifecycle Webinar

    My webinar on Understanding the Oracle APEX Application Development Lifecycle for the Oracle APEX JAPAC Office Hours series is now available to watch on demand. It closely follows the technical paper of the same name and can be considered a companion resource. The sample scripts explained in the webinar and technical paper are available to … Continue reading “APEX Dev Lifecycle Webinar”

  • Simplify APEX App REST APIs with JSON Duality Views

    When writing your APEX apps, it’s best to put business logic in packages. This practice eases maintenance, improves performance, and favors reuse. I set out to combine an Oracle 23c JSON Relational Duality View with my business logic package to simplify building REST APIs for my APEX apps. Read on to learn what I discovered. … Continue reading “Simplify APEX App REST APIs with JSON Duality Views”

  • Dipping My Toe into Workflow

    APEX workflow is a new feature I was keen to experiment with. In a familiar visual designer, you automate a business process with a flow diagram. Its sequence of activities can include business logic, conditional branching, local or remote API calls, time delays, email, and push notifications. It’s also easy to wait for approvals or … Continue reading “Dipping My Toe into Workflow”