Define Business Intelligence Applications Instance: Source System Tab

The Source Systems tab on the Define Business Intelligence Applications Instance page lists the registered source instances for the current deployment. You can use this tab to register a source instance, edit a registered source instance, or disable a source instance. Note that in a new installation of Oracle Business Intelligence Applications (Oracle BI Applications), no source instances will be listed.

A source system is the transactional system that serves as the source of data for the Oracle Business Analytics Warehouse. A source instance is a particular instance of a source system and is given a name by the Oracle BI Applications Administrator. An Oracle BI Applications instance is an Oracle BI Applications environment consisting of one Oracle Business Analytics Warehouse and one or more source instances.

The table below provides a description of the user interface elements in the Source Systems tab.

Element Description

Source Instance Name column

The name given by the Oracle BI Applications System Administrator to a transactional system that serves as a source of data for Oracle BI Applications data load. The source instance is important because functional setup tasks, and the setting of values for objects such as parameters and domain maps are performed in relation to a source instance. Each source instance must have a unique data source number.

Description column

Additional information specified by the Oracle BI Applications System Administrator about the source instance.

Product Line column

The source instance product line.

Product Line Version column

The version number of the source instance product line.

Data Source Number column

The unique, user-specified number used to identify the source instance.

The Data Source Number value specifies a data source so that the data can be identified in the Oracle Business Analytics Warehouse. Each source instance must have a unique Data Source Number.

Enabled column

When you register a source instance, it is enabled by default. Enabling a source instance makes the setup data associated with that source instance available in Configuration Manager.

To enable a source instance, highlight the source instance, and then select Enable from the Actions menu. To disable a source instance, highlight the source instance, and then select Disable from the Actions menu.

If you make a mistake in the source instance definition that you are not able to correct, you must disable that source instance and register a new source instance. For example, if the value for Data Source Number is incorrect, then you cannot edit a source instance and correct the Data Source Number value. In this scenario, you must disable the incorrect source instance and register a new source instance.

Data Server Details window

If a PeopleSoft or Oracle Fusion Applications source instance is selected in the Source Systems tab, the Data Server Details window is displayed. The Data Server Details window is read-only.

Actions menu

The Actions menu contains the following options:

  • Register

    Select Register to display the Register Source dialog where you can register a new source instance. You can also access this dialog by clicking the Add icon. The fields in this dialog are the same as the columns described above.

  • Edit

    Select Edit to edit an existing source instance using the Edit dialog. You can also access this dialog by clicking the Edit icon. Note that you can only edit an 'Enabled' source instance.

  • Enable

    Select Enable to enable a source instance. When you register a source instance, it is enabled by default. A source instance must be enabled for the setup data associated with that source instance to be available in Configuration Manager.

  • Disable

    Select Disable to disable a source instance.