Search Results site




The RRS_MAP_SITE_SETTINGS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for configuration data related to the Responsibility and Role Security (RRS) framework. This table stores site-level settings that govern how responsibilities, roles, and security policies are applied across the Oracle EBS environment. Below is a detailed breakdown of its structure, purpose, and functional significance within Oracle EBS.

1. Purpose and Context

The RRS_MAP_SITE_SETTINGS table is part of Oracle's Role-Based Access Control (RBAC) infrastructure, specifically designed to manage responsibility mappings and security policies at a global or site-wide level. It ensures consistent enforcement of access controls by defining default behaviors, such as responsibility assignments, role hierarchies, and policy overrides. This table is particularly relevant in multi-org or multi-site deployments where centralized security management is required.

2. Key Columns and Data Structure

While the exact schema may vary slightly between EBS 12.1.1 and 12.2.2, the table typically includes the following columns:
  • SETTING_ID: A unique identifier for each configuration record.
  • SETTING_NAME: The name of the configuration parameter (e.g., "DEFAULT_RESP_MAPPING").
  • SETTING_VALUE: The value assigned to the parameter, which dictates behavior (e.g., "ENFORCE" or "ALLOW_OVERRIDE").
  • DESCRIPTION: A textual explanation of the setting's purpose.
  • LAST_UPDATE_DATE and LAST_UPDATED_BY: Audit columns tracking modifications.
  • APPLICATION_ID: Optional column linking the setting to a specific EBS application module.

3. Functional Role in Oracle EBS

The table serves as a backbone for:
  • Responsibility Mappings: Defines how responsibilities are assigned to roles or users at a site level.
  • Policy Enforcement: Stores flags to enforce or bypass security policies (e.g., segregation of duties).
  • Hierarchy Management: Configures role inheritance rules and access delegation.
  • Customization Overrides: Allows administrators to modify default behaviors without code changes.

4. Integration with Other Modules

The RRS_MAP_SITE_SETTINGS table interacts with:
  • FND_RESPONSIBILITY: Links to responsibility definitions.
  • PER_ROLES: Integrates with Oracle HRMS for role-based assignments.
  • FND_PROFILE_OPTIONS: Complements profile options for granular access control.

5. Technical Considerations

  • Performance Impact: Queries against this table are frequent during user authentication, necessitating indexing on key columns like SETTING_NAME.
  • Upgrade Implications: Changes between 12.1.1 and 12.2.2 may include additional columns or deprecated settings.
  • Patch Dependencies: Critical patches (e.g., for security vulnerabilities) may modify this table's structure.

6. Administrative Best Practices

  • Document all custom settings to avoid conflicts during upgrades.
  • Leverage Oracle's FNDLOAD utility to migrate configurations between environments.
  • Regularly audit settings to ensure compliance with organizational policies.
In summary, the RRS_MAP_SITE_SETTINGS table is a pivotal component of Oracle EBS's security framework, enabling centralized management of responsibility and role mappings. Its configuration directly impacts system security, user access, and audit compliance, making it essential for administrators to understand its structure and functionality.