A file load contains information about loading data from one comma-separated value (CSV) file, or a file delimited by another allowed character, into the import interface tables. The file load:

• Identifies the source file to load, as well as the location, format, and content of the file.

• Defines how attributes from the file map to the interface table columns.

Each line in the source file, as separated by the end-of-line character, is called a party record. A party record contains a set of attributes related to an organization or person.

After a file load successfully completes the loading process, the interface table data from that source file is included in an import batch. The import batch has the same name as the file load, and contains information about transferring that same data from the interface tables into the TCA Registry.

A file load is active until its corresponding import batch is either:

• Successfully processed, and the data from the source file is imported into the TCA Registry.

• Rejected in Oracle Customer Data Librarian, and not available for import. See: Managing Import Batches.

In the completed file loads history, you can view completed, or inactive, file loads and their details. See: Reviewing File Load Details.

Searching for File Loads

You can search for active or completed file loads that you created by:

• Load Name: The user-defined file load name, which is not necessarily the same as the source file name.

• Request ID: The request ID of the interface table loading process, Import CSV Flow : Load CSV Data.

• Creation Date: The date that the file load was created, which is not necessarily the same as the source file creation date.

• Load Status: The status of the interface table loading process. Aside from Pending, Processing, and Completed, possible statuses include:

  • Partially Completed with Errors, Awaiting Resolution: Records with no errors are successfully loaded into the interface tables, but there are records with errors that still must be resolved, either online or offline.

  • Partially Completed with Errors, Awaiting Reload: Errors from the load are resolved offline, and the corrected records need to be reloaded.

• Import Status: The status of importing the file load's corresponding import batch from the interface tables into the TCA Registry.

File Loads Process

1. Load a new source file by creating a file load.

2. View details of the file load, for any load or import status.

3. Correct errors from the loading process, if any.

4. If the load errors were corrected offline, you can load the file with the corrected records.

5. If you decide not to correct errors or load the corrected file, you can remove file loads with the Partially Completed with Errors, Awaiting Resolution or Partially Completed with Errors, Awaiting Reload status. Removed file loads do not appear in the completed file loads history.

6. After the file load's corresponding import batch is either rejected or successfully imported, you can view the file load in the completed file loads history.

You can also manage mappings that define which target attribute to load each source attribute value into. See: Managing Mappings.