For the last 16 years, with every big football tournament (World Cup and Euro Cup), we've launched an Oracle APEX app where you can predict the scores of the games. You can find this year's app at https://wc2022.unitedcodes.com Features Many people do a challenge with their friends or company, for fun, for money... Instead of using a custom-made Excel, use of email, or use of paper, you can use the World Cup 2022 Challenge site to track who's in the lead. You can enter the scores of every game and see how well your predictions compare to others (overall). You can create a group e.g. yo ..read more

Recently there was a question on Twitter about how to use the saved report name in an export of an Interactive Report in Oracle APEX.    First, if you never heard of APEX Office Print (AOP), or in short, AOP, it's the leading document generation software for Oracle APEX. AOP allows you to create PDF, Word, Excel, PowerPoint, Text, and HTML documents with data from your database and your Oracle APEX app. AOP is unique as it's tightly integrated with Oracle APEX. You create a template in Word, Excel, PowerPoint, Text, or HTML, and tags that are included in your template will ..read more

In almost every Oracle APEX application I create a Report with Form to edit the data. On this Form many people add a Print button to generate a document for this specific record. From time to time I get the question how to first save the record and next print or download the document. Here are the 5 steps to do this: 1. Duplicate the Save button and name the button Print. Or alternatively create the Print button from scratch and make sure to set the action to Submit, the Database Action to SQL UPDATE action, and make it conditional to only show when the PK is not null.  Thi ..read more

Sometimes you expect to see some data in your Oracle APEX application and it's not there... in this post I will describe one use case I see more often and how to solve it. We have a report which shows all the employees (coming from the EMP table): Clicking the pencil icon opens up the form of that employee: We added two extra buttons:  a print icon which creates a document for the employee a bug icon which adds 10% of the salary in the commission field Let's first start to see what is behind our Print button. We use the APEX Office Print (AOP) Dynamic Action to generate a ..read more

Today there was a question on how to export data from the Oracle Database and Oracle APEX into one Excel file with multiple sheets. Each sheet contains data from a different table. With APEX Office Print it's a matter of a few minutes to fulfill this request ? If you have never heard of APEX Office Print (AOP), here's one paragraph on it.  AOP is the easiest to use product/plug-in that fully integrates with Oracle APEX to give you all the reporting and export functionality you've dreamed of. You create templates in Word, Excel, PowerPoint, HTML, or Text and AOP will merge it with the ..read more

A few days ago Oracle Application Express (APEX) 21.2 was released. You can now upgrade your own environment with this new release.  With every new release, it's important to look at the Release Notes. One section I'm particularly interested in is the Deprecated Features. Features listed in this section will still work, but sometimes in the future it might not, so it's a good time to start unlearning to use those features. Typically these features are not really necessary anymore or got replaced by something else, but it also occurs that some things get changed over time to make things mo ..read more

If you are still running Oracle APEX 5.1, it might be time to schedule an upgrade. Support is running out at the end of the year.  Does it mean you can't use Oracle APEX 5.1 after December 2011? No, not at all, if you have no need to upgrade, and all is running smoothly, it's fine... you just can't request a patch anymore. Till the 20.2 release you could stay on an APEX release for 5 years, but that has changed since the 21.1 release. Oracle announced it will reduce the support for an APEX version from 5 years to 3 years.   As Oracle APEX is a web development tool and things change ..read more

An AOP customer wrote us that when opening a PDF in a Modal Dialog the spinning icon didn't disappear automatically anymore in Oracle APEX 21.1, whereas it did before.   I created a use case but saw it not only affects the AOP process but any file you want to open in the Modal Dialog. With previous versions of APEX, this didn't happen, but with APEX 21.1 the Modal Dialog keeps showing the spinning icon. Here's an animated gif that shows the use case: I created two use cases; both buttons redirect to a modal page in the app. On the modal page behind the "View File" but ..read more

For the last 15 years, with every big football tournament (World Cup and Euro Cup), we've launched an Oracle APEX app where you can predict the scores of the games. You can find this year's app at https://euro2020.unitedcodes.com Features Many people do a challenge with their friends or company, for fun, for money... Instead of using a custom-made Excel, use of email, or use of paper, you can use the Euro 2020 Challenge site to track who's in the lead. You can enter the scores of every game and see how well your predictions compare to others (overall). You can create a group e.g. your compan ..read more

On May 12th Oracle APEX 21.1 was released.  This post is not about why Oracle APEX 21.1 is worth an upgrade. You can see for yourself if you like the improvements in the Release Notes. Some companies upgrade once a year, some wait for the patch set bundle, and some upgrade very fast. We upgraded our production instance this weekend. I blogged about how we do the upgrades and try to minimize downtime in the past. But upgrades have become even easier! While the Oracle APEX kept running; 15 minutes install which of 5 minutes downtime, and we were done! Note: it's always good to read the  ..read more