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: FII.FII_FINANCIAL_DIMENSIONS

Object Details

Object Name:	FII_FINANCIAL_DIMENSIONS
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_FINANCIAL_DIMENSIONS
Subobject Name:
Status:	VALID

Contains Financials Intelligence specific information for Financial dimensions. Each record corresponds to a financial dimension with some system-level settings information.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_FINANCIAL_DIMENSIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	DIMENSION_SHORT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_SHORT_NAME	VARCHAR2	(30)	Yes	Financial Dimension identifier
SYSTEM_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the dimension is enabled at the system level
DBI_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the dimension is enabled for Daily Business Intelligence
INCL_MASTER_VS_LEAF_NODES_FLAG	VARCHAR2	(1)	Yes	Flag indicating if leaf level nodes from the master value set will be included in the hierarchy
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
MASTER_VALUE_SET_ID	NUMBER	(15)		Flexfield value set identifier
DBI_HIER_TOP_NODE	VARCHAR2	(150)		Hierarchy top node for Daily Business Intelligence
DBI_HIER_TOP_NODE_ID	NUMBER	(15)		Flexfield segment value identifier for the hierarchy top node
BALANCING_OR_COST_CENTER	VARCHAR2	(30)		Column that stores whether a dimension is mapped to balancing or cost center segment.

Query Text

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


SELECT DIMENSION_SHORT_NAME
,      SYSTEM_ENABLED_FLAG
,      DBI_ENABLED_FLAG
,      INCL_MASTER_VS_LEAF_NODES_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MASTER_VALUE_SET_ID
,      DBI_HIER_TOP_NODE
,      DBI_HIER_TOP_NODE_ID
,      BALANCING_OR_COST_CENTER
FROM FII.FII_FINANCIAL_DIMENSIONS;

Dependencies

[top of page]

FII.FII_FINANCIAL_DIMENSIONS does not reference any database object

FII.FII_FINANCIAL_DIMENSIONS is referenced by following:

APPS: FII_FINANCIAL_DIMENSIONS