In 2022 I wrote about adding expand and collapse controls to Interactive Report control breaks with a Dynamic Action and a small amount of JavaScript. Interactive Grid already had similar functionality, while Interactive Report did not, so the solution simply added a button to each control break header and toggled the rows belonging to that group. A few years later I revisited the code with Oracle APEX 26.1 and decided that, rather than publishing another updated JavaScript snippet, it made more sense to turn the idea into a reusable Dynamic Action plug-in.

Continue Reading

When building drill down interfaces in Oracle APEX, non-chained modal drawers are one way to display hierarchical data. However, requiring users to manually close each drawer one by one to return to a previous step can lead to unnecessary clicks. Here is one approach to using custom URL actions and breadcrumbs to close multiple non-chained drawer pages at once.

Continue Reading

If you spend any time developing with Oracle APEX, you likely already have a preferred way to run a local environment. The Oracle community has produced several excellent local setups (e.g., Docker/Podman-based options) over the years, and we are fortunate to have Oracle Container Registry making this very easy.

Continue Reading

By integrating Oracle Cloud Identity Domain into your APEX environment, you create a robust authentication mechanism that not only streamlines user management but also enhances security. This seamless integration allows organizations to leverage advanced identity management features, enabling secure single sign-on (SSO) capabilities while simplifying user experience. In this blog post, we will explore the steps to authenticate your Oracle APEX development and administration services with Oracle Cloud Identity Domain.

Continue Reading

Here is how you can easily set report refresh interval just using dynamic action without writing any line of JavaScript.

Continue Reading