Segment Values and Hierarchies Interface Tables

The Import Segment Values and Hierarchies process loads segment values and hierarchies if you maintain chart of accounts reference data outside Oracle Fusion applications.

You can load the segment values and hierarchies by populating two tables: GL_SEGMENT_VALUES_INTERFACE and GL_SEGMENT_HIER_INTERFACE, and by running the Import Segment Values and Hierarchies process.

You can use the GL_SEGMENT_VALUES_INTERFACE table to load segment values and the GL_SEGMENT_HIER_INTERFACE table to load segment value hierarchies to Oracle Fusion applications. For more information about tables, see the Tables and Views for Oracle Financials Cloud guide.

Assigning Values for Columns in the GL_SEGMENT_VALUES_INTERFACE table

You must enter values in all columns of the interface table that require values for the Import Segment Values and Hierarchies process to be successful.

The following table describes the columns that require values.

Name	Value
STATUS_CODE	Enter the value NEW to indicate that you're bringing new segment value data.
VALUE_SET_CODE	Enter the value set code for the segment values.
VALUE	Enter the segment value.
SUMMARY_FLAG	Select N if the segment value is a child value or Y if the segment value is a parent value.
ENABLED_FLAG:	Select Y to enable the segment value. Enter N to disable the segment value.
ACCOUNT_TYPE:	Enter the natural account type if the segment value is for a natural account segment. A: Asset L: Liability E: Expense O: Owner's Equity R: Revenue
ALLOW_POSTING_FLAG	Select Y if posting is allowed for this segment value. Select N if posting isn't allowed.
OBJECT_VERSION_NUMBER	Enter default value of 1.

The following table describes the columns that are optional.

Name	Value
START_DATE_ACTIVE	Enter the start date of the segment value.
END_DATE_ACTIVE	Enter the end date of the segment value.
THIRD_PARTY_CTRL_ACCOUNT	Enter the third-party control account value. Valid values are: CUSTOMER, SUPPLIER, R for restrict manual journals, Y, and N.
FINANCIAL_CATEGORY	Enter a financial category value for Oracle Transactional Business Intelligence reporting. Valid values are values defined for the FINANCIAL_CATEGORY lookup type.
DESCRIPTION	Different description columns exist for different languages. To see segment value description in a different language installation, you populate the segment description for that language too.

The following columns should remain blank. The Import Segment Values and Hierarchies process uses them for internal processing, or doesn't currently use them.

CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
SEGMENT_VALUE_INTERFACE_ID
REQUEST_ID
LOAD_REQUEST_ID

Assigning Values for Columns in the GL_SEGMENT_HEIR_INTERFACE table

You must enter values in all columns of the interface table that require values for the Import Segment Values and Hierarchies process to be successful.

The following table describes the columns that require values.

Name	Value
STATUS_CODE	Enter the value NEW to indicate that you're loading new hierarchy data.
VALUE_SET_CODE	Enter the value set code for the segment values.
TREE_CODE	Enter the hierarchy name (tree code).
TREE_VERSION NAME	Enter the hierarchy version name (tree version name).
TREE_VERSION_START_DATE_ACTIVE	Enter the date that the tree version is activated.
TREE_VERSION_END_DATE_ACTIVE	Enter the date that the tree version is inactivated.
VALUE	Enter the segment value.
PARENT_VALUE	Select N if the segment value is a child value or Y if the segment value is a parent value.
DEPTH	Enter the depth of the hierarchy that shows the many ancestors the segment value has in the hierarchy.
OBJECT_VERSION_NUMBER	Enter default value of 1.

The following columns should remain blank. The Import Segment Values and Hierarchies process uses them for internal processing or doesn't currently use them.

CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
SEGMENT_VALUE_INTERFACE_ID
REQUEST_ID
LOAD_REQUEST_ID