XSL-FO Designer for Apache FOP
Quick setup guideline for the FOP Service in Oracle APEX
For testing purposes you may use the URL

    http://eval.apex-reports.com//SaasFOP/ApexTrial

The setup is
  1.  make sure the Apex user has connect permissions for the external URL. For this, login to SQLPlus as SYS and run the PL/SQL script below.

    Note the APEX_050100 principal must be changed to match your Apex version.

    begin

        dbms_network_acl_admin.create_acl(
          acl =>         'print.xml',
          description => 'Apex report host list',
          principal =>   'APEX_050100',
          is_grant =>    true,
          privilege =>   'connect'
        );
        DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
          acl =>         'print.xml',
          principal =>   'APEX_050100',
          is_grant  =>   true,
          privilege =>   'resolve'
        );
        dbms_network_acl_admin.assign_acl(
          acl =>         'print.xml',
          host =>        'eval.apex-reports.com',
          lower_port =>  80,
          upper_port =>  443
        );
      commit;
    end;
    /
       
  2. In the Internal Workspace, instance settings -> report printing set the URL as below


Setting up the secure connection

If you want to use HTTPS (recommended for production environments) the print settings would be:


Note the production URL will be a different one as above

There is however one additional step to be performed. That is, you need add the certificates of the server to your Apex Wallet.

If you dot not have a wallet yet, you can use the file. The file contains the certificates of the eval.apex-report.com host. You must unzip the file and add the reference to the unzipped directory in Apex as below (the password of the wallet we provide is apex12345 )


If you already have an Apex Wallet you can download the 2 certificates from our server using any web browser. Connect to the host and click on the lock icon to view and download the certificates in Base64 format.



once you have the 2 files, add them to your existing wallet with the commands:

    orapki wallet add -wallet <your_wallet_directory>  -cert ApexReportsRoot.cer -trusted_cert -pwd <your_wallet_password>
    orapki wallet add -wallet <your_wallet_directory> -cert ApexReportsCA.cer -trusted_cert -pwd <your_wallet_password>

Use this command to display the content of your wallet:

    orapki wallet display -wallet <your_wallet_directory> 

Warning: If you use Oracle 11g r2 (11.2.0.2) or earlier, it will not work with the certificates, only version 11.2.0.3 and later support strong certificates based on SHA-2

How to connect to the FOP Service

Download here the process plugin and documentation: