Enable report printing by configuring printing settings at the instance level, application level, and page and region level.

When using the Oracle Document Generator Pre-built Function, your APEX instance must run off a database with DBMS_CLOUD installed. Prior to configuring report printing, you must create the DBMS_CLOUD credential in the database, and configure Document Generator as a Remote Print Server through the OCI Pre-built Function Page.

Configure the print server type for an instance by editing the Print Server Type attribute on the Instance Settings page.

To configure the printing of reports in a full development environment:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Instance Settings, click Instance Settings.
4. Click Report Printing.
5. For Printer Server, select an option:
   • None (Native) - Select this option if you do not use an external print server. This option enables you to use the basic printing functionality, which includes CSV, HTML, PDF, and XLSX.
   • Oracle Document Generator Pre-built Function - Select this option if you are using Oracle Document Generator Pre-built Function. This option enables you to take report query results and convert them from JSON to PDF/Microsoft Office format using Oracle Document Generator Pre-built Function. Select this option to upload your own Microsoft Office templates for printing reports within APEX.
   • Oracle BI Publisher - This option requires a valid license for Oracle BI Publisher (also known as Oracle XML Publisher). This option enables you to take report query results and convert them from XML to RTF format using Oracle BI Publisher. Select this option to upload your own customized RTF or XSL-FO templates for printing reports within APEX.
   • APEX Office Print - Select this option if you are using APEX Office Print. This option enables you to take report query results and convert them from JSON to PDF/MS Office formats using APEX Office Print. Select this option to upload your own MS Office templates for printing reports within APEX.
   • External (Apache FOP) - Select this option if you are using Apache FOP on an external J2EE server. This option enables you to use the basic printing functionality, which includes creating report queries and printing report regions using the default templates provided in APEX and using your own customized XSL-FO templates.
   What appears next depends upon the selected Print Server.
6. For Oracle Document Generator Pre-built Function, specify the following:
   1. Cloud Credential - Specifies the cloud credential to use for Oracle Object Storage bucket management and use of the Oracle Document Generator Pre-built function.
      Note: The Cloud credential can be created using the APEX_INSTANCE_ADMIN.CREATE_CLOUD_CREDENTIAL API.
   2. Object Storage Namespace - Specifies the top-level container for all buckets and objects. At account creation time, each Oracle Cloud Infrastructure (OCI) tenant is assigned one unique system-generated and immutable Object Storage namespace name. This information can be found in the OCI console.
   3. Object Storage Bucket Compartment OCID - Specifies the Oracle Cloud Identifier (OCID) of the compartment where the Oracle Document Generator Pre-built function is located.
   4. Object Storage Bucket Endpoint - Specifies the base URL endpoint for the Oracle Object Storage bucket.
   5. Function OCID - Specifies the Oracle Cloud Identity (OCID) of the Oracle Document Generator Pre-built function. This can be found in the Oracle Cloud Infrastructure (OCI) console.
   6. Function Endpoint - Specifies the base URL endpoint of the Oracle Document Generator Pre-built function. This can be found in the Oracle Cloud Infrastructure (OCI) console.
7. For Oracle BI Publisher or External (Apache FOP), specify the following:
   1. Protocol - Select whether the print server uses HTTP or HTTPS protocol.
   2. Host Address - Specify the host address of the print server converting engine. By default, this is set to localhost.
   3. Port - Specify the host address of the print server converting engine. The default setting is 8888.
   4. Script - Defines the script that is the print server engine. The default setting is:

      /xmlpserver/convert
      

   5. Print Timeout - Enter the number of seconds. Defines the transfer timeout for communicating with the print server in seconds.
8. For APEX Office Print, specify the following:
   1. Protocol - Select whether the print server uses HTTP or HTTPS protocol.
   2. Host Address - Specify the host address of the print server converting engine. By default, this is set to localhost.
   3. Port - Specify the host address of the print server converting engine. The default setting is 8888.
   4. Script - Defines the script that is the print server engine.
   5. API Key - If you are using APEX Office Print Cloud Server, enter the Print Server API Key. Do not enter an API Key if you running APEX Office Print locally.
   6. Print Timeout - Enter the number of seconds. Defines the transfer timeout for communicating with the print server in seconds.
9. Click Apply Changes.

Configure report printing settings in a runtime environment by starting SQLcl and running the following SQL statements.

To configure report printing settings in a runtime environment:

1. Start SQLcl and connect to the database where APEX is installed as SYS. For example:
   • On Windows:

     SYSTEM_DRIVE:\> sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   • On UNIX and Linux:

     $ sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

2. Run the following statement:

   BEGIN
       APEX_INSTANCE_ADMIN.SET_PARAMETER(PARAMETER_NAME, PARAMETER_VALUE);
       COMMIT;
   END;
   

   Available parameters are as follows:

   Parameter Name	Description
   PRINT_BIB_LICENSED	Specify either standard support or advanced support. Advanced support requires an Oracle BI Publisher license. Valid values include: STANDARD ADVANCED DOCUMENT_GENERATOR AOP NONE
   PRINT_SVR_HOST	Specifies the host address of the print server converting engine, for example, localhost. Enter the appropriate host address if the print server is installed at another location.
   PRINT_SVR_PORT	Defines the port of the print server engine, for example 8888. Value must be a positive integer.
   PRINT_SVR_PROTOCOL	Valid values include: http https
   PRINT_SVR_SCRIPT	Defines the script that is the print server engine, for example: /xmlpserver/convert

Determine report printing settings in a runtime environment.

To determine report printing settings in a runtime environment:

1. Start SQLcl and connect to the database where APEX is installed as SYS. For example:
   • On Windows:

     SYSTEM_DRIVE:\> sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   • On UNIX and Linux:

     $ sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

2. Run the following statement:

   SELECT 
   APEX_INSTANCE_ADMIN.GET_PARAMETER(PARAMETER_NAME)
   FROM DUAL;