Adding Import Formats

You work with import formats on the Import Format screen, which consists of three sections:

• Import Format Summary—Displays common information relevant to the source and target applications.

• Import Format Detail—Enables you to add and maintain import format information.

• Import Format Mappings—Enables you to add and maintain import format mapping information.

To add an import format for an Enterprise Resource Planning (ERP) source:

1. On the Setup tab, under Integration Setup, select Import Format.

2. In the Import Format summary task bar, select Add.

   In the upper grid of the Import Formats screen, a row is added.

3. In Name, enter a user-defined identifier for the import format.

   You cannot modify value in this field after a mapping is created for this import format.

4. In Source, select the source system.

5. In Target, select the target system.

6. Optional: In Concatenation Character, specify the character to use for concatenating two segments when multiple segments are specified for sources.

   Set the concatenation member by specifying the concatenation character.

   For non-ARM data loads and metadata loads, the underscore character "_" is used to concatenate two segments. For ARM data loads, you cannot use an underscore character with a mapping that uses the "Like" method. Therefore, for ARM mappings, specify a different concatenation character for the data load mapping details.

7. In Description, enter a description of the import format.

8. In Accounting Entity, select the accounting entity.

   For an E-Business Suite source system, the accounting entity is the ledger. For PeopleSoft source systems, the accounting entity is the business unit.

9. Define the import mappings from the source application to the target application.

   See Defining the Import Format Mappings.

   For information on one-to-one mappings and many-to-one mappings, see Defining Import Format Mappings.

To add an import format for a file-based data load system:

1. On the Setup tab, under Integration Setup, select Import Format.

2. In the Import Format summary task bar, select Add.

   In the upper grid of the Import Formats screen, a row is added.

3. In Name, enter a user-defined identifier for the import format.

   You cannot modify the value in this field after a mapping has been created for this import format.

4. In Description, enter a description of the import format.

5. In Source, select File for the source system.

6. From File Type, select the format of the file.

   • Fixed - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Delimited - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Multi Column - Numeric Data

     See Loading Multi-Column Numeric Data.

   • Delimited Data - All Data Type

     See Setting the Import Format Data Types.

   • Fixed Data - All Data Type

     See Setting the Import Format Data Types.

   • Multi Column - All Data Type

7. If the file type is "delimited," in the File Delimiter field, select a type of delimiter.

   Available delimiter symbols:

   • comma (,)

   • exclamation (!)

   • semicolon (;)

   • colon (:)

   • pipe (|)

   • tab

   • tilde (~)

8. In Target, select the target system.

9. In Drill URL, enter the URL used for the drill-through.

   To display the Drill URL editor, click .

10. In the Mapping section, map any dimensions.

11. Click Save.

    To define import formats for file-based mappings, see Defining Import Formats for File-Based Mappings.