Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Workforce Analytics > Process of Configuring Workforce Operations for Oracle 11i >

Modifying the Snapshot Extract Date for Workforce Profile


This task is a step in the Process of Configuring Workforce Operations for Oracle 11i.

By default, the $$EXTRACT_DATE is set to 01/01/1970 for Oracle 11i. However, if you want to modify this value, you can do so by modifying the file_parameters.ora11i.csv file in the installation directory. This file contains this default value for the sessions in Table 61.

Table 61. Sessions with 01/01/1970 as the Default Snapshot Extract Date
Session

S_M_I_EMP_SNAPSHOT_1_EXTRACT_P1

S_M_I_EMP_SNAPSHOT_2_EXTRACT_P2

S_M_I_EMP_SNAPSHOT_3_EXTRACT_P3

S_M_I_EMP_SNAPSHOT_4_EXTRACT_P4

After you have modified the file, the next time you run the session, the new snapshot extract date is populated.

To redefine the Snapshot Extract date

  1. Open the file_parameters_ora11i.csv file in the installation directory, in $pmserver\srcfiles.
  2. In the PARAM_DVALUE_1 column, enter the date for which you want the data extracted.

    Perform this action for all applicable sessions. By default the date format is YYYYMMDDHH24MISS. For example, the default date of 01/01/1970 would appear as 19700101000000.

  3. Save and close the file.
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide