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: CSI.CSI_TXN_ERRORS

Object Details

Object Name:	CSI_TXN_ERRORS
Object Type:	TABLE
Owner:	CSI
FND Design Data:	CSI.CSI_TXN_ERRORS
Subobject Name:
Status:	VALID

This table stores Installed Base transacton Errors.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSI_TXN_ERRORS_U01	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ERROR_ID
CSI_TXN_ERRORS_N01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
CSI_TXN_ERRORS_N02	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INV_MATERIAL_TRANSACTION_ID
CSI_TXN_ERRORS_N03	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TYPE
CSI_TXN_ERRORS_N04	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROCESSED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ERROR_ID	NUMBER		Yes	Transaction Error Identifier.
TRANSACTION_ID	NUMBER			Transaction Identifier.
MESSAGE_ID	NUMBER			Message Identifier.
ERROR_TEXT	VARCHAR2	(2000)		Error Text.
SOURCE_TYPE	VARCHAR2	(240)		Source Transaction Type.
SOURCE_ID	NUMBER			Source Identifier.
PROCESSED_FLAG	VARCHAR2	(1)		Flag indicating if the Error is re-processed.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
TRANSACTION_TYPE_ID	NUMBER			Transaction Type Identifier.
SOURCE_GROUP_REF	VARCHAR2	(50)		Source Group Reference of the Transaction.
SOURCE_GROUP_REF_ID	NUMBER			Source Group Reference Identifier of the Transaction.
SOURCE_HEADER_REF	VARCHAR2	(50)		Source Header Reference of the Transaction.
SOURCE_HEADER_REF_ID	NUMBER			Source Header Reference Identifier of the Transaction.
SOURCE_LINE_REF	VARCHAR2	(50)		Source Line Reference of the Transaction.
SOURCE_LINE_REF_ID	NUMBER			Source Line Reference Identifier of the Transaction.
SOURCE_DIST_REF_ID1	NUMBER			Source Distribution Reference of the Transaction.
SOURCE_DIST_REF_ID2	NUMBER			Source Distribution Reference Identifier of the Transaction.
INV_MATERIAL_TRANSACTION_ID	NUMBER			Material Transaction Identifier.
ERROR_STAGE	VARCHAR2	(30)		Error Stage - Indicating which point in the Processing the error occured.
MESSAGE_STRING	VARCHAR2	(4000)		Message String of the actual Message.
TRANSACTION_ERROR_DATE	DATE			Transaction error date
SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the item in the transaction on which the error occured, if item is serialized.
LOT_NUMBER	VARCHAR2	(80)		Lot number of the item in the transaction on which the error occured, if item is serialized.
INSTANCE_ID	NUMBER			Item instance id for which the error occurred.
INVENTORY_ITEM_ID	NUMBER			Inventory item id of the item instance that errored.
SRC_SERIAL_NUM_CTRL_CODE	NUMBER			Serial number control code for the item in the 'from' organization at the time the transaction errored.
DST_SERIAL_NUM_CTRL_CODE	NUMBER			Serial number control code for the item in the 'to' organization at the time the transaction errored.
SRC_LOT_CTRL_CODE	NUMBER			Lot number control code at the time the transaction errored.
DST_LOT_CTRL_CODE	NUMBER			Lot number control code at the time the transaction errored.
SRC_LOCATION_CTRL_CODE	NUMBER			Locator control code of the item when the error occured.
DST_LOCATION_CTRL_CODE	NUMBER			Locator control code of the item when the error occured.
SRC_REV_QTY_CTRL_CODE	NUMBER			Revision control code of the item when the error occured.
DST_REV_QTY_CTRL_CODE	NUMBER			Revision control code of the item when the error occured.
COMMS_NL_TRACKABLE_FLAG	VARCHAR2	(1)		Item Instance trackable flag value for the item when the error occured.

Query Text

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


SELECT TRANSACTION_ERROR_ID
,      TRANSACTION_ID
,      MESSAGE_ID
,      ERROR_TEXT
,      SOURCE_TYPE
,      SOURCE_ID
,      PROCESSED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      TRANSACTION_TYPE_ID
,      SOURCE_GROUP_REF
,      SOURCE_GROUP_REF_ID
,      SOURCE_HEADER_REF
,      SOURCE_HEADER_REF_ID
,      SOURCE_LINE_REF
,      SOURCE_LINE_REF_ID
,      SOURCE_DIST_REF_ID1
,      SOURCE_DIST_REF_ID2
,      INV_MATERIAL_TRANSACTION_ID
,      ERROR_STAGE
,      MESSAGE_STRING
,      TRANSACTION_ERROR_DATE
,      SERIAL_NUMBER
,      LOT_NUMBER
,      INSTANCE_ID
,      INVENTORY_ITEM_ID
,      SRC_SERIAL_NUM_CTRL_CODE
,      DST_SERIAL_NUM_CTRL_CODE
,      SRC_LOT_CTRL_CODE
,      DST_LOT_CTRL_CODE
,      SRC_LOCATION_CTRL_CODE
,      DST_LOCATION_CTRL_CODE
,      SRC_REV_QTY_CTRL_CODE
,      DST_REV_QTY_CTRL_CODE
,      COMMS_NL_TRACKABLE_FLAG
FROM CSI.CSI_TXN_ERRORS;

Dependencies

[top of page]

CSI.CSI_TXN_ERRORS does not reference any database object

CSI.CSI_TXN_ERRORS is referenced by following:

CSI: CSI_TXN_ERRORS#