After data from a source file is successfully loaded into the import interface tables, that set of data is automatically included in a new import batch. The import batch name is the same as the file load name, and the batch ID is automatically generated if the batch comes from File Load.
Aside from import batches that contain data loaded using the File Load feature, import batches with data from other methods, such as D&B Load and SQL/ETL Load, are also displayed. See: Loading Data into the Interface Tables.
Note: Data must be loaded into the interface tables in the context of a batch. If using File Load, a batch is automatically generated. For any other loading tool, create a new batch with a new unique batch ID, which is required for loading into the interface tables. See: Generating Batches.
An import batch contains information about transferring a set of records from the interface tables into the TCA Registry, including settings for optional data quality preimport processes that you can perform on the batch.
Batch de-duplication: Identify and resolve duplicates within the batch that you are importing from the interface tables.
Address validation: Validate addresses within the batch against authorized sources.
Registry de-duplication: Identify and resolve duplicates between the interface tables and the Registry.
If automatic import after file load is implemented, then import batches are created with the import processes already running. If not, you must manually define the import and submit the batch for the import process. See: Setting Up Import, Oracle Customers Online Implementation Guide.
All import batches are considered active, with any import or batch status, until they are purged. See: Purging Import Batches.
You can search for active import batches, and purged batches in the batch import history, by:
Address Validation Status: The status of the address validation process.
Batch De-Duplication Status: The status of the batch de-duplication process.
Note: No status for address validation or batch de-duplication means that the import batch is either rejected or not yet defined, while the Declined status indicates that the preimport process is declined as part of the batch definition.
Batch ID: The import batch ID.
Batch Name: The user-defined import batch name, which is the same as the name of the file load that provided the same set of data into the interface tables.
Batch Status: The status of the import batch itself, including:
Blank: The import batch was generated in this application and does not yet have data loaded for it in the interface tables.
Active: The import batch is new and not yet defined for import.
Action Required: Preimport processes have either the Declined or Completed status, and the import batch was defined with preview before the actual import. You can now update the batch and submit it for the import.
Or, the import status is Completed with Errors or Completed with Error Limit Reached. You must resolve errors and import corrected records.
Pre-processing: Reimport processes are running.
Post-processing: Post-import processes are running. See: Postimport Processes.
Rejected: The import batch was rejected and cannot be defined for import.
Stage: The stage of the import process, including the percentage complete within that stage.
The Pending, Processing, Error, and Completed statuses are the same as for import status.
Created By (for active batches search only): The user who created the file load that corresponds to the import batch.
Import Status: The status of transferring the import batch from the interface tables into the TCA Registry, including:
Blank: Either the import batch is not yet defined, or it is was defined with preview before the actual import.
Action Required: Preimport processes have either the Declined or Completed status, and the import batch was defined with preview before the actual import. You can now update the batch and submit it for the import.
Completed: The data in the batch was successfully imported into the TCA Registry.
Completed with Errors: The import process has completed. There are errors, but successful records might already be imported.
Completed with Error Limit Reached: The import process has stopped after reaching a specified number of errors, as set by your administrator. Successful records might already be imported.
The Rejected status is the same as for batch status. The Pending, Processing, and Error statuses reflect the concurrent program status.
Purged By (for purged batches search only): The user who purged the import batch.
Source System: The legacy, third party, or other external system that the source file data comes from.
In the Batch Import History page, you view the purged batches in the search results. See: Viewing Batch Import History.
In the Import Batches page, after you view the search results, you can:
Generate Batch: Create batches before loading data into the interface tables. See: Generating Batches.
Reject: Reject import batches so that they are not eligible for import into the TCA Registry. The data remains in the interface tables until you purge the import batch. You can reject any batch except those that are currently being imported, already completed the import process, or are already rejected.
Activate Batch: Updates batch status to Active for batches generated in this application. See: Generating Batches.
Define Import: Define imports to submit import batches for preimport and import processes, or only preimport processes. You can define import for any batch except those that are being or were already imported, or are rejected. See: Defining Imports.
Batch Name: View import batch details for any batch except those with preimport or import process currently running. You can also resolve any import errors and resubmit the batch. See: Viewing or Updating Import Batches and Resolving Import Errors.
Update: If only preimport processes were run for the batch, then you can preview results and resubmit for the actual import process. See: Viewing or Updating Import Batches.
Purge: Purge import batches, except those with preimport or import process currently running. See: Purging Import Batches.