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

Importing Oracle Financials Cloud 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 trees) from your Oracle Financials Cloud General Ledger application. You cannot import directly from Oracle Financials Cloud 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).
    • GlSegmentValuesInterface.csv— contains all the nodes in the dimension, as well as the properties for them and any global or context-sensitive descriptive flexfields that were added to the segment.
    • GlSegmentHierInterface.csv — contains the parent/child structure for the individual trees (tree code /tree version name combinations) as well as tree labels.

    There are two methods for creating the import ZIP file:

    • To export General Ledger segment values and hierarchies from an existing Oracle Financials Cloud General Ledger application, follow the instructions in this article: Exporting Fusion General Ledger segment (value set) values and hierarchies data in the FBDI format (Doc ID 2889994.1).
    • To manually generate the ZIP files: see Import Segment Values and Hierarchies in File-Based Data Import for Oracle Financials Cloud for the file formats. You can download the ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm template from this link, which enables you to enter the segment values and hierarchies that you want to import and then generate the CSV files in the correct format.

      Tip:

      The ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm template formats dates as YYYY/MM/DD. This format may differ from the date formats used by other application types. For example, Universal applications date formats default to the regional settings for the user running the import.

  • Value set codes, tree codes, and tree versions 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).
  • When importing using the Replace or Merge modes, only the hierarchy sets that are used by trees that are included in the import hierarchy file are cleared before running the import. Trees not in the hierarchy file are not affected.

    Note:

    When importing using the Reset mode, all trees are cleared as part of the import and only the trees in the import file are created.
  • When you import with global or context-sensitive descriptive flexfields, warnings are displayed for the following:
    • The import file contains values in the columns designated for global or context-sensitive descriptive flexfields but the application registration does not.
    • The application registration contains either global or context-sensitive descriptive flexfields but the import file does not contain values in the columns designated for global or context-sensitive descriptive flexfields.

    If the import file contains the columns designated for global or context-sensitive descriptive flexfields (that is, the requisite number of commas in the comma-delimited file) but there are no values in those fields, the import process does not display a warning.

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 GlSegmentValuesInterface.csv and GlSegmentHierInterface.csv files.

  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).