RRS Tables (35)
RRS - Site Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
RRS_GROUP_TRADE_AREAS |
10 | This table stores the Trade Area Group and radii information of Radii/ Donut shapeTrade Areas. |
RRS_HIERARCHIES_EXT_B |
104 | This table stores the User Defined Attributes values associated with Hierarchy. |
RRS_HIERARCHIES_EXT_TL |
52 | This table stores the translated User Defined Attributes values associated with Hierarchies in multiple languages |
RRS_INTERFACE_ERRORS |
20 | This table will store the Errored rows found during the Import Interface process |
RRS_LOCATIONS_EXT_B |
104 | This table stores the User Defined Attributes values associated with Locations. |
RRS_LOCATIONS_EXT_TL |
52 | This table stores the translated User Defined Attributes values associated with Locations in multiple languages |
RRS_LOCATION_UA_INTF |
30 | This table is for internal use and it is used for webADI integration. |
RRS_LOC_TRADE_AREA_GRPS |
10 | This table stores the association between Trade Area Groups and Locations |
RRS_MAP_ICON_SETTINGS |
10 | This table stores preferences for Icons set by site Administrator. |
RRS_MAP_LOCATION_SETTINGS |
7 | This table stores preferences for locations set by site Administrator. |
RRS_MAP_SITE_SETTINGS |
7 | This table stores preferences for site types set by site Administrator. |
RRS_MAP_TRADE_AREA_SETTINGS |
7 | This table stores preferences for Trade Area Group set by site Administrator. |
RRS_SITES_B |
22 | This table is used to store the basic information about sites. |
RRS_SITES_EXT_B |
104 | This table stores the User Defined Attributes values associated with Sites. |
RRS_SITES_EXT_TL |
52 | This table stores the translated User Defined Attributes values associated with Sites in multiple languages |
RRS_SITES_INTERFACE |
41 | This is an interface table which will be used to populate data for Import Interface Process |
RRS_SITES_INTF |
9 | This table stores the Site information during Asset Creation process. |
RRS_SITES_TL |
10 | This table stores all the translatable information about sites. |
RRS_SITE_GROUPS_B |
11 | This table primarily stores the Site Group information, eg. Cluster and Hierarchy |
RRS_SITE_GROUPS_TL |
10 | This table primarily stores the translatable attributes of hierarchy and clusters |
RRS_SITE_GROUP_MEMBERS |
12 | This table contains the members of Cluste or Hierarchy. Member can be a site or a Node. |
RRS_SITE_GROUP_MEMBERS_TEMP |
11 | |
RRS_SITE_GROUP_NODES_B |
9 | This table contains the basic information of nodes |
RRS_SITE_GROUP_NODES_TL |
10 | This table contains the tranlatable attributes of Nodes. |
RRS_SITE_GROUP_VERSIONS |
10 | This table contains the versioned information of cluster or hierarchy. |
RRS_SITE_TMP |
4 | This table is reserved for integration with Oracle Spatial. Not supported in this release. |
RRS_SITE_UA_INTF |
31 | This table is for internal use and it is used for webADI integration. |
RRS_SITE_USES |
11 | This table stores information about how a site is used. Site can have multiple uses, for example Store , Distribution Centre , Mail Box etc. |
RRS_TEMPLATE_ATTRIBUTE_GROUPS |
11 | This table stores the information of templates associated with Attribute Groups |
RRS_TRADEAREA_UA_INTF |
30 | This table is for internal use and it is used for webADI integration. |
RRS_TRADE_AREAS |
11 | This table stores the information related to Trade Areas. |
RRS_TRADE_AREAS_EXT_B |
104 | This table stores the User Defined Attributes values associated with Trade Areas. |
RRS_TRADE_AREAS_EXT_TL |
52 | This table stores the translated User Defined Attributes values associated with Trade Areas in multiple languages |
RRS_TRADE_AREA_GROUPS_B |
11 | This table stores the information related to Trade Area Groups |
RRS_TRADE_AREA_GROUPS_TL |
10 | This table stores all the translatable information related to Trade Area Groups. |