Adding Import Formats

Two types of import formats can be added based on the source system type:

When adding formats, note that specific import format detail fields are available or unavailable based on the source system type.

  To add an import for an accounting entity:

  1. In the Tasks pane, under Setup, select Import Format.

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

    Complete the following steps in the Import Format Details section.

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

    The value in this field cannot be modified once a mapping has been created for this import format.

  4. In the Source System, select an accounting entity source system type.

  5. In the Accounting Entity drop-down, select the accounting entity.

    For Fusion and E-Business Suite source systems, the Accounting Entity is the ledger. For PeopleSoft source systems, the Accounting Entity is the business unit.

  6. In the Target Application drop-down, select the target application.

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

  8. Define the import mappings from the source system. See Defining the Data Load Mappings.

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

  9. Define the import mappings from the EPM application. See Defining the Write-Back Mappings (EBS and PeopleSoft only).

  To add an import format for a source adapter:

  1. In the Tasks pane, under Setup, select Import Format.

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

    Complete the following steps in the Import Format Details section.

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

    The value in this field cannot be modified once mapping has been created for this import format.

  4. In Source System, select the source adapter.

  5. In Source Adapter, select the source adapter name.

    Any time you add or modify import format based on Source Adapter, you must select “Regenerate ODI Scenario”. See Regenerating the ODI Scenario (Source Adapters only).

    When you specify an import format with a source system, you can map source columns defined in the source adapter to the target dimensions. After defining the mapping, you need to initiate the ODI Scenario Generation process. This process generates a new ODI scenario based on the source adapter import format.

    You can either specify a source accounting entity or source adapter, but not both.

  6. In the Target Application drop-down, select the target application.

  7. In Drill URL, enter the URL which identifies the URL to use for drilling through when using this import format.

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

  9. Define the import mappings from the source system. See Defining the Data Load Mappings.

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

  10. Define the import mappings from the EPM application. See Defining the Write-Back Mappings (EBS and PeopleSoft only).