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

About List Management in Oracle Customer Hub (UCM)

Oracle Customer Hub (UCM) allows the business user to perform bulk import operations on account and contact records from external systems. The configurable process allows the business user to import from the following file formats: delimited text files (such as CSV, tab delimited, fixed width, or other delimiter) and XML files. The automated process consists of two steps:

• A list import into SDH (Source Data History) tables.
• A batch process that calls existing Oracle Customer Hub (UCM) services for data cleansing, data matching, and survivorship. These processes identify the best version record before committing the record to a base table. The best version record can then be published to all subscribing systems.

Oracle Customer Hub (UCM) Data Steward Functions:

The data steward performs the following functions with Oracle Customer Hub (UCM) data:

• Imports data from the flat files into staging tables (SDH tables).

  If an error occurs when importing files into SDH tables, then the data steward consults the Import-Exceptions view for a detailed view of the records that failed the import. From this view the data steward corrects the data in the flat file and reimports the remaining records.

• Uses the UCM Batch Data Management business service to move records from the staging tables to the base tables.

  If an error occurs, such as records failing validation, or a batch-mode process cannot be completed, then the data steward consults the Incomplete Transaction view, corrects the problem, and starts a rerun of the batch process to include the failed records.