eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FEM.FEM_HIERARCHIES_T

Object Details

Object Name:	FEM_HIERARCHIES_T
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

FEM_HIERARCHIES_T is an interface table for loading and updating Analytic dimension hierarchies using the Dimension Hierarchy Loader. This table identifies the hierarchies to be loaded and
provides the properties for each hierarchy. You identify the hierarchy and specific version using translatable names in HIERARCHY_OBJECT_NAME and HIER_OBJ_DEF_DISPLAY_NAME columns
respectively, with the LANGUAGE column designating the language of the translatable name for both. The interface table does not support loading names in multiple languages for the same hierarchy version.
You may only populate 1 row per hierarchy version in the FEM_HIERARCHIES_T table. You can update the translatable name for the hierarchy or hierarchy version in other installed languages using the Dimension and Hierarchy Management application.
The FOLDER_NAME column (together with LANGUAGE) designates the target folder for the hierarchy. The 2 effective date columns (EFFECTIVE_START_DATE and EFFECTIVE_END_DATE) designate the period of time for which the hierarchy version is valid. The loader will provide defaults for the hierarchy version if you do not populate either of the 2 effective date columns.
The DIMENSION_VARCHAR_LABEL identifies the dimension for which the hierarchy applies. The other columns in the table (HIERARCHY_TYPE_CODE, HIERARCHY_USAGE_CODE, GROUP_SEQUENCE_ENFORCED_CODE, MULTI_TOP_FLAG, and MULTI_VALUE_SET_FLAG) describe the kind of parent child relationship records permitted for the hierarchy.
Only populate the CALENDAR_DISPLAY_CODE column for hierarchies of the Calendar Period dimension. It has no meaning when populated for hierarchies of other dimensions.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Dimension Hierarchy
Category: BUSINESS_ENTITY FEM_XDIM_HIERARCHY

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_HIERARCHIES_T_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	HIERARCHY_OBJECT_NAME HIER_OBJ_DEF_DISPLAY_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Object name of the hierarchy
FOLDER_NAME	VARCHAR2	(150)	Yes	Name of the folder for the hierarchy
LANGUAGE	VARCHAR2	(4)	Yes	Identifies the language of the hierarchy object name
DIMENSION_VARCHAR_LABEL	VARCHAR2	(30)	Yes	Alphanumeric mnemonic identifying the dimension
HIERARCHY_TYPE_CODE	VARCHAR2	(30)	Yes	Designates the rules for parent/child relationships in a hierarchy
GROUP_SEQUENCE_ENFORCED_CODE	VARCHAR2	(30)	Yes	Designates whether or not parent/child relationships in a hierarchy are governed by Dimension Group sequences
MULTI_TOP_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the hierarchy has multiple top nodes
MULTI_VALUE_SET_FLAG	VARCHAR2	(1)	Yes	Designates whether or not the hierarchy is composed of dimension members from multiple value sets
HIERARCHY_USAGE_CODE	VARCHAR2	(30)	Yes	Designates the purpose for the hierarchy
FLATTENED_ROWS_FLAG	VARCHAR2	(1)	Yes	Designates whether or not flattened rows will be created for all definitions of the hierarchy
STATUS	VARCHAR2	(30)	Yes	Load status of the record
HIER_OBJ_DEF_DISPLAY_NAME	VARCHAR2	(150)	Yes	Object definition display name for the hierarchy
EFFECTIVE_START_DATE	DATE			Effective Start Date for the Hierarchy object definition
EFFECTIVE_END_DATE	DATE			Effective End Date for the Hierarchy object definition
CALENDAR_DISPLAY_CODE	VARCHAR2	(150)		Designates the Calendar for hierarchies of the Calendar Period dimension
CREATED_BY_DIM_MIGRATION_FLAG	VARCHAR2	(1)		Oracle applications uses this column to identify data created by internal processes. Do not populate this column for user created rows - leave as null.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HIERARCHY_OBJECT_NAME
,      FOLDER_NAME
,      LANGUAGE
,      DIMENSION_VARCHAR_LABEL
,      HIERARCHY_TYPE_CODE
,      GROUP_SEQUENCE_ENFORCED_CODE
,      MULTI_TOP_FLAG
,      MULTI_VALUE_SET_FLAG
,      HIERARCHY_USAGE_CODE
,      FLATTENED_ROWS_FLAG
,      STATUS
,      HIER_OBJ_DEF_DISPLAY_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CALENDAR_DISPLAY_CODE
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_HIERARCHIES_T;

Dependencies

[top of page]

FEM.FEM_HIERARCHIES_T does not reference any database object

FEM.FEM_HIERARCHIES_T is referenced by following:

APPS: FEM_HIERARCHIES_T