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

Modifying the Workforce Payroll Filters

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

Oracle Business Intelligence Applications is preconfigured to extract the input value name of Pay Value. Oracle Business Analytics Warehouse does not extract classification elements such as Information, Balance, or Employer. To modify the Payroll filter perform the following procedure.

NOTE:  If you change the Payroll filter, you need to also change the Oracle BI metadata, so your reports are run correctly.

To modify the Payroll filters

1. Open the parameterfileOLTP.txt file using Notepad in the installation directory in \OracleBI\DAC\Informatica\parameters\input.
2. Locate the sections [SDE_ORA_PayrollFact] and [SDE_ORA_PayrollFact_Full].

   For example, the file might contain the following sections:

   [SDE_ORA_PayrollFact]

   $$DATASOURCE_NUM_ID=2

   $$TENANT_ID=DEFAULT

   $DBConnection_OLAP=PARAM_OLAP

   $DBConnection_OLTP=PARAM_OLTP_ORA11I

   mplt_BC_ORA_PayrollFact.$$hint1=/*+ RULE*/

   mplt_BC_ORA_PayrollFact.$$INITIAL_EXTRACT_DATE=01/01/1970

   mplt_BC_ORA_PayrollFact.$$INITIAL_EXTRACT_DATE1=01/01/1970

   mplt_BC_ORA_PayrollFact.$$LAST_EXTRACT_DATE=01/01/1970

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER1= AND PAY_INPUT_VALUES_F.NAME='Pay Value'

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER2= AND CLASSIFICATION_NAME NOT LIKE '%Information%'

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER3= AND CLASSIFICATION_NAME NOT LIKE '%Employer%'

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER4= AND CLASSIFICATION_NAME NOT LIKE '%Balance%'

   [SDE_ORA_PayrollFact_Full]

   $$DATASOURCE_NUM_ID=2

   $$TENANT_ID=DEFAULT

   $DBConnection_OLAP=PARAM_OLAP

   $DBConnection_OLTP=PARAM_OLTP_ORA11I

   mplt_BC_ORA_PayrollFact.$$hint1=/*+ RULE*/

   mplt_BC_ORA_PayrollFact.$$INITIAL_EXTRACT_DATE=01/01/1970

   mplt_BC_ORA_PayrollFact.$$INITIAL_EXTRACT_DATE1=01/01/1970

   mplt_BC_ORA_PayrollFact.$$LAST_EXTRACT_DATE=01/01/1970

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER1= AND PAY_INPUT_VALUES_F.NAME='Pay Value'

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER2= AND CLASSIFICATION_NAME NOT LIKE '%Information%'

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER3= AND CLASSIFICATION_NAME NOT LIKE '%Employer%'

   mplt_BC_ORA_PayrollFact.$$RUN_RESULT_FILTER4= AND CLASSIFICATION_NAME NOT LIKE '%Balance%'

3. Change the following sections, as required (highlighted in bold above):

   PAY_INPUT_VALUES_F.NAME='Pay Value'

   CLASSIFICATION_NAME NOT LIKE '%Information%'

   CLASSIFICATION_NAME NOT LIKE '%Employer%'

   CLASSIFICATION_NAME NOT LIKE '%Balance%'

4. Save and close the file.