Home Page The Saas FOP service
Home
              The Saas FOP service
            • Introduction
            • Features
            • Setup in Apex
            • FAQ
            • Online FOP test
            • Setup in Apex
              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