1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Working with E-Business Suite General Ledger Applications
  4. Importing E-Business Suite General Ledger Dimensions

Importing E-Business Suite General Ledger Dimensions

Oracle Enterprise Data Management Cloud supports importing from flat files that contain data from the segments (which includes the value sets and hierarchies) from your Oracle E-Business Suite General Ledger application. You cannot import directly from E-Business Suite General Ledger applications.

Before you begin:

  • See Importing Dimensions for import options, considerations, and information on import modes.
  • The data file for import must be a ZIP file that contains two comma-delimited (CSV) files. (The import into Oracle Enterprise Data Management Cloud is not case-sensitive). The hierarchy file is optional.
    • GL_HIERARCHY_INTERFACE.CSV— contains the parent/child structure for the individual hierarchies.
    • GL_SEGVALUES_INTERFACE.CSV — contains all the nodes in the dimension, as well as the properties for them.

    These files contain header records. A way to get these files is to register an application and export it to get the zip file with the header records in place. You can then update that file and save the CSV files in the correct format. For more information see Import and Export File Format.

  • Value set codes and hierarchies in the import file that are not registered in the Oracle Enterprise Data Management Cloud application will not be processed during import (the records will be skipped).

To import a dimension:

  1. From Applications, scroll to your application, then click ellipsis button, and then select Import.
  2. In the left column, select the dimension that you want to import data into.

  3. In File Name, specify an import file name. The import file must be a ZIP file that contains the GL_HIERARCHY_INTERFACE.CSV and GL_SEGVALUES_INTERFACE.CSV files.

    Note:

    The hierarchy file is optional.

  4. In Import Mode, select Merge, Replace, or Reset. See Importing Dimensions for details on import modes.

  5. Optional: In the Summary section, click the dimension name to inspect the dimension and view the import options. Close the inspector dialog to return to the import screen.

  6. Click Import.

You can also import dimensions using EPM Automate (see importDimension in Working with EPM Automate for Oracle Enterprise Performance Management Cloud) or a REST API (see Importing Dimensions in REST API for Oracle Enterprise Data Management Cloud Service).