ApEx 3.1 New Feature Causes Mind to Boggle

The specific cause of the bogglation is the “Interactive Reporting” feature, which you can take for a test drive here. Click on the “Interactive Reports” tab and then poke the “View Customized Interactive Reports” button.  Integrating Flashback Query (click on the little cog wheel) is a little stroke of genius, and a testament to the integration of ApEx with Oracle’s core features, and I think the ApEx developers must be having far too much fun with this project.

We’re standing up ApEx v3 here for managing reference data as soon as we can get the development environment available (shouldn’t be many more months now!) and the new features of 3.1 seem pretty compelling. Interactive Reporting, PDF’s and Emailing Attachments are a powerful combination.

I am also amused that Oracle not only has added another reporting tool to its stable, but that it shares a common name with Oracle’s Hyperion Interactive Reporting — is anyone Googling these names before they assign them?


8 thoughts on “ApEx 3.1 New Feature Causes Mind to Boggle

  1. Ah. The wonders of RSS. You go offline for a while (well 6 months) and Google Reader politely tells me you have surfaced again. Welcome back.

  2. Neat feature! I guess there are a bunch of people using simple implementations of Business Objects and Discoverer who could easily use this instead.



    PS. 2 posts in 2 days. Welcome back to the unreal world… :)

  3. Crystal Reports is the ultimate in empire building. Write one report in it and you have a job for life because nobody will want to touch it. :)

    I’m sure it’s improved since I last used it… Probably… :)



  4. I have a little beef with Apex, formerly HTML DB I believe.

    Some years back – Oracle had a tool that you could use with the database for building web apps. I can’t remember the name to be honest… Anyways, it was promoted just like HTML DB and Apex. Next release though it became Oracle Portal and required a middleware license (along with pretty much anything else at the time… they must have been really struggling to sell those).

    So would I use Apex? Well I haven’t done it yet.

  5. A postscript to this story — we did indeed get a small Oracle 11g instance stood up for Apex, but it took eight months to do from initial submission of request to being able to log in. That blew out the timeline for development, and even then the system was only usable when accessed through a terminal server. From all desktops (the developers’ included) the delay on the web interface was around 60 seconds from click to refresh.

    Two months later the analysis of the cause of the problem hadn’t even started so we abandoned our hopes of ever getting it done.

    My thoughts then, as now, were unprintable.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s