Search Results fnd_responsibility




Overview
Explore in AI Chat

Overview

The FND_RESPONSIBILITY table is a core security and navigation definition table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS). It serves as the master repository for all responsibility definitions across the application. A responsibility is a fundamental security component that grants a user access to a specific set of menus, functions, and data, effectively defining their role and permitted actions within the system. Every user must be assigned one or more responsibilities to access the application. This table is critical for the application's security model, user interface presentation, and concurrent processing controls.

Key Information Stored

The table's structure defines the operational parameters of a responsibility. Its composite primary key consists of APPLICATION_ID and RESPONSIBILITY_ID, ensuring uniqueness within the context of an owning application. Key columns include RESPONSIBILITY_KEY (a unique identifier used internally), MENU_ID (linking to the menu structure the responsibility can access), and REQUEST_GROUP_ID with GROUP_APPLICATION_ID (defining which concurrent programs and reports the responsibility can run). The DATA_GROUP_ID and DATA_GROUP_APPLICATION_ID columns control the mapping to Oracle database accounts (APPS schemas) used for data access. Other vital columns manage the responsibility's start date, end date, version, and web host/agent information for HTML-based responsibilities.

Common Use Cases and Queries

This table is central to administrative reporting, security audits, and data fixes. Common queries involve listing responsibilities, diagnosing access issues, and linking responsibilities to users. For example, to list all active responsibilities with their associated application and menu, a query would join FND_RESPONSIBILITY with FND_APPLICATION and FND_MENUS. Troubleshooting a user's inability to see a specific function often involves tracing from the user assignment (FND_USER_RESP_GROUPS) to this table to check the assigned menu and its functions. Developers frequently reference this table when writing seeded data scripts or creating custom responsibilities programmatically via the FND_RESPONSIBILITY_PKG API.

  • Sample SQL to find responsibilities by name pattern: SELECT resp.responsibility_name, app.application_name, menu.user_menu_name FROM fnd_responsibility resp, fnd_application_vl app, fnd_menus_vl menu WHERE resp.application_id = app.application_id AND resp.menu_id = menu.menu_id AND resp.responsibility_name LIKE '%PAYABLES%';

Related Objects

As indicated by its extensive foreign key relationships, FND_RESPONSIBILITY is a hub table referenced throughout EBS. Key related objects include FND_APPLICATION (the owning application), FND_MENUS (the navigation menu), and FND_REQUEST_GROUPS (the executable programs). The FND_RESPONSIBILITY_TL table provides translated names for multilingual installations. Crucially, FND_USER_RESP_GROUPS (not listed in the provided metadata but a core table) links users to responsibilities. Other significant dependencies shown are FND_CONCURRENT_REQUESTS (which records the submitting responsibility), FND_PROFILE_OPTION_VALUES (where responsibility-level profile settings are stored), and FND_LOGIN_RESPONSIBILITIES (for login history).