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: RRS.RRS_INTERFACE_ERRORS

Object Details

Object Name:	RRS_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	RRS
FND Design Data:	RRS.RRS_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

This table stores all the errors found during the validation of rows during Site Import Interface process. User should never update the data in this table. This table should be used only as a reference to identify the errors.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS INTERFACE ERRORS
Category: OPEN_INTERFACE RRS_INTERFACE_ERRORS 1
Category: BUSINESS_ENTITY RRS_SITE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SITE_ID	NUMBER		Internal identifier of the Site for which error occured.
SITE_IDENTIFICATION_NUMBER	VARCHAR2	(30)	Site Identification Number of the Site for which error occurred.
COLUMN_NAME	VARCHAR2	(30)	Name of the column on which validation failed.
MESSAGE_NAME	VARCHAR2	(30)	Internal Name of Error Message.
MESSAGE_TYPE	VARCHAR2	(1)	Type of Error Message. Valid Values are C ( Critical ) or W ( Warning )
MESSAGE_TEXT	VARCHAR2	(1000)	Complete text of Error Message
SOURCE_TABLE_NAME	VARCHAR2	(30)	Name of the source table on which this validation failed.
DESTINATION_TABLE_NAME	VARCHAR2	(30)	Name of the destination table where the column value will be populated in Oracle Site Hub.
CREATED_BY	NUMBER		Standard WHO column
CREATION_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER		Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column
REQUEST_ID	NUMBER		The concurrent program request ID is populated in this column by the processing logic.
PROGRAM_APPLICATION_ID	NUMBER		The program application ID is populated in this column by the processing logic.
PROGRAM_ID	NUMBER		The concurrent program identifier is populated in this column by the processing logic.
PROGRAM_UPDATE_DATE	DATE		The program update date is populated in this column by the processing logic.
PROCESS_STATUS	VARCHAR2	(1)	This value will be 3 (Validation Failed) in most of the cases.
TRANSACTION_TYPE	VARCHAR2	(6)	Transaction Type for this record. The CREATE or UPDATE values are copied from the source table, identifying the mode of processing for the errored record.
BATCH_ID	NUMBER		BATCH ID is copied from the source table to which this errored record is attached.

Query Text

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


SELECT SITE_ID
,      SITE_IDENTIFICATION_NUMBER
,      COLUMN_NAME
,      MESSAGE_NAME
,      MESSAGE_TYPE
,      MESSAGE_TEXT
,      SOURCE_TABLE_NAME
,      DESTINATION_TABLE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      BATCH_ID
FROM RRS.RRS_INTERFACE_ERRORS;

Dependencies

[top of page]

RRS.RRS_INTERFACE_ERRORS does not reference any database object

RRS.RRS_INTERFACE_ERRORS is referenced by following:

RRS: RRS_INTERFACE_ERRORS#