Search Results fnd_responsibility
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).
-
Table: FND_RESPONSIBILITY
12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_RESPONSIBILITY, object_name:FND_RESPONSIBILITY, status:VALID, product: FND - Application Object Library , description: Responsibilities , implementation_dba_data: APPLSYS.FND_RESPONSIBILITY ,
-
Table: FND_RESPONSIBILITY
12.1.1
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_RESPONSIBILITY, object_name:FND_RESPONSIBILITY, status:VALID, product: FND - Application Object Library , description: Responsibilities , implementation_dba_data: APPLSYS.FND_RESPONSIBILITY ,
-
APPS.PER_PEOPLE_V14_PKG dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.FND_FLEX_LOADER_APIS dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.FND_CONC_MAINTAIN dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.FND_USER_RESP_GROUPS_API dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.GL_BIS_SECURITY_PKG dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.POS_ANON_PKG dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.FND_FLEX_LOADER_APIS dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.IEX_CHECKLIST_UTILITY dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.IRC_GRANTS_UTIL dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.BIS_FN_SECURITY dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.CSI_ASSIGN_ROLE_PUB dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.HZ_DUP_PVT dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.POS_CHANGE_PROM_DATES dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.IRC_PARTY_SWI dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.PO_WF_PO_CHARGE_ACC dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.CSM_PROFILE_EVENT_PKG dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.FND_LOG_ADMIN dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.WF_SOA_CTX_PKG dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.FND_TRANSACTION_PIPE dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.HRI_BPL_SECURITY dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.CS_KB_CONTEXTS_PKG dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.IGS_EN_GEN_008 dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.BSC_PORTLET_UI_WRAPPER dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.BSC_SCORECARD_PUB dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.GL_PUBLIC_SECTOR dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.HR_OPT_BUS dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.BSC_APPS dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.JTF_REGION_PUB dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.IGS_PE_USERID_PKG dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.EAM_WORKORDER_UTIL_PKG dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.BISVIEWER dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.PN_PROFILE_UPGRADE dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.ODP dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.PSA_UTILS dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.PVX_MISC_PVT dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.OE_GLOBALS dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.WF_EVENT dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.UMX_W3H_UTL dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.IRC_LOGIN dependencies on FND_RESPONSIBILITY
12.2.2
-
APPS.BSC_UPGRADES_GENERIC dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.PSA_FUNDS_CHECKER_PKG dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.MSC_WS_ATP dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.HR_DM_DELETE dependencies on FND_RESPONSIBILITY
12.1.1
-
APPS.OM_SETUP_VALID_PKG dependencies on FND_RESPONSIBILITY
12.1.1