Configure Physical Data Source tab

In the Physical Data Source tab, select DataWarehouse entry and update the property values; for example:



Instance = orcl

Table Owner = baw

Table Owner Password = baw

DB Host = emok-us (your machine name)

Port = 1521



Click Test Connection.








Click Yes








Click OK to return to the previous screen. Click Save








In the Physical Data Source tab, select ORA_R12 entry and update the property values; for example:



Instance = R12PLY (Sandbox)

Table Owner = apps

Table Owner Password = apps

DB Host = ebcdell216.us.oracle.com (Sandbox)

Port = 10101



Keep other default values and settings intact. Click Test Connection.








Click Yes








Click OK to return to the previous screen. Click Save








In the Physical Data Source tab, select ORA_11_5_10 entry and update the property values; for example:



Instance = V11510 (Sandbox)

Table Owner = apps

Table Owner Password = apps

DB Host = ebcdell215.us.oracle.com (Sandbox)

Port = 10201



Keep other default values and settings intact. Click Test Connection. .








Click Yes








Click OK to return to the previous screen. Click Save