Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for Oracle 11i >

Configuring the DAC parameter for Purchase Cycle Line

This task is a step in the Process of Configuring Supply Chain Analytics for Oracle 11i.

To load the purchase cycle line table (W_PURCH_CYCLE_LINE_F), the ETL tasks needs to distinguish data coming from Oracle 11i applications from data from other applications such as SAP and PeopleSoft. This configuration explains the detail steps.

To configuring the DAC parameter for purchase cycle line

1. Login to your DAC repository
2. Go to the Tasks Tab, query for task SIL_PurchaseCycleLinesFact.
3. Click Parameters Child tab. Change the values for parameter $$ORA_DATASOURCE_NUM_ID_LIST from (2,4,5) to the list of Data Source NUM ID you defined for your Oracle connections
4. Repeat the same for task SIL_PurchaseCycleLinesFact_Extract
5. For more information on configuring DAC, please refer to Oracle Business Intelligence Data Warehouse Administration Console Guide.