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: OKC.OKC_REP_IMP_ERRORS_T

Object Details

Object Name:	OKC_REP_IMP_ERRORS_T
Object Type:	TABLE
Owner:	OKC
Subobject Name:
Status:	VALID

OKC_REP_IMP_ERRORS_T is a temporary table that stores the error messages generated during the validation of the Import data. It is used to generate the output CSV file with the invalid records and the relevant error messages. The data is deleted after each Import process.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_REP_IMP_ERROR_T_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	IMP_ERROR_ID
OKC_REP_IMP_ERRORS_T_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IMP_ERROR_ID	NUMBER		Yes	Unique Import Error ID from OKC_REP_IMP_ ERRORS_T_S.
IMP_CONTRACT_ID	VARCHAR2	(240)		Import Contract Id for this Contract Document. FK to OKC_REP_IMP_CONTRACTS_T.imp_contract_id.
ERROR_OBJECT_TYPE	VARCHAR2	(30)		Indicates the source of the errored record: CONTRACT, PARTY, DOCUMENT.
ERROR_OBJECT_ID	NUMBER			Unique ID of the errored record. This value is equal to OKC_REP_IMP_PARTIES_T.imp_party_id, OKC_REP_IMP_DOCUMENTS_T.imp_document_id, or OKC_REP_IMP_CONTRACTS_T.imp_contract_id, depending on the ERROR_OBJECT_TYPE.
ERROR_MESSAGE	VARCHAR2	(2000)		Error message.
CREATION_DATE	DATE			Standard WHO Column
PROGRAM_ID	NUMBER	(15)		Standard WHO Column.
PROGRAM_LOGIN_ID	NUMBER	(15)		Standard WHO Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		fnd_global.prog_appl_id
REQUEST_ID	NUMBER	(15)		Identifies the concurrent request instance that spawned the concurrent program from FND_GLOBAL.conc_request_id.

Query Text

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


SELECT IMP_ERROR_ID
,      IMP_CONTRACT_ID
,      ERROR_OBJECT_TYPE
,      ERROR_OBJECT_ID
,      ERROR_MESSAGE
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OKC.OKC_REP_IMP_ERRORS_T;

Dependencies

[top of page]

OKC.OKC_REP_IMP_ERRORS_T does not reference any database object

OKC.OKC_REP_IMP_ERRORS_T is referenced by following:

APPS: OKC_REP_IMP_ERRORS_T