Populating the Repository

Use the following procedures to load HRMS data into the Employee Directory repository. Prior to loading the data, you can optionally configure the data for your legislation and country requirements.

  1. Use the supplied override packages to override values in the repository table columns for individual legislation teams and customers if required. The overrides are effective when you refresh the repository in either Complete or Incremental refresh mode.

    See: Setting up Legislation and Customer Overrides

  2. In the Submit Request window, run the concurrent program Refresh Employee Directory. This program populates the repository with data from HRMS tables.

    See: Submitting a Request

    The Refresh Employee Directory concurrent program uses the following parameters:

    Parameter Options Description
    Refresh Mode Complete/Incremental Use the Complete refresh mode for the initial population of data to the Employee Directory repository tables and intermittently in the future.
    A Complete refresh rebuilds all the data in the repository and clears deletes. This process requires downtime. Perform a full refresh once every six months or so to clear deletes from the repository, depending on the rate of staff turnover.
    Use Incremental refresh mode at regular intervals to synchronize the data between Oracle HRMS and the Employee Directory. The frequency depends on how current you require the data to be.
    Refresh Date Leave this blank to use the system date. The concurrent program will collect data applicable to this date.

    Warning: Oracle recommends you leave this parameter blank for scheduled refreshes. If you insert a date, every time the concurrent program runs, it will collect data for the same date - in other words, the data will never be updated.

    Source System A valid host system This parameter identifies the host system. You should select 'PER'. By default 'PER' identifies Oracle HRMS.
    Process Multiple Assignments Yes/No (default) Use the default option of No to process only primary assignments. Set it to Yes to process secondary assignments as well.

    Note: If you run the Refresh Employee Directory concurrent program in Complete Refresh mode with Process Multiple Assignments set to Yes, subsequent runs in Incremental Refresh mode with Process Multiple Assignments set to No will have no effect. Incremental Refresh mode does not remove previously populated secondary assignments.

    Conversely, if you run this program in Complete Refresh mode with Process Multiple Assignments set to No, then subsequently run in Incremental Refresh mode with Process Multiple Assignments set to Yes, secondary assignments will be populated.