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_SITE_UA_INTF

Object Details

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

This is an interface table used to import Site User Defined Attribute data. The interface is commonly used by Excel import and import using PL/SQL import interface. For Excel Import process, user should not update this table. The data only needs to be populated for the PL/SQL based import process.
For PL/SQL based import method, Site Import Interface Program will process rows in this table and import the data in Oracle Site Hub. It is expected that users would populate the data before submitting the import process.
Scope: public
Product: RRS
Lifecycle: active
Display Name: RRS SITE UA INTF
Category: OPEN_INTERFACE RRS_SITE_UA_INTF 1
Category: BUSINESS_ENTITY RRS_SITE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
TRANSACTION_ID	NUMBER		Used for Internal Processing. Please do not update.
DATA_LEVEL_ID	NUMBER		Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 71802 during data processing.
DATA_LEVEL_NAME	VARCHAR2	(30)	Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'SITE_LEVEL' during data processing.
USER_DATA_LEVEL_NAME	VARCHAR2	(240)	Used for Internal Processing. Please do not update.
PROCESS_STATUS	VARCHAR2	(15)	Various stages of this record while undergoing validations and processing. This column can have 4 possible values. For a record to be processed, user has to set this value to 1 (Awaiting Validation). Once the processing starts , Import Interface will update value of this column to 2 (Validation Started). If the record passes the validations , value is updated to 4 (Validation Succeeeded ) and in case of error this value would be updated to 3 (Validation Failed).
DATA_SET_ID	NUMBER		Used for Internal Processing. Please do not update. An identifier for the collection of rows to be processed together.
ROW_IDENTIFIER	NUMBER		Identifier column for the record. This column should be populated very carefully. For all attributes of a Single Row Attribute Group, a common and unique value should be used. For all attributes of a Multi-Row Attribute Group row, a common and unique value should be used. The value used, should not be repeated for any other Single Row or Multi-Row Attribute Group row in a batch.
SITE_NUMBER	VARCHAR2	(30)	Site Identification Number of the Site for which user is uploading the User Defined Attributes.
ATTR_GROUP_INT_NAME	VARCHAR2	(30)	Internal name of the User Defined Attribute Group to which attributes are attached. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group.
ATTR_INT_NAME	VARCHAR2	(30)	Internal name of the attribute. User can query this information from Site Management Administrator responsibility by viewing the definition of the Attribute Group and it's attributes.
ATTR_VALUE_STR	VARCHAR2	(1000)	User Defined Attribute value of type VARCHAR. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_NUM and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility.
ATTR_VALUE_NUM	NUMBER		User Defined Attribute value of type NUMBER. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_DATE should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility.
ATTR_VALUE_DATE	DATE		User Defined Attribute value of type DATE. Note that one row of data in this table is used to process one attribute of an attribute group. Thereby, if this value is populated, values for ATTR_VALUE_STR and ATTR_VALUE_NUM should not be populated. User can query the data type of the attribute by viewing the definition of the Attribute Group and it's Attibutes using Site Administrator responsibility.
ATTR_DISP_VALUE	VARCHAR2	(1000)	Display Value of the Attributes. For Value Set based attributes, display value can be different from the value actually stored in the database. Enter the Display Value, sometimes also known as the Meaning of the Value Set, in this field.
TRANSACTION_TYPE	VARCHAR2	(10)	Transaction Type for this record. Valid values are CREATE or UPDATE.
SITE_ID	VARCHAR2	(150)	Internal identifier of the Site for which User Defined Attribute data is to be uploaded. User can query the Site_id from RRS_SITES_VL. Ensure that this value is correctly populated for successful processing.
ATTR_GROUP_ID	NUMBER		Internal identifier of User Defined Attribute Group to which attributes are attached. User can query this from ego_obj_ag_assocs_b.
REQUEST_ID	NUMBER		Used for Internal Processing. Please do not update. The concurrent program request ID is populated in this column by the processing logic.
PROGRAM_APPLICATION_ID	NUMBER		Used for Internal Processing. Please do not update. The program application ID is populated in this column by the processing logic.
PROGRAM_ID	NUMBER		Used for Internal Processing. Please do not update. The concurrent program identifier is populated in this column by the processing logic.
PROGRAM_UPDATE_DATE	DATE		Used for Internal Processing. Please do not update. The program update date is populated in this column by the processing logic.
CREATED_BY	NUMBER		Standard who columns.
CREATION_DATE	DATE		Standard who columns.
LAST_UPDATED_BY	NUMBER		Standard who columns.
LAST_UPDATE_DATE	DATE		Standard who columns.
LAST_UPDATE_LOGIN	NUMBER		Standard who columns.
SITE_USE_TYPE_CODE	VARCHAR2	(150)	This is the Site Purpose. Eg. Store, Mail Box
ATTR_GROUP_TYPE	VARCHAR2	(30)	Used for Internal Processing. Please do not update. This column is internally populated with a fixed value of 'RRS_SITEMGMT_GROUP' during data processing.
ATTR_UOM_DISP_VALUE	VARCHAR2	(25)	Display value of Unit Of Measure associated with an attribute of data type NUMBER. User can query this value from UNIT_OF_MEASURE column of MTL_UNITS_OF_MEASURE table.
ATTR_VALUE_UOM	VARCHAR2	(3)	Internal value of Unit Of Measure associated with the attribute of data type NUMBER. User can query this value from UOM_CODE column of MTL_UNITS_OF_MEASURE table.
BATCH_ID	NUMBER		BATCH ID to which this record is attached. Batch ID is provided by end user to process multiple site records in the Interface table in one batch

Query Text

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


SELECT TRANSACTION_ID
,      DATA_LEVEL_ID
,      DATA_LEVEL_NAME
,      USER_DATA_LEVEL_NAME
,      PROCESS_STATUS
,      DATA_SET_ID
,      ROW_IDENTIFIER
,      SITE_NUMBER
,      ATTR_GROUP_INT_NAME
,      ATTR_INT_NAME
,      ATTR_VALUE_STR
,      ATTR_VALUE_NUM
,      ATTR_VALUE_DATE
,      ATTR_DISP_VALUE
,      TRANSACTION_TYPE
,      SITE_ID
,      ATTR_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SITE_USE_TYPE_CODE
,      ATTR_GROUP_TYPE
,      ATTR_UOM_DISP_VALUE
,      ATTR_VALUE_UOM
,      BATCH_ID
FROM RRS.RRS_SITE_UA_INTF;

Dependencies

[top of page]

RRS.RRS_SITE_UA_INTF does not reference any database object

RRS.RRS_SITE_UA_INTF is referenced by following:

RRS: RRS_SITE_UA_INTF#