After a long and thorough set of mandatory legal processes, I’m happy to announce that starting today, APEX-SERT is back and available for the community to download and use! It’s still open source, and can be used as much and as often as you like for free via the Universal Permissive License (UPL) 1.0.

The feature set has not changed much since my last post about it, so if you need a refresher, have a look here: https://spendolini.blog/apex-sert-the-sql

I can’t thank Michael Potter and his team in Australia enough for their help in getting this project released. He specifically helped navigate the several processes & procedures required by our employer, as well as helped to tune and squash some bugs.

SQLcl & Liquibase

One difference that you may notice is that we used SQLcl & Liquibase to build the installer. This gives us a lot more flexibility when releasing updates, as the installer will always know where to start, regardless of the version. There’s nothing different about the installation process - just run install.sql as SYSTEM or ADMIN and you’ll be up and running in no time at all!

Printing

APEX-SERT allows for either AOP or OCI DocGen to be integrated for printing of reports. In either case, you must procure your own instance & license and configure APEX-SERT accordingly.

Builder Extension

APEX-SERT makes use of one of the newer features of APEX: Builder Extensions. As a Builder Extension, you can run APEX-SERT as the same user you develop APEX applications with. This enhances the security posture of APEX-SERT itself, as previous releases needed to make a small adjustment to the APEX core schema - something that is no longer possible on ADB.

Feedback

Find a bug? Have an idea you’d like to see added? Please use GitHub issues, which can be found here: https://github.com/oracle-samples/apex-sert/issues

Download

Ready to get started? You can download it here: https://github.com/oracle-samples/apex-sert

Title photo by Tasha Kostyuk on Unsplash.

APEX-SERT: Now Available