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: JTF.JTF_IH_BULK_ERRORS

Object Details

Object Name:	JTF_IH_BULK_ERRORS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_IH_BULK_ERRORS
Subobject Name:
Status:	VALID

JTF_IH_BUILK_ERRORS table required to hold data about the errors encountered while attemting to create Interaction records from builk requests.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000328613C00007$$	LOB	UNIQUE	APPS_TS_TX_DATA
JTF_IH_BUILK_ERRORS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BULK_BATCH_ID
JTF_IH_BUILK_ERRORS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BULK_INTERACTION_ID
JTF_IH_BULK_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BULK_WRITER_CODE
JTF_IH_BULK_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BULK_BATCH_TYPE
JTF_IH_BULK_ERRORS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BULK_ERROR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BULK_ERROR_ID	NUMBER		Yes	Unique Builk Identifier
BULK_WRITER_CODE	VARCHAR2	(240)	Yes	Builk Writer Code
BULK_BATCH_ID	NUMBER		Yes	Builk Batch Identifier
BULK_BATCH_TYPE	VARCHAR2	(240)		Subtype used by the calling Writer to categorize types of Interaction request
BULK_INTERACTION_ID	NUMBER		Yes	Interaction identifier
ERROR_MESSAGE	VARCHAR2	(2000)	Yes	Error Message text
INTER_REQ_XML_DOC	CLOB	(4000)	Yes	Interaction Request XML document
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
CREATION_DATE	DATE		Yes	Creation Date required field
CREATED_BY	NUMBER	(15)	Yes	Creation By required field
LAST_UPDATE_DATE	DATE		Yes	Last Update Date required field
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who updated required field
LAST_UPDATE_LOGIN	NUMBER	(15)		Who updated required field
PROGRAM_ID	NUMBER	(15)		Program Identifier
REQUEST_ID	NUMBER	(15)		Request Identifier
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application Identifier
PROGRAM_UPDATE_DATE	DATE			Program Update Date

Query Text

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


SELECT BULK_ERROR_ID
,      BULK_WRITER_CODE
,      BULK_BATCH_ID
,      BULK_BATCH_TYPE
,      BULK_INTERACTION_ID
,      ERROR_MESSAGE
,      INTER_REQ_XML_DOC
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM JTF.JTF_IH_BULK_ERRORS;

Dependencies

[top of page]

JTF.JTF_IH_BULK_ERRORS does not reference any database object

JTF.JTF_IH_BULK_ERRORS is referenced by following:

JTF: JTF_IH_BULK_ERRORS#