1. HCM Data Loader
  2. Import and Load Data

Import and Load Data

The file of data that you're preparing to import and load using HCM Data Loader may exist locally on your desktop. Or, you may already have loaded it to the Oracle WebCenter Content server.

This topic provides steps for importing and loading your data interactively on the Import and Load Data page. It also describes how to load data to the application tables if you imported it separately to the stage tables.

Import and Load a Local File

  1. In the Data Exchange work area, select Import and Load Data to open the Import and Load Data page.

  2. Click Import File.

  3. In the Import File dialog box, click Browse to search for and select your file. Alternatively, drag the file from your local file browser to the Browse button.

  4. Click Submit Now to upload your file to Oracle WebCenter Content server to immediately initiate processing of your file.

    The file is loaded automatically to the HCM Data Loader import account hcm/dataloader/import and allocated a unique content ID.

  5. Alternatively, you can click Review Parameters to review and edit the default values of parameters or to schedule the submission of the file for a later date or time.

    Clicking Review Parameters navigates you to the Schedule Request, Parameters, and Schedule sections.

    In the Parameters section of the Import and Load Data page, review the parameter values and update them as required. Most of these values are set for the enterprise on the Configure HCM Data Loader page and can be left unchanged. The parameters are shown in this table.

    Parameter

    Description

    File Name

    The name of the file on the WebCenter Content server.

    Content ID

    The WebCenter Content ID for the file on the WebCenter Content server.

    File Action

    The Import only option imports the business object data into the stage tables but doesn't load it to the application tables. You can start the load process manually from the user interface.

    The Import and load option automatically loads to the application tables any business object that loads successfully to the stage tables.

    File Encryption

    The encryption type for the file.

    Maximum Percentage of Import Errors

    The percentage of file lines in error that can occur in a business object before the import process stops for the object.

    Maximum Percentage of Load Errors

    The percentage of business-object instances in error that can occur for a business object before the load process stops.

    Delete Source File

    Indicates whether the source file is to be purged from the WebCenter Content server after processing.

    Maximum Concurrent Threads for Import

    The maximum number of concurrent process threads to use for importing your data set.

    Maximum Concurrent Threads for Load

    The maximum number of concurrent process threads to use for loading your data set.

    Load Group Size

    The number of objects to process at a time on each thread. The record counts are updated only when processing completes for each group.

    Note: This parameter appears on the Schedule Request page only if the Enable Load Group Size Calculation configuration parameter is set to No. Otherwise, the load-group size is calculated automatically.

  6. Click Submit. A confirmation message showing the process ID appears.

  7. Note the process ID and click OK to close the Confirmation dialog box.

Import a File from the Oracle WebCenter Content Server

You can load a .zip file to the Oracle WebCenter Content server if you prefer. Select Navigator > Tools > File Import and Export and upload the file to the hcm/dataloader/import account. To import and load a file that's already on the WebCenter Content server:

  1. In the Data Exchange work area, select Import and Load Data to open the Import and Load Data page.

  2. On the Import and Load Data page, click Import File.

    In the Import File dialog box, select Oracle WebCenter Content Files. Any files in the hcm/dataloader/import account that haven't been processed are listed. You can filter the list to reduce it. For example, you can enter the file creation date.

  3. Select your file in the Import File dialog box and click Submit Now to immediately initiate the file processing

  4. Alternatively, you can click Review Parameters to review and edit the default values of parameters before submitting.

    Clicking Review Parameters navigates you the Schedule Request and Parameters sections.

    In the Parameters section of the Import and Load Data page, review the parameters, edit them as necessary, and click Submit.

Creating a One-Time Schedule

You can delay the submission of your file to be processed at a later date or time. This is useful for processing large files outside of working hours.

  1. In the Data Exchange work area, select Import and Load Data to open the Import and Load Data page.

  2. Click Import File.

  3. In the Import File dialog box, select your file, either locally or from the Oracle WebCenter Content server.

  4. Click Review Parameters.
  5. In the Schedule section, specify Run as Using as schedule and specify the Start Date.
  6. Click Submit.

Here's a tutorial on creating and maintaining data with HCM Data Loader Create and Maintain Data with HDL

Related Topics