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_USER_DIM2_HIER_T

Object Details

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

FEM_USER_DIM2_HIER_T is an interface table for loading and updating Analytic User Dimension hierarchies using the Dimension Hierarchy Loader. This table stores the individual relationship
records for each parent and child combination in the hierarchy.
The HIERARCHY_OBJECT_NAME, HIERARCHY_OBJ_DEF_DISPLAY_NAME and LANGUAGE columns
identify the hierarchy version for loading. For each hierarchy version that you wish to load, populate the Parent and Child columns to designate the appropriate parent and child relationship records.
In addition, in order to load a hierarchy, you need to populate the interface tables that provide header information for the hierarchy. The header tables that you need to populate are based upon the type of hierarchy that is being loaded. The hierarchy header tables are: FEM_HIERARCHIES_T, FEM_HIER_DIM_GRPS_T, and FEM_HIER_VALUE_SETS_T.
Each distinct member is always identified by the non translatable alphanumeric identifier for the User Dimension. The PARENT_DISPLAY_CODE and CHILD_DISPLAY_CODE columns in the interface table stores this identifier.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic User Dimension2 Hierarchy Detail
Category: BUSINESS_ENTITY FEM_XDIM_HIERARCHY

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_USER_DIM2_HIER_T_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	HIERARCHY_OBJECT_NAME HIERARCHY_OBJ_DEF_DISPLAY_NAME PARENT_DISPLAY_CODE PARENT_VALUE_SET_DISPLAY_CODE CHILD_DISPLAY_CODE CHILD_VALUE_SET_DISPLAY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Object name of the hierarchy
HIERARCHY_OBJ_DEF_DISPLAY_NAME	VARCHAR2	(150)	Yes	Display name of the object definition of the hierarchy
PARENT_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the parent dimension member
PARENT_VALUE_SET_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the value set of the parent dimension member
CHILD_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the child dimension member
CHILD_VALUE_SET_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the value set of the child dimension member
DISPLAY_ORDER_NUM	NUMBER		Yes	Sequence number that designates the order in which hierarchy relationships are displayed on the screen
WEIGHTING_PCT	NUMBER	(3)		Weighting Percentage designating the relative weight assigned to the child from the parent
STATUS	VARCHAR2	(30)	Yes	Load status of the record
LANGUAGE	VARCHAR2	(4)	Yes	Designates the language of the Hierarchy Object and Hierarchy Object Definition for the relationship record
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
,      HIERARCHY_OBJ_DEF_DISPLAY_NAME
,      PARENT_DISPLAY_CODE
,      PARENT_VALUE_SET_DISPLAY_CODE
,      CHILD_DISPLAY_CODE
,      CHILD_VALUE_SET_DISPLAY_CODE
,      DISPLAY_ORDER_NUM
,      WEIGHTING_PCT
,      STATUS
,      LANGUAGE
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_USER_DIM2_HIER_T;

Dependencies

[top of page]

FEM.FEM_USER_DIM2_HIER_T does not reference any database object

FEM.FEM_USER_DIM2_HIER_T is referenced by following:

APPS: FEM_USER_DIM2_HIER_T