When you migrate from a legacy system to Oracle Applications, you might need to transfer legacy data into the TCA tables. If you want to cleanse your legacy data before loading the data into the TCA tables, you can use D&B rationalization services. You can then use the Import Batch to TCA Registry program to create new parties in the TCA tables for the rationalized legacy data and use the Customer Interface program to create customer accounts for those parties.

To load rationalized legacy data:

1. Compile a list of the parties in your legacy system that you want D&B to rationalize. Each party in the list must include a unique identifier. This unique identifier maps to the Original System Reference field in the TCA tables.

2. Transfer your list to D&B. For more information, see: Transferring a Request List File to D&B.

3. D&B compares the companies in your list with the companies in the D&B database and rationalizes the data on your list. After rationalizing your data, D&B sends three flat ASCII files back to you:

   • First file: Matched, unmatched, and duplicate records as well as information appended from D&B's database for each company

   • Second file: All the duplicate records, listed in order of D-U-N-S number

   • Third file: Records that D&B could not find a D-U-N-S number for

4. Run the D&B Import Adapter request set to load D&B information from the first flat file into the interface tables.

5. Run the Import Batch to TCA Registry program to load D&B information from the interface tables into the appropriate TCA tables. The program creates parties in the TCA tables and maps the unique identifier that you identified in step 1 to the Original System Reference field.

6. Run the Customer Interface program to associate legacy customer accounts with your newly created parties. The Customer Interface program matches customer accounts to parties using the Original System Reference field. See: Customer Interface.