Creating the Source System for Your Data


Let's create a source system to identify the source of your data in an import file.  You must include the source system code in the Original System attributes.

 

This is the second in a series of four demonstrations that show how to import a sample file with sales accounts using File-Based Data Import.

 

These demonstrations include:

1. Understanding the sample sales accounts import template

2. Creating the source system for your data

3. Importing sales accounts from a file

4. Verifying the imported sales accounts


Steps:

  1. You create a source system so that you can identify the source of your legacy data in your import file.

     

    Oracle permits you to import data from multiple sources and if you didn't identify the source, there would be a slight chance that the IDs, which identify each record in your files, may not be unique.

    Step 1

  2. When you create the source system, you enter a code which you then use as the value in all of the Original System attributes in the import file.

    Step 2

  3. This code, together with the Original System Reference IDs in the file, ensure uniqueness of your data.

    Step 3

  4. To create the source sysem, sign in as a user with setup responsibilities and navigate to the Setup and Maintenance work area.

    Step 4

  5. Click the Navigator link.

    Step 5

  6. Click the Setup and Maintenance link.

    Step 6

  7. Search for the Manage Trading Community Source Systems task.

    Step 7

  8. Step 8

  9. Click the Search button.

    Step 9

  10. Click the Go to Task button.

    Step 10

  11. Now let's create the source system.

    Step 11

  12. Click the Create button.

    Step 12

  13. In the Code field, enter the value you will use in the import file.

    Step 13

  14. And enter a name for the source system.

    Step 14

  15. Enable this source system for importing customer data by selecting the Enable for Trading Community Members option.

    Step 15

  16. Let's save our new source system and we are done.

    Step 16

Table of Contents  Start Topic