RRS — Site Management

35 documented tables · 0 views — Oracle EBS ETRM 12.2.2

Most-referenced tables

Table	Description	Data Vault class*
RRS_SITES_B	This table is used to store the basic information about sites.	hub-leaning
RRS_TRADE_AREA_GROUPS_B	This table stores the information related to Trade Area Groups	hub-leaning
RRS_SITE_GROUPS_B	This table primarily stores the Site Group information, eg. Cluster and Hierarchy	hub-leaning
RRS_SITE_GROUP_NODES_B	This table contains the basic information of nodes	hub-leaning
RRS_SITE_GROUP_NODES_TL	This table contains the tranlatable attributes of Nodes.	satellite-leaning
RRS_SITES_TL	This table stores all the translatable information about sites.	satellite-leaning
RRS_TRADE_AREAS_EXT_TL	This table stores the translated User Defined Attributes values associated with Trade Areas in multiple langua	standalone
RRS_SITE_GROUP_VERSIONS	This table contains the versioned information of cluster or hierarchy.	satellite-leaning
RRS_TRADE_AREAS_EXT_B	This table stores the User Defined Attributes values associated with Trade Areas.	standalone
RRS_LOCATIONS_EXT_B	This table stores the User Defined Attributes values associated with Locations.	standalone
RRS_SITES_EXT_B	This table stores the User Defined Attributes values associated with Sites.	standalone
RRS_SITE_GROUP_MEMBERS	This table contains the members of Cluste or Hierarchy. Member can be a site or a Node.	standalone
RRS_LOC_TRADE_AREA_GRPS	This table stores the association between Trade Area Groups and Locations	standalone
RRS_TRADE_AREA_GROUPS_TL	This table stores all the translatable information related to Trade Area Groups.	satellite-leaning
RRS_SITE_GROUPS_TL	This table primarily stores the translatable attributes of hierarchy and clusters	satellite-leaning

*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.

Key public APIs

Package	Class	Procedures	Used by
RRS_SECURITY_PUB	PUB	6	2 packages

✨ Ask AI about RRS objects