My Oracle Support Banner

PDF Output From IRs Do Not Format Correctly After APEX Upgrade (Doc ID 2583699.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle Application Express (APEX) - Version 18.2 to 19.1
Information in this document applies to any platform.


APEX has been upgraded from APEX 5.1.4 to APEX 19.1.

After the upgrade, PDF output from all interactive reports truncate columns. The columns are all formatted at the same width despite column size, so all columns do not display.
The problem can also be duplicated by creating a new IR, then changing alignment on some columns.

It has to do with format masks on columns. After adding format masks the APEX PDF generator doesn't format correctly.
- On the test page a new IR as a duplicate of the existing IR query.
- The report column order and column headings, and column alignments were changed. 
   -- PDF output was correct.
- Added format masks to the date and amount columns.
  -- Adding one at a time, each one would shift the PDF output.
  -- After 2 or 3 format masks, the columns would start to be truncated.

This problem has been duplicated with the ORDS print server as well as the external Apache FOP.
Have duplicated with ORDS listeners 18.1, 18.4, and 19.2


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.