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
-
In the Data Exchange work area, select Import and Load Data to open the Import and Load Data page.
-
Click Import File.
-
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.
-
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.
-
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.
-
Click Submit. A confirmation message showing the process ID appears.
-
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 hcm/dataloader/import account. To import and load a file that's already on the WebCenter Content server:
and upload the file to the-
In the Data Exchange work area, select Import and Load Data to open the Import and Load Data page.
-
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.
-
Select your file in the Import File dialog box and click Submit Now to immediately initiate the file processing
-
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.
-
In the Data Exchange work area, select Import and Load Data to open the Import and Load Data page.
-
Click Import File.
-
In the Import File dialog box, select your file, either locally or from the Oracle WebCenter Content server.
- Click Review Parameters.
- In the Schedule section, specify Run as Using as schedule and specify the Start Date.
- Click Submit.
Here's a tutorial on creating and maintaining data with HCM Data Loader Create and Maintain Data with HDL