Application Support with APEX Applications: Looking After the Users when Development has Finished

Although at Explorer we spend most of our time creating brand-new bespoke APEX applications or completing Forms to APEX projects; sometimes we are asked to work on and/or support an existing APEX application, both for external clients and for our own internal systems. Having come from a more support orientated background where I have spent […]

APEX, How to, Support APEX, In House, Support, Team Development / April 18, 2018

Read More

APEX Developer Mode

When I used to work with Oracle Forms, the company I worked for used to grant users on the development environment with a special role which provided enhanced access to many areas of the system. The name of this role was called… GOD MODE. This was only ever applied to the development system and it […]

APEX Development / March 8, 2018

Read More

Interactive Grid Column Read Only Control

I thought it would be interesting to share my findings on the Read Only setting for Interactive Grid (IG) Columns. The Read Only attribute has been around for many years – so why write a blog about it in 2018? Well, something has changed with the Read Only attribute for Interactive Grid columns – here […]

APEX, Blog Interactive Grid / February 16, 2018

Read More

APEX Interactive Grid: Preventing Lost Updates & Record Locking

I was recently asked about the Interactive Grid (IG) configuration settings that are associated with Locking and Preventing Lost updates. “Aren’t they the same thing?” I was asked… Actually, no; they are not the same thing. However, they are both there to protect your data and therefore it is worth spending a little time to explore […]

APEX, Blog, How to / February 12, 2018

Read More

Introducing APEX TabLock

A little side project of mine is developing new features for a chrome extension which provides extra functionality for the APEX developer. The chrome extension is called TabLock and the name derived from its original purpose, which is to help prevent accidental movement of APEX page designer tabs. However, I am aware that this extension […]

APEX, Blog APEX, APEX 5.0, APEX 5.1, Chrome / January 17, 2018

Read More

Options For Loading Excel Data Into APEX Applications

Excel is still widely used across many organisations as a standard reporting tool, often being used as a substitute for small databases. As a consequence, it has become necessary to load Excel data into APEX applications. At the UK OUG TECH17 Conference, I introduced a number of options available to help import Excel data into APEX […]

APEX, Blog, TECH17, Why use APEX APEX, Excel / December 21, 2017

Read More

APEX & Search

This year, we have been looking into the best way to deliver search capabilities in an APEX application. Customers are used to searching in Google and often want the same functionality in their business application.  While we don’t have the resources and years of research that Google have, we can take some ideas from them […]

APEX, Blog APEX, Search / November 30, 2017

Read More

Validations and Duplicate Page Submissions in APEX 5.1

I had a problem with a modal dialog page in APEX 5.1, which created new rows in a table on the database whenever the Create button was pressed. The problem was that if the user was very quick i.e. double/triple clicking on the Create button, then it was possible to create duplicate rows on the […]

APEX, APEX 5.1, Blog Validation / October 9, 2017

Read More

Generating PDF and Word Documents from an APEX application

Generating PDF and Word documents from an APEX application is a request that we get all the time. There are many great third party tools to help you do this but in this blog post I’m going to focus on PL/PDF, which is the tool that I used most recently for customer work. PL/PDF is […]

APEX, Blog, Reporting APEX, reporting / September 26, 2017

Read More

The start of the end for Apex 4.2

In October 2017 (just 3 months’ time), Premier Support for Oracle Application Express 4.2 will end. This ultimately marks the end of the APEX 4 era and coincides with the fifth anniversary of the 4.2 launch. A lot has changed in those 5 years: we have had two more major versions of APEX – with […]

APEX, Blog, Cloud, Oracle Forms upgrade / August 14, 2017

Read More

Next Page »

Featured Posts