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 Process workflow 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.