Integrate Oracle APEX with BI Publisher for Enterprise Reporting

 Oracle Application Express (APEX) Configuration for Oracle BI Publisher Integration

1. Login to Oracle APEX Administration Console using URL http://{hostname}:{port}/apex/apex_admin
2. Navigate to Menu Manage Instance > Instance Settings
3. Open Report Printing section
4. Setup the BI Publisher integration settings as below

Print Server - Standard or Advanced (requires Oracle BI Publisher)
select Advanced

Print Server Protocol - HTTP or HTTPS
select HTTP

Print Server Host Address - provide the URL of Oracle BI Publisher

Print Server Port - 7001 or 9704
provide port number based on your installed BI Publisher configuration (typically 7001)

Print Server Script - provide the path for BI Publisher Conversion Script
provide /xmlpserver/convert

5. Configuration is complete and your Oracle Application Express (APEX) is ready to run reports.