Bulk Import Overview

Use Oracle Trading Community Architecture (TCA) Bulk Import to load data from legacy or other external systems in bulk into the TCA Registry. TCA provides validations and optional de-duplication to ensure the quality of the imported information.

The import is only for information on the party level. To import both party and account information, use Customer Interface. See: Customer Interface.

Note: Customer Interface runs independently and does not regard party information already loaded in the TCA Registry. In particular, if the process does not find an existing account site or account contact point, it creates a new account site or contact point, as well as the associated party site or contact point, even if the party level versions already exist. As a result, if duplicates are created, use Party Merge or Oracle Customer Data Librarian to resolve them. See: Party Merge Overview or De-Duplication Overview.

Your administrator can set up for Bulk Import. See: Setting Up Bulk Import.

Bulk Import Process

  1. Load data into the interface tables. See: Loading Data into the Interface Tables.

  2. Run the Import Batch to TCA Registry program to import a batch into the TCA Registry. See: Import Batch to TCA Registry.

  3. Optionally run the Import Batch De-Duplication report to view results of batch de-duplication. See: Import Batch De-Duplication Report.

  4. Run the TCA Import Error report to view errors, and reload the corrected data. See: Resolving Errors.

  5. Purge data from the interface tables. See: TCA Import Batch Purge.

Related Topics