Figure 11: EBSVISION Physical and Logical Architecture Objects Created and Linked in ODI
3. The first major step of our environment configuration is complete: our source system. The next task is to inform Configuration Manager of which BI Applications "offerings" are licensed to be used in this environment. The key emphasis here is what is licensed to be implemented, not what you're actually implementing at this time. We will configure that in a later step. Note that for demo or personal training purposes, you can select any offering from this list, but you should ensure that you only select those that you have licensed when working on a full implementation project – see your local Oracle representative, or an Oracle partner, if you need your licensing to be clarified or extended to include the BI Applications.
Moving back to your Web browser, click System Setups > Manage Business Intelligence Applications on the left-hand sidebar in Configuration Manager. Then, within the Manage Business Intelligence Applications page, locate the Oracle Supply Chain and Order Management Analytics entry and check the Enabled checkbox next to it to select that BI Applications offering (you may need to use the scroll bar to see this checkbox). Then, press the OK button in the dialog then is then displayed, and once it closes, pressSave.
Next, select the Business Intelligence Application Offerings and Associated Sources tab and expand Oracle Supply Chain and Order Management Analytics. The 'EBSVISION' checkbox in the Enabled column should be checked; once confirmed, press the Done button to return to the main Configuration Manager page.
4. While there are other configurations that could be done at this time, we've completed the minimum configurations required to move to the next phase, which is to generate and execute a Domain Load Plan. Load plans are the steps that execute a data load and are similar to execution plans in earlier, DAC-based versions of the BI Applications. The difference is that BI Applications 11.1.1.7.1 contains metadata about what steps are required to load every application and you must generate an executable load plan based on what you specifically plan to load. This potentially reduces the amount of step pruning you need to do after the fact.
There are also different types of load plans. The Domain-Only Load Plan will run some targeted data extractions from the source system to assist with configurations for specific applications. This stands in contrast to a Source Extract And Load Plan, which focuses on loading the facts and dimensions in the warehouse.
In the next step you will build your first load plan, in this instance a domain load plan to extract data from the source system to support loading the Inventory Transactions fact table group within the Supply Chain and Order Management offering. To start this process, using your Web browser and still within the Configuration Manager application, click Load Plans Administration > Manage Load Plans
Then, when the Manage Load Plans page opens, click the green plus symbol to add a new load plan, and enter the following details to define the new domain load plan:
Name: EBSVISION SCOM Domain
Description: [optional]
Load Plan Type: Domain-only Extract and Load (SDE and SIL)
Source Instances: EBSVISION
(The above fields can be altered based on your source system except 'Load Plan Type'.)
Then, press the Next button to display the list of available fact table groups; check the checkbox in the Selected column for theInventory Transactions (INVTRX_FG) fact group, which you can find under the Oracle Supply Chain and Order Management Analytics > Logistics fact grouping.