Taking EBS as the beginning point, there are a few steps to complete in order to enable the communication with Oracle BI (BIP in particular).
To enable integration with Oracle EBS, you must create a database object and connection pool for the EBS database in the Oracle BI repository.
To create a database object go to the Oracle BI Administration page found in:
Programs | Oracle Business Intelligence | BI Administration
Open the repository that you want to integrate with Oracle EBS. Right-click on the physical layer and select New Database. Enter a name and select the database type:
Name: Enter a name for the new database (for example, Oracle EBS 12).
Database: Select the appropriate Oracle Database type for your Oracle EBS database (for example, Oracle 10g R2 or Oracle 11g).
Click on OK.
In order to create a connection pool, right-click on the created database object and...