Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle Financial Analytics for Oracle 11i >

Configuring the Customer Costs Lines and Product Costs Lines Tables for Oracle's Siebel Profitability Analytics

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

In Oracle's Siebel Profitability Analytics, the Customer Costs Lines and Product Costs Lines fact tables store the costing and expenses for the Profitability functional area. You need to use these tables with General Ledger Revenue and General Ledger COGS fact tables.

The General Ledger Revenue and General Ledger COGS fact tables are populated by the or Oracle 11i source system, but the Customer Costs Lines and Product Costs Lines fact tables are populated by the universal source system.

To load the Customer Costs Lines and Product Costs Lines tables

1. Open the customer_cost_line.csv file in the $pmserver\Sample Universal Source Files folder.
2. Insert a record into the file for each customer costing transaction you want to load into the Customer Cost fact table.

   For the DATASOURCE_NUM_ID column, you need to provide the same source identifier value as in the file_parameters_ora11i.csv file.

3. Save the file in the $pmserver\srcfiles directory, then close the file.
4. Repeat steps 1 to 3 for the file_product_cost.csv file.