Oracle Customer Hub (UCM) Master Data Management Reference > Using Oracle Data Governance Manager >

Administering Batch Imports

The Consolidate module enables you to manage import operations in Oracle Customer Hub (UCM). Besides running new batch jobs using prebuilt template files, you can do the following:

• Report on batch imports completed or currently running.
• View batch reports grouped by completed rejected criteria
• Fix any rejected records and then restart a batch process.
• View how completed records were handled by the batch process, such as records that were inserted or updated or both.

Use the following task to run a batch import job.

To run a batch import job

1. From the Oracle Data Governance Manager home page, click Consolidate.
2. In the Consolidate screen, click the File Import tab.
3. From the Choose Template list, select a mapping template.
4. From the Delimiter list, choose a delimiter, if necessary.
5. Click Browse, then select a batch file.
6. Click Load.

   The file information appears in the window.

7. Click Import.

   The records from the flat files contained in the batch job to the UCM SDH staging tables. When the loading is complete, the batch workflow is started, and the records are moved from SDH tables and saved to the base tables.

Use the following task to view a batch job.

To view a batch job

1. After successfully loading a batch file and initiating the import in Oracle Customer Hub (UCM), click the Batch Report tab.

   The batch job that is currently running is displayed. The Completed, Pending, and Jobs in Progress are also displayed.

2. Click any part of the pie chart to view information about the batch jobs.

Use the following task to view rejected records from a batch job.

To view rejected records from a batch job

1. From the Consolidate screen Batch Report view, click the Rejected segment of the pie chart.

   The Rejected Batch Details view appears.

2. In the By Object Type, choose Account or Contact from the list.
3. In the Error Message and Error Code field, view details about the record was rejected for inclusion into the UCM SDH tables.
4. Make the required changes to the record, then click Save.

   The record will be queued into the next batch job.

Use the following task to view completed batch records.

To view completed batch records

1. From the Consolidate screen Batch Report view, click the Completed segment of the pie chart.

   The Completed Batch Details view appears.

2. In the By Object Type, choose Account or Contact from the list.
3. View a graph of the insert and update operations made to the chosen object.