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