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_VALUE_SETS_T

Object Details

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

FEM_HIER_VALUE_SETS_T is an interface table that designates the value sets for Analytic dimension hierarchies that will be loaded using the Dimension Hierarchy Loader. You need to populate this table when creating new hierarchies of any dimension except for the Calendar Period
dimension. Only members of the designated value sets can 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 value set in the hierarchy. For single value set hierarchies (designated as MULTI_VALUE_SET_FLAG = 'N' in the FEM_HIERARCHIES_T table), you may only designate 1 value set. For multiple value set hierarchies (designated as
MULTI_VALUE_SET_FLAG = 'Y' in the FEM_HIERARCHIES_T table), you may designate as many value sets of the dimension as needed. You identify the value sets for the hierarchy in the VALUE_SET_DISPLAY_CODE column.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Dimension Hierarchy Value Set
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_VALUE_SETS_T_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	HIERARCHY_OBJECT_NAME VALUE_SET_DISPLAY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Object name of the hierarchy
VALUE_SET_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric code that identifies the Value Set
LANGUAGE	VARCHAR2	(4)	Yes	Identifies the language of the hierarchy object name
STATUS	VARCHAR2	(30)	Yes	Load status of the 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
,      VALUE_SET_DISPLAY_CODE
,      LANGUAGE
,      STATUS
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_HIER_VALUE_SETS_T;

Dependencies

[top of page]

FEM.FEM_HIER_VALUE_SETS_T does not reference any database object

FEM.FEM_HIER_VALUE_SETS_T is referenced by following:

APPS: FEM_HIER_VALUE_SETS_T