Skip to Main Content

Wednesday, April 28, 2021

Setup the APEX Office Print (AOP) Server with the Oracle Cloud APEX Service

APEX Office Print (AOP)


This post is part of the series My spin on the new Oracle APEX Application Development Service.

To print and export data from the APEX Service in the Oracle Cloud, you can use APEX Office Print (AOP).

AOP allows you to generate documents based on templates created in Word, Excel, PowerPoint, HTML, and Text.
For example, people use AOP to create an invoice, send a packaging slip, export an Excel spreadsheet with multiple sheets, or have a monthly PowerPoint presentation with the latest sales numbers.

AOP the go-to print engine for Oracle APEX and the Oracle database and it offers both a cloud service and an on-premises solution. Having your APEX Service talk to the AOP Cloud is straightforward as there's really no installation to do. You can find more info about that in this blog post. But, what if you want your own dedicated AOP server for your APEX Service? Many people actually like to have their own instance so they can print as much as they want, have full control, and maximum speed - as it's closest to your database. In this post, I will show one way to set up your own APEX Office Print (AOP) Server which works with the Oracle APEX Application Development Service.

The special bit with the Oracle APEX Service is that it's a fully managed service, which means the database, ORDS, and APEX are pre-configured, auto-patched, auto-scalable, and optimized. I think it's awesome, but the downside is that you don't have direct access to the machine and the network. 

Tuesday, February 2, 2021

The Best Rich Text / HTML Editor for Oracle APEX

Plug-ins Pro

One of the first bigger public applications I built in Oracle APEX was the website and backend for a flight school (in 2006). It was a little Content Management System (CMS), so the secretary of the flight school could update the website and the trainers could create their online course material and exams straight from an administration page. I used a Rich Text (HTML) Editor, so they could make some text bold, include pictures, add some color and add tables to the text.

Continue Reading

Thursday, January 7, 2021

Getting started with APEX Office Print (AOP)

APEX Office Print (AOP)

 I just started working at United Codes and am new to APEX Office Print (AOP). Because we use AOP throughout many of our projects, getting to know its functionalities is important. Let’s start at the very beginning, with a step-by-step guide to get up-and-running with AOP and create your first report.

Continue Reading