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: QP.QP_UPGRADE_ERRORS

Object Details

Object Name:	QP_UPGRADE_ERRORS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_UPGRADE_ERRORS
Subobject Name:
Status:	VALID

QP_UPGRADE_ERRORS holds details of the errors which occured in upgrading pricing data. The table holds details of the entity or entities, e.g. price list, which failed the upgrade and the reason the error occurred.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_UPGRADE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPG_SESSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ERROR_ID	NUMBER			Identifies the upgrade error. System generated identifier.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
UPG_SESSION_ID	NUMBER			Identifies the session in which the error occured
ID1	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID2	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID3	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID4	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID5	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID6	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID7	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ID8	VARCHAR2	(30)		The primary key of the entity which failed the upgrade, e.g. price list
ERROR_TYPE	VARCHAR2	(30)		Type of error which occured
ERROR_DESC	VARCHAR2	(240)		Standard Oracle error message
ERROR_MODULE	VARCHAR2	(30)		Upgrade package in which error occured

Query Text

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


SELECT ERROR_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      UPG_SESSION_ID
,      ID1
,      ID2
,      ID3
,      ID4
,      ID5
,      ID6
,      ID7
,      ID8
,      ERROR_TYPE
,      ERROR_DESC
,      ERROR_MODULE
FROM QP.QP_UPGRADE_ERRORS;

Dependencies

[top of page]

QP.QP_UPGRADE_ERRORS does not reference any database object

QP.QP_UPGRADE_ERRORS is referenced by following:

APPS: QP_UPGRADE_ERRORS