Thursday, October 18, 2007

Setting Up Oracle Business Intelligence (BI) Publisher

Well, it appears that if you want nice looking reports from APEX, you need a little dingy called Oracle BI (Business Intelligence). This program helps you to deal with building interfaces for report printing. To do this, you need to download the latest version of Oracle BI Publisher from the Oracle Website. After this, you will need to install it per the instructions. Next, you will need to log into APEX to set it up. This is an important point, you must log in with the ADMIN username in order to get to the right areas for setting up the program. So, you must be in the ADMIN configuration to set up BI within APEX. Spent 2 hours finding this one out tonight. You also must know that in order to log on in this configuration, you will need to go to the following page in your application express system:

http://localhost:8080/apex/apex_admin

Cheers
Jason