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: IBE.IBE_ECR_MVLOG

Object Details

Object Name:	IBE_ECR_MVLOG
Object Type:	TABLE
Owner:	IBE
FND Design Data:	IBE.IBE_ECR_MVLOG
Subobject Name:
Status:	VALID

This table capture the refresh log history of materialized views. This table will also capture the begin date and end date of the transaction records refreshed into materialized views.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBE_ECR_MVLOG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MVLOG_ID
IBE_ECR_MVLOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MVIEW_NAME REFRESH_STATUS REFRESH_MODE

Columns

Name	Datatype	Length	Mandatory	Comments
MVLOG_ID	NUMBER		Yes	Log transaction identifier.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number for locking
CREATED_BY	NUMBER		Yes	Standard WHO Column.
CREATION_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column.
SECURITY_GROUP_ID	NUMBER	(15)		Security Group Identifier.
REQUEST_ID	NUMBER			Concurrent WHO column.
PROGRAM_ID	NUMBER			Concurrent WHO column.
PROGRAM_APPLICATION_ID	NUMBER			Concurrent WHO column.
PROGRAM_UPDATE_DATE	DATE			Concurrent WHO column.
REFRESH_MODE	VARCHAR2	(30)		Refresh Mode
MVIEW_NAME	VARCHAR2	(240)	Yes	Fact Table name being refreshed.
REFRESH_STATUS	NUMBER		Yes	Indicate staus of the refresh.-1 : Error. 0 : In-Progress. 1: Active Successful. 2: Inactive Successful.
BEGIN_DATE	DATE		Yes	The start date of transaction data to be refreshed into Fact table.
END_DATE	DATE		Yes	The end date of transaction data to be refreshed into Fact table.
CURRENCY_CODE	VARCHAR2	(240)		Currencies in which Fact data is populated
CONVERSION_TYPE	VARCHAR2	(30)		Conversion Type ( Value of profile 'IBE: GL Conversion Type' at the time of refresh)
FACT_SOURCE	VARCHAR2	(2000)		Sources From which the Fact data is Collected.
ERROR_CODE	VARCHAR2	(80)		Error Code, incase of an error.
ERROR_MESSAGE	VARCHAR2	(2000)		Error Message, in case of an error.
REFRESH_DURATION	NUMBER			Time taken to refresh in Secs.
DAY_BIN_OFFSET	NUMBER			Offset For the bin DAY Definition
FORCE_REFRESH_FLAG	VARCHAR2	(3)		Force Refresh Flag
QUARTER_BEGIN_FLAG	VARCHAR2	(3)		Flag to get quarter begin date.
PERIOD_SET_NAME	VARCHAR2	(15)		GL Period Set Name

Query Text

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


SELECT MVLOG_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REFRESH_MODE
,      MVIEW_NAME
,      REFRESH_STATUS
,      BEGIN_DATE
,      END_DATE
,      CURRENCY_CODE
,      CONVERSION_TYPE
,      FACT_SOURCE
,      ERROR_CODE
,      ERROR_MESSAGE
,      REFRESH_DURATION
,      DAY_BIN_OFFSET
,      FORCE_REFRESH_FLAG
,      QUARTER_BEGIN_FLAG
,      PERIOD_SET_NAME
FROM IBE.IBE_ECR_MVLOG;

Dependencies

[top of page]

IBE.IBE_ECR_MVLOG does not reference any database object

IBE.IBE_ECR_MVLOG is referenced by following:

APPS: IBE_ECR_MVLOG