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

Modifying the Derive Flag for Workforce Profile


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

The $$DERIVE_FLAG setting determines where the specific history table is populated. By default, the $$DERIVE_FLAG is set to YES. However, if you want to change this flag, you can do so by modifying the file_parameters_ora11i.csv file in the installation directory. This file contains a default value for the sessions shown in Table 60.

Table 60. Derive Flag—Default Value for the Sessions
Session
Default Value

S_M_I_EMP_HISTORY_A1_DERIVE

YES

S_M_I_EMP_HISTORY_A2_DERIVE

YES

After you have modified the file, the next time you run the session, the new Derive Flag value is populated.

To modify the Default Derive Flag

  1. Open the file_parameters_ora11i.csv file in the installation directory, in $pmserver\srcfiles folder.
  2. Replace the default Derive Flag with the new Derive Flag.

    Perform this action for all applicable sessions, as shown in the following figure.

    S_M_I_EMP_HISTORY_A1_DERIVE:DERIVE_FLAG

    0

    0

    0

    0

    S

    NO

    S_M_I_EMP_HISTORY_A2_DERIVE:DERIVE_FLAG

    0

    0

    0

    0

    S

    YES

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