How Segment Value and Hierarchy Import Data Is Processed

Use the Import Segment Values and Hierarchies file-based data import (FBDI) to upload segment values and hierarchies from external sources into Oracle General Ledger. You can download a spreadsheet template to use to prepare your segment values and hierarchies data.

The template contains an instruction sheet to help guide you through the process of entering your segment values and hierarchy information.

To access the template, complete the following steps:

Navigate to the File-Based Data Import for Oracle Financials Cloud guide.
In the General Ledger chapter, click Import Segment Values and Hierarchies.
In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.
Don't change the order of the columns in the template.
You can hide or skip the columns you don't use, but don't delete them.
Don't change the format or data type of the columns, otherwise parsing errors could occur.

Settings That Affect the Segment Values and Hierarchies Import Process

The Segment Values and Hierarchies template contains an instructions tab, plus two tabs that represent the tables where the data is loaded.

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains instruction information about preparing and verifying the segment values and hierarchies data, understanding the format of the template, and loading and importing the data.
GL_SEGMENT_VALUES_INTERFACE	Enter information about the segment values that you're adding, such as the value sets, values, effective start and end dates, and whether to allow posting. You can import segment values for multiple value sets in a single worksheet. Note: To clear the values of descriptive flexfield attributes in the application when updating segment values, you can do either of the following: Specify $null$ in the applicable descriptive flexfield Attribute 1 through 50 columns. Specify EDMCS in the Data Source column and leave the applicable descriptive flexfield Attribute1 through 50 columns blank. This eases management of segment value descriptive flexfield attributes from Oracle Enterprise Data Management Cloud (EDMCS). Data Source isn't a required column for creating or updating segment values.
GL_SEGMENT_HIER_INTERFACE	Enter information about the segment value hierarchies that you're adding, such as the tree version name, and parent and child values. You can import hierarchies for multiple value sets and tree versions in a single worksheet. If you opt in to the Range-Based Hierarchy Creation Using File-Based Data Import feature, you can define range tree nodes in the FBDI template. Typically, a range node type is used to represent a range of many detailed values. Use the format RANGE[<From Value>]-[<To value>] in any of the Parent or Value columns of this tab. The From and To Values are used to identify the lower limit and upper limit of the range, respectively. Note: By default, only 10 parent levels are shown, but you can add up to 30 levels by clicking the plus icon in the first row for the Parent 10 column.

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains instruction information about preparing and verifying the segment values and hierarchies data, understanding the format of the template, and loading and importing the data.

GL_SEGMENT_VALUES_INTERFACE

Enter information about the segment values that you're adding, such as the value sets, values, effective start and end dates, and whether to allow posting. You can import segment values for multiple value sets in a single worksheet.

Note: To clear the values of descriptive flexfield attributes in the application when updating segment values, you can do either of the following:

Specify $null$ in the applicable descriptive flexfield Attribute 1 through 50 columns.
Specify EDMCS in the Data Source column and leave the applicable descriptive flexfield Attribute1 through 50 columns blank. This eases management of segment value descriptive flexfield attributes from Oracle Enterprise Data Management Cloud (EDMCS). Data Source isn't a required column for creating or updating segment values.

GL_SEGMENT_HIER_INTERFACE

Enter information about the segment value hierarchies that you're adding, such as the tree version name, and parent and child values. You can import hierarchies for multiple value sets and tree versions in a single worksheet.

If you opt in to the Range-Based Hierarchy Creation Using File-Based Data Import feature, you can define range tree nodes in the FBDI template. Typically, a range node type is used to represent a range of many detailed values. Use the format RANGE[<From Value>]-[<To value>] in any of the Parent or Value columns of this tab. The From and To Values are used to identify the lower limit and upper limit of the range, respectively.

Note: By default, only 10 parent levels are shown, but you can add up to 30 levels by clicking the plus icon in the first row for the Parent 10 column.

After you add the data, you can validate the information and check for errors by clicking the Validate Segment Values and Validate Segment Hierarchy buttons.

How Segment Values and Hierarchies Import Data Is Processed

To load the data into the interface tables and into the product:

Click the Generate CSV button on the instructions tab to create a CSV file in a .zip file format.
Save the .zip file locally.
Navigate to the Scheduled Processes work area.
Select the Load Interface File for Import process.
For the Import Process parameter, select Import Segment Values and Hierarchies.
For the Data File parameter, select the file that you saved in step 2.
If the process ends in error or warning:
1. Review the log and output files for details about the rows that caused the failure.
2. Correct the errors in the spreadsheet.
3. Repeat steps 1 through 6 until errors are resolved.

The Load Interface File for Import process loads the data from the file to the interfaces table and submits the Import Segment Values and Hierarchies process. This process imports the segment values and hierarchy information from the interface tables into General Ledger.

Note: The import process sorts the account values that roll up to each parent node in a hierarchy in alphanumeric order. Because of this sorting, the sequence of account values in the application could be different from the sequence in the submitted file.