A while ago, our friends at Pretius released a great application for the global APEX community called translate-apex.com. This application contains a collection of translations for Oracle Application Express. These translations are for the internal APEX Text Messages for system messages like 1 error has occurred.

During the same time, one of our developers, Aljaz Mali was working on an application which helps create and manage these Text Message translations. We're pleased to announce that this application is now live and open sourced!

Instead of documenting everything that the application can do, you can go try it out now: apex.oracle.com/pls/apex/f?p=88328 and using demo/demo123 as the login credentials.

If you want to help contribute to the project or download the application go to our Github project page. Please submit any of your feedback, issues, or enhancement requests on the issues page. If you create a translation in a language that isn't on translate-apex.com you're encouraged to upload it to their site and share with the rest of the community.

We’re pleased to announce yet another addition to OraOpenSource: APEX-SERT! APEX-SERT, formerly known as the commercial product eSERT, is an APEX application that is designed to identify and help remedy any security vulnerability in your APEX applications.

APEX-SERT installs one time into your instance of APEX and is instantly available to any user with APEX developer credentials. By default, users can evaluate only applications in their respective workspaces. However, APEX-SERT allows an administrator to allow users to evaluate across any workspace.

APEX-SERT can also be scheduled to evaluate a single application or even a group of applications at a specified interval. Results of each evaluation can be e-mailed upon completion - even to users who are not APEX developers.

APEX-SERT 4.2 - which is compatible with APEX 4.2 - is available today. APEX-SERT 5.0 - which will be compatible and updated for APEX 5.0 - should be available in the next month or so. You can download all releases and the source code from GitHub here: https://github.com/OraOpenSource/apex-sert

This year at Kscope 15 we announced several projects that we are working on. We're pleased to announce that one of these projects, APEX Diff, is finally ready (well at least an Alpha version)!

The goal of APEX Diff is simple: Create an export of an APEX application in a JSON format so that it can easily be compared/diffed with another version of the same appliation. By doing so it's a lot easier to see what has changed when comparing two applications rather than trying to read through the default .sql export file.

The following aninmation shows APEX Diff in action.

config.json file, with dev as the connection name.

Modify a region name in an APEX application (147)

Run APEX Diff, using Node.js

Compare old vs. new .json files to show the change and where it occured.

In most cases this would be done via a diff from versions checked into a version control system.

Special thanks to Kris Rice for adding the required features into SQLcl, which this project leverages.