22 November 2015

APEX 5.1: features shown at DOAG

On the last day of the DOAG conference, in the last time slot Patrick Wolf from the APEX development team did a session on the next release of APEX.
For the developer the most significant change in the Page Designer is the component view. This will be a tab in the center pane instead of a completely separate page.

Most time was spent showing the new Interactive Grid. The Interactive Grid will be a, loosley speaking, combination of an Interactive Report and a Tabular form. The menu from the Interactive Report also gets a make over. The functionality to format the result set (like pivot, group by) will be taken out of the action-menu and will get its own button next to the search bar.

Initially the Interactive Grid will be read only (like the Interactive Report) and can be set to allow data changes. As a developer you can specify which operations are allowed and add authorization to each of the DML. What is really neat is that you can also specify which column can be edited.
From a right click menu in the Interactive Grid several actions can be performed like adding or removing a row.

It is also possible to specify what item type will need to be used when you edit the field.

After this demo, Patrick showed the master-detail functionality, which also allows editing in the master and the detail. He described that only the changes are sent to the database when the save button is pressed.

Of course the new charting engine was also shown and emphasized that not all chart-types available in Oracle JET will be created in APEX through a declaritive wizard.
In case you hadn't heard: the new charting engine for APEX will be using Oracle JET.
What surprised me was that Patrick mentioned that some charts in the JET toolkit don't offer the functionality which is currently provided in AnyChart (the current charting engine) and that in some cases they will continue to use AnyChart for those components. If I remember correctly this was the case for the maps. The European maps aren't as detailed as the APEX team would like them to be, but who knows by the time that APEX 5.1 is ready for release the JET charts might be up to par.

Declarative column group headers, the ability to move columns and creating an overflow report (just like the ones that you know from Oracle Forms) were also briefly demonstrated by Patrick.
All in all, a great last session showing a glimpse into the future of Oracle APEX.
Of course all of what is shown might not be in APEX 5.1, the first slide (after the title slide) was Oracle's safe harbor statement.


  1. when productive version 5.1 is expected?

    1. If I recall correctly, Patrick mentioned calendaryear 2016 and that there will be EA releases prior to the actual release.

  2. Thanks for posting your observations, Alex. I appreciate them from over here đŸ˜€

  3. Very nice website and articles. I will be realy very pleased to visit your website. Now I am found that we actually want. I check your website everyday and attempt to learn something from a blog. Thank you and looking forward to your new submit.

    Zayn - Pillowtalk Nightcore
    Flo Rida - My House Nightcore
    Adele - Hello Nightcore
    Justin Bieber - Love Yourself Nightcore

  4. We are eagerly waiting for ORACLE JET into APEX and also its better if can have Altra UI components too.

  5. Editable Interactive Grid replaces Tabular form. Now facing difficulties writing PL/SQL or AJAX/JavaScript code on the Grid. As in Tabular form the item id was like f1_0001, now nothing is there like that. How to catch the ID to make general programming procedure.

    1. With the editable grid, you can still use PL/SQL. Use APEX$ROW_STATUS to detect which rows were added, removed or changed