Oracle Customer Hub (UCM) Master Data Management Reference > Configuring the List Import Function > Administering the List Import Function >

Creating and Scheduling Import Jobs

Each import job uses a reusable import mapping between the columns of the input data and the columns of the Oracle Customer Hub SDH tables. If you are performing an import operation and have not previously configured table mappings, then see Working with Import Job Data Mapping.

Oracle Customer Hub (UCM) can be configured to ignore certain fields and allow field updates while checking for duplicate records. After the job has been defined with import mappings, the job can be scheduled to run. Jobs can be executed on a recurring basis. You can monitor an activated job for exceptions and errors. For more information monitoring transactions, see Viewing and Correcting Incomplete Import Transactions. Use the following task to schedule a list import operation.

To schedule a list import operation

1. Navigate to the Administration - Universal Customer Master screen, then the Import view.
2. In the Import Jobs screen, query for an existing job, or click New to create a new one.
3. To create a new job, click the Select button in the Source field.

   The Systems window appears.

4. Click the system from which you want to import the batch file, for instance, AIA.
   The following table lists some of the fields for the new record.

   Field	Comments
   Job Name	In the text field, provide a unique job name.
   Main Object	Select the object that the list import job will be updating: either the Account or Contact object.
   Description	In the text field, describe the job.
   Importing Mapping	Click the Select button, then in the window, select the Import Mapping template. The import mapping are saved definitions of mapped fields in a chosen business component. Select from the saved definitions, or create a new definition of the mapped fields. For more information on mapping, see Working with Import Job Data Mapping.
   Active	A check appears in this field after you activate the import job. To activate the import job, click the Activate button. To stop the job, click the Deactivate button.
5. Click the Job Setup View tab to further define details about the source file that you will import. The following table lists the fields in the Source File Details area.

   Field	Comments
   File Selection	Specifies the source file. Choose one of the following values: Use exact file name. With this option, the File Name field on the form becomes editable. Use most recent file. Allows for recurring jobs.
   File Name	Click the Select button to browse to the source file or to enter a URL.
   Data Type	Click the data type. The options are: comma separated, tab delimited, other delimiter, fixed width, and XML.
   Delimiter	If the data type of the source file is Other Delimiter, then you must enter a character, otherwise this field is not editable. The tab delimited and CSV data types are automatically handled.
   Header Row Included	Select this check box if the file includes a header row.
   Schedule Mode	Click the list, and choose a value. The values include: One time (manually started), One time (scheduled), and Repeating. NOTE:  You must enter a value in the Schedule Mode field before activating a job.
   Start Date	Click the Select button, then chose a date and time from the Calendar window, and click Save.
   Repeat Frequency	Click the Select button to enter a numeric value for the frequency of the job being run. You set the unit of frequency in the next field.
   Repeat Unit	Choose the repeat unit. The values include: hours, days, weeks, or months.
   End Date	Click the Select button, then choose an end date and time from the Calendar widow, and click Save.

6. In the Input Arguments view, click New if you want to add new input arguments.
7. Click Activate to make the import job active.