Oracle REST Data Services (ORDS) / Apex Listener 2.0 FOP Gives 404 Error When Called from APEX_UTIL.GET_PRINT_DOCUMENT (Doc ID 1554090.1)

Last updated on MAY 24, 2016

Applies to:

Oracle REST Data Services - Version 2.0.2 and later
Oracle Application Express (formerly HTML DB) - Version 4.2.2 and later
Oracle Database Cloud Service - S5 - Version N/A and later
Oracle Database Cloud Service – S20 - Version N/A and later
Oracle Database Cloud Service – S50 - Version N/A and later
Information in this document applies to any platform.

Symptoms

Calling the Oracle REST Data Services (ORDS) / APEX Listener FOP from the Apex Print API Generates a 404 error and corrupt PDF.

The APEX code would be similar to the following:

1) Created a PL/SQL process on an application page run on submit.
2) This PL/SQL process refers to a 'Report Query' in the shared components section of the application.
3) The PDF document created as a result of this process contains a report ran in the called 'Report Query'

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms