Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Strategic Sourcing Analytics > Process of Aggregating Siebel Strategic Sourcing Analytics Tables >

Configuring the Purchase Receipts Aggregate Table

This task is a step in the Domain Values and CSV Worksheet Files for Siebel Strategic Sourcing Analytics.

To load the Purchase Receipts aggregate table (IA_PURCH_RCPTS_A1), you need to configure the post-load-processing parameter file and the source system parameter files, and run the initial workflow and then the incremental workflow.

To configure the file_parameters_plp.csv parameters file

1. Open the file_parameters_plp.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Purchase Receipts Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_PLP_PURCH_RCPTS_A1_AGG_INIT:GRAIN session value.

3. Save and close the file.

To configure the Purchase Receipts aggregate table for Oracle 11i

1. Open the file_parameters_ora11i.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Purchase Receipts Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_I_PURCH_RCPTS_PRE_D:SOURCE_ID and S_M_I_PURCH_RCPTS_PRE_U:SOURCE_ID session values.

3. Save and close the file.

To configure the Purchase Receipts aggregate table for SAP R/3

1. Open the file_parameters_sapr3.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Purchase Receipts Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_S_PURCH_RCPTS_PRE_D:SOURCE_ID and S_M_S_PURCH_RCPTS_PRE_U:SOURCE_ID session values.

3. Save and close the file.

To configure the Purchase Receipts aggregate table for Universal Source

1. Open the file_parameters_univ.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Replace the default PARM_SVALUE2 values with your new values.

   For a list of values for each parameter see the About Configuring the Purchase Receipts Aggregate Table.

   The default values are shown in the following table:

NOTE:  You need to use single quotes for the S_M_F_PURCH_RCPTS_PRE_U:SOURCE_ID session value.

3. Save and close the file.