Loading a new source file into the import interface tables involves these main steps:

1. Defining the file load.

2. Providing the source-to-target attribute mapping.

3. Reviewing and submitting the file load.

Prerequisites

• You should have strong knowledge of the data and data structure to be imported, and experience working with the source files.

  Suggestion: If the source file does not have a file header, add it to the file.

  • The column delimiter for the source file must be one of these:

    ,

    /

    ;

    \

  • If used, the character to enclose fields in the file must be one of these:

    "

    '

  • The format of date values in the file must be one of these:

    DD-MM-YYYY

    DD-MON-YYYY

    MM-DD-YYYY

    MON-DD-YYYY

• Make sure each record to be imported has a unique ID. See: Unique IDs for Interface Table Records.

• Make sure the source file contains information for either organizations or persons, not both.

  A source file for persons can also include persons who are contacts for organizations. All persons with contact relationships must have an associated organization name. After import, the corresponding contact relationships are also created in the TCA Registry. This feature does not include persons as contacts for other persons. See: Introduction to Contacts and Contact Relationships.

  Note: Addresses and contact points in the person record apply to the person being loaded, not to any contact relationships that the person belongs to.

• The source file must be a CSV file, or a file delimited by another allowed character, and located in a workstation on your organization's network.

Other Sources

• Bulk Import Interface Tables, Oracle Trading Community Architecture Reference Guide