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: BIV.BIV_DBI_COLLECTION_LOG

Object Details

Object Name:	BIV_DBI_COLLECTION_LOG
Object Type:	TABLE
Owner:	BIV
Subobject Name:
Status:	VALID

The control table is used by both initial and incremental load processes. The table has one row for each load. If the previous load was not successful the load process will continue that load using the existing row.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIV_DBI_COLLECTION_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_COLLECTION_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_COLLECTION_FLAG	VARCHAR2	(1)	Yes	Y/N - This flag indicates whether this is the most recent collection. Only one row will ever have the value of "Y". Using this column allows load processes to easily identify the last/current collection row.
PROCESS_TYPE	VARCHAR2	(30)	Yes	INITIAL_LOAD or INCREMENTAL_LOAD. This indicates the load type.
COLLECT_FROM_DATE	DATE		Yes	The date to start collection of data from.
COLLECT_TO_DATE	DATE		Yes	The date to end collection of data to.
SUCCESS_FLAG	VARCHAR2	(1)	Yes	Y/N - This flag indicates the overall status of the collection. It can only be set to "Y" if each step has been completed successfully.
STAGING_TABLE_FLAG	VARCHAR2	(1)	Yes	Y/N - only the incremental load process uses this flag as it is the only process to use a staging table. It is set to "Y" when the load of the staging table has been completed successfully.
STAGING_TABLE_COUNT	NUMBER			This is the count of rows inserted into the staging table.
STAGING_TABLE_TIME	NUMBER			This is the elapsed time (100ths of seconds) taken to load the staging table
STAGING_ERROR_MESSAGE	VARCHAR2	(2000)		If the load of the staging table errored, the error message is set. This column may be useful for support/development to check errors.
ACTIVITY_FLAG	VARCHAR2	(1)	Yes	Y/N - This flag indiciates of the load of the Activity base summary has been completed successfully.
ACTIVITY_COUNT	NUMBER			This is the count of the rows inserted or updated in the Activity base summary by this collection.
ACTIVITY_TIME	NUMBER			This is the elapsed time (100ths of seconds) taken to populate the Activity base summary.
ACTIVITY_ERROR_MESSAGE	VARCHAR2	(2000)		If the load of the Actvity base summary errored, the error message is set. This column may be useful for support/development to check errors.
CLOSED_FLAG	VARCHAR2	(1)	Yes	Y/N - This flag indiciates of the load of the Closed base summary has been completed successfully.
CLOSED_COUNT	NUMBER			This is the count of the rows inserted or updated in the Closed base summary by this collection.
CLOSED_TIME	NUMBER			This is the elapsed time (100ths of seconds) taken to populate the Closed base summary.
CLOSED_ERROR_MESSAGE	VARCHAR2	(2000)		If the load of the Closed base summary errored, the error message is set. This column may be useful for support/development to check errors.
BACKLOG_FLAG	VARCHAR2	(1)	Yes	Y/N - This flag indiciates of the load of the Backlog base summary has been completed successfully.
BACKLOG_COUNT	NUMBER			This is the count of the rows inserted or updated in the Backlog base summary by this collection.
BACKLOG_TIME	NUMBER			This is the elapsed time (100ths of seconds) take to populate the Backlog base summary.
BACKLOG_ERROR_MESSAGE	VARCHAR2	(2000)		If the load of the Backlog base summary errored, the error message is set. This column may be useful for support/development to check errors.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
RESOLUTION_FLAG	VARCHAR2	(1)		Resolution status
RESOLUTION_COUNT	NUMBER			Number of lines processed
RESOLUTION_TIME	NUMBER			Time taken to process
RESOLUTION_ERROR_MESSAGE	VARCHAR2	(2000)		Resolution Error message

Query Text

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


SELECT LAST_COLLECTION_FLAG
,      PROCESS_TYPE
,      COLLECT_FROM_DATE
,      COLLECT_TO_DATE
,      SUCCESS_FLAG
,      STAGING_TABLE_FLAG
,      STAGING_TABLE_COUNT
,      STAGING_TABLE_TIME
,      STAGING_ERROR_MESSAGE
,      ACTIVITY_FLAG
,      ACTIVITY_COUNT
,      ACTIVITY_TIME
,      ACTIVITY_ERROR_MESSAGE
,      CLOSED_FLAG
,      CLOSED_COUNT
,      CLOSED_TIME
,      CLOSED_ERROR_MESSAGE
,      BACKLOG_FLAG
,      BACKLOG_COUNT
,      BACKLOG_TIME
,      BACKLOG_ERROR_MESSAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RESOLUTION_FLAG
,      RESOLUTION_COUNT
,      RESOLUTION_TIME
,      RESOLUTION_ERROR_MESSAGE
FROM BIV.BIV_DBI_COLLECTION_LOG;

Dependencies

[top of page]

BIV.BIV_DBI_COLLECTION_LOG does not reference any database object

BIV.BIV_DBI_COLLECTION_LOG is referenced by following:

APPS: BIV_DBI_COLLECTION_LOG