SQL & PL/SQL

Hi Muazzam,

Muazzam wrote:

I have followed instructions to enable print services in admin instance settings under Oracle apex 4.2.4/5 but getting error "Failed to load PDF Document" after opening generated PDF file.
I could't get enough solution here: Oracle Apex 4.2.4 cannot create PDF
Kindly provide me detailed instructions to enable print services using APEX Listener in 4.2.4 and REST services for v5.

     You have to configure ORDS as "Print Server" in Oracle APEX Instance Settings:

     Refer : https://docs.oracle.com/cd/E59726_01/doc.50/e39151/adm_wrkspc002.htm#BABIECEE

     Also, if you are using Oracle Database 11g or later, you have to configure appropriate ACL in order to connect to the "Print Server" configured.

     Refer : https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29160

     For using ORDS as "Print Server", you have to install ORDS and configure it as Web Server with Oracle APEX. Also to use ORDS as "Print Server", you have to deploy it to Supported Java EE Application Servers.

     Refer :

• PDF Printing
• Re: saving output in pdf
• Re: How to configure in apex using other XSL-FO Processing Engine instead of Bi publisher

     For configuring Oracle REST Data Services (ORDS) as Print Server also refer the following :

• Marc Sewtz: PDF Printing with Oracle Application Express 4.2.2
• http://www.oracle.com/technetwork/developer-tools/apex/learnmore/custom-pdf-reports-1953918.pdf

Regards,

Kiran

failing all that, also try use report with only a few columns, not many.

I have run this procedure but still have same issue of "Failed to Load PDF Document"

http://docs.oracle.com/cd/E37097_01/install.42/e35123/otn_install.htm#BABJFCGF

Hi,

Try the below mentioned solution for this issue, it may helpful to you.

Solution:

We have added the below entry in default.xml file which is located in "/u01/test/test-conf/test"

<entry key="misc.enableOldFOP">true</entry>

Restart the tomcat services and retest the issue.

Regards

Kumar Vellaisamy

Should the ORDS as "Print Server" in Oracle APEX Instance Settings?

what version of ORDS are you using?

MK

Hi Muazzam,

Yes, Print server should be as ORDS in APEX settings.

And we have Installed the APEX 5.2 version with ORDS 3.0.3 but we faced same issue so we went with the ORDS 3.0.2 version then it worked fine.

Regards

Kumar Vellaisamy

What settings when ORACLE APEX LISTNER with APEX v.4.2?