Search Results fnd_resp_functions




Overview
Explore in AI Chat

Overview

The FND_RESP_FUNCTIONS table is a core repository for function security within the Oracle E-Business Suite (EBS) Application Object Library. It defines the authorization rules that govern which specific functions, menus, and form functions a user can access when operating under a given responsibility. This table is essential for implementing the security model that restricts user actions based on their assigned roles, ensuring compliance with segregation of duties and least-privilege principles. It acts as the junction table linking responsibilities (FND_RESPONSIBILITY) to executable actions (FND_FORM_FUNCTIONS, FND_MENUS).

Key Information Stored

The table's structure centers on creating a unique rule for a specific action within a responsibility. Its primary key is a composite of APPLICATION_ID, RESPONSIBILITY_ID, RULE_TYPE, and ACTION_ID. The APPLICATION_ID and RESPONSIBILITY_ID columns identify the specific responsibility. The ACTION_ID column holds the identifier for the secured object, which could be a form function or a menu, depending on the RULE_TYPE. The RULE_TYPE column is critical, as it dictates the nature of the security rule—for example, whether it is an exclusion (preventing access) or an inclusion (granting access) to the referenced ACTION_ID. Other supporting columns typically track creation and last update dates, and the ID of the last updating user.

Common Use Cases and Queries

Primary use cases involve auditing security setups and troubleshooting user access issues. System administrators frequently query this table to verify or report on the functions secured for a responsibility. A common pattern is to join with FND_RESPONSIBILITY_TL and FND_FORM_FUNCTIONS to produce a readable list of excluded functions for a given responsibility name.

  • Sample Query: To list all secured functions for a specific responsibility, one might use: SELECT frf.*, fft.USER_FUNCTION_NAME FROM FND_RESP_FUNCTIONS frf JOIN FND_FORM_FUNCTIONS fft ON frf.ACTION_ID = fft.FUNCTION_ID WHERE frf.RESPONSIBILITY_ID = :resp_id AND frf.APPLICATION_ID = :app_id;
  • Security Audit: Generating reports to ensure critical functions are properly restricted across all implemented responsibilities.
  • Access Diagnosis: Investigating why a user cannot access a menu option by checking for exclusion rules in their current responsibility.

Related Objects

FND_RESP_FUNCTIONS maintains documented foreign key relationships with several fundamental security tables, as per the provided metadata.

  • FND_RESPONSIBILITY: Links via APPLICATION_ID and RESPONSIBILITY_ID. This defines the responsibility to which the security rule applies.
  • FND_FORM_FUNCTIONS: Links via ACTION_ID. This relationship is used when the secured action is an individual form function.
  • FND_MENUS: Links via ACTION_ID. This relationship is used when the secured action is an entire menu.

The table is central to the function security mechanism, and changes to its data directly impact the user interface and navigational privileges presented to EBS users at runtime.