1. Tables and Views for Financials
  2. GL_SEGMENT_HIER_INTERFACE

GL_SEGMENT_HIER_INTERFACE

This interface table is used to import segment hierarchies into Fusion.

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
REQUEST_ID NUMBER 18 Oracle Enterprise Scheduler: request identifier of the job that created or last updated the row.
STATUS_CODE VARCHAR2 30 Segment value status code. Valid value: NEW. Automatically updated by import job as needed, using values from lookup type GL_SEG_VALUE_ERROR_CODES.
VALUE_SET_CODE VARCHAR2 60 Yes Value set code. Use the Manage Chart of Accounts Value Sets task to find valid values. Foreign key to fnd_vs_value_sets table.
TREE_CODE VARCHAR2 30 Yes Tree name. Use the Manage Account Hierarchies task to find valid values. Foreign key to FND_TREE.
TREE_VERSION_NAME VARCHAR2 80 Yes Tree version name. Use the Manage Account Hierarchies task to find valid values. Foreign key to FND_TREE_VERSION.
VALUE VARCHAR2 100 Yes Segment value in the hierarchy. Validation: must be an existing value for the value set.
PARENT_VALUE VARCHAR2 100 Parent value in the hierarchy. Validation: must be an existing parent value for the value set.
DEPTH NUMBER 18 Number of ancestors a value has in the hierarchy. Must be a positive integer.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is increased every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
TREE_VERSION_START_DATE_ACTIVE DATE Date from when tree version is active. Date format: YYYY/MM/DD.
TREE_VERSION_END_DATE_ACTIVE DATE Date until tree version is valid. Date format: YYYY/MM/DD.
LOAD_REQUEST_ID NUMBER 18 Oracle Enterprise Scheduler: request identifier of the job that created the row.
SORT_ORDER NUMBER 18 Custom sort order of hierarchy node.
LABEL_SHORT_NAME VARCHAR2 50 Short label for tree version node.
DATA_SOURCE VARCHAR2 512 External data source from where the record originates.

Indexes

Index Uniqueness Tablespace Columns
GL_SEGMENT_HIER_INTERFACE_N1 Non Unique FUSION_TS_TX_DATA VALUE_SET_CODE, REQUEST_ID, TREE_CODE, TREE_VERSION_NAME
GL_SEGMENT_HIER_INTERFACE_N2 Non Unique FUSION_TS_TX_DATA VALUE, PARENT_VALUE, LOAD_REQUEST_ID