It’s been a while since APEX World and I promised to publish a blog about my presentation. My last blog (Oracle APEX – Shortcuts) was also a small part of my presentation, but there is so much to be said about how to work in your Oracle APEX environment.

If we take a look at all the different kind of tools, files, workspaces, databases, schema’s, packages / code, and lots more, that we got and we need.. There’s only 1 conclusion; we got a lot going on.. In this blog I will try to give you some pointers how to Tidy up your environment.

Let’s start with 2 simple pointers for your workspace.


A very simple and effective trick in your workspace is to create a personal report in your application designer. Especially when you have a workspace with multiple applications, which might not be completely linked to eachother. I created application groups for this, assigned these to all the applications, and created a Control Break on these applications. Now all my applications are grouped together and I can find them more easily.

Next to that, for the larger applications I created saved reports, so I can find them easily without searching.

Master Application

The most important part of my APEX workspaces is my Master Application. Like the name suggests, this application has got everything I re-use.. The (universal) theme, my custom templates, plugins, …

Second, this is the basic application I can show to every user to show templates we use in other applications, authentications we have and how they work, plugins we use or created, and the Universal Theme. With this application I can easily show everyone what we already have without showing data from other applications they don’t have access to. This way, when the client wants something we already got, we show them, and we can easily subscribe to the component and use it in their application.

Also, because we subscribe everything to our master application, if we do find a bug or need to update something, we can show this in the master application. Once approved, we publish it so every application that uses it is updated with just one click.


Next blog I will get into what you can do with your master application more detailled, like create custom templates and/or plugins and where to put your CSS/JS files.

If you have any tips, questions or reservations please let me know! All are welcome!! What works for me, might be different for you!