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_HIER_DIM_GRPS_T

Object Details

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

FEM_HIER_DIM_GRPS_T is an interface table that provides level information for Analytic dimension hierarchies loaded using the Dimension Hierarchy Loader. You only need to populate this table when creating new hierarchies that use Levels. In such hierarchies, only members of the designated levels are allowed to participate in the hierarchy.
You identify the hierarchy being loaded using the HIERARCHY_OBJECT_NAME and LANGUAGE columns (refer to the information in the FEM_HIERARCHIES_T table for more details on how to identify a hierarchy). Populate the table with a row for each level (identified by the DIMENSION_GROUP_DISPLAY_CODE) for the hierarchy that you are loading.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Dimension Hierarchy Level
Category: BUSINESS_ENTITY FEM_XDIM_HIERARCHY

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_HIER_DIM_GRPS_T_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	DIMENSION_GROUP_DISPLAY_CODE HIERARCHY_OBJECT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Object name of the hierarchy
LANGUAGE	VARCHAR2	(4)	Yes	Identifies the language of the translatable name or description
STATUS	VARCHAR2	(30)	Yes	Load status of the record
DIMENSION_GROUP_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the level
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
,      LANGUAGE
,      STATUS
,      DIMENSION_GROUP_DISPLAY_CODE
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_HIER_DIM_GRPS_T;

Dependencies

[top of page]

FEM.FEM_HIER_DIM_GRPS_T does not reference any database object

FEM.FEM_HIER_DIM_GRPS_T is referenced by following:

APPS: FEM_HIER_DIM_GRPS_T