B query.properties File

The query.properties file is used during reconciliation. While deploying the connector, you copy this file into the following directory:

OIM_home/xellerate/XLIntegrations/OracleEmpRecon/config

The query.properties file contains the following variables:

• getEmp1 Variable

  The getEmp1 variable is used to hold the SELECT clause of the SQL query that fetches data from the target system during reconciliation.

  You must not modify the value of this variable.

• getEmp2 Variable

  The getEmp2 variable is used to hold the FROM and WHERE clauses of the SQL query that fetches data from the target system during reconciliation. The SELECT clause of this query is stored in the getEmp1 variable. You can modify the value of the getEmp2 variable while performing the procedure described in the "Adding Custom Attributes for Reconciliation" section. If the custom attribute that you want to add belongs to a table that is not listed in the FROM clause stored in the getEmp2 variable, then you add the name of that table to the FROM clause.

• getNewEmps Variable

  The getNewEmps variable is used to hold the values of the filter attributes that you specify when you want to configure limited reconciliation. These filters are applied during reconciliation. They are discussed in the "Employee Reconciliation Scheduled Tasks" section.

  You must not modify the value of the getNewEmps variable.

• getAllEmps Variable

  The getAllEmps variable is used to hold the SQL query that is used for the reconciliation of account deletion information from the target system.

  You must not modify the value of this variable.