Search Results gl_defas_resp_assign




Overview
Explore in AI Chat

Overview

The GL_DEFAS_RESP_ASSIGN table is a core security configuration table within Oracle E-Business Suite General Ledger (GL). Its primary role is to manage the assignment of Definition Access Sets to specific EBS responsibilities. A Definition Access Set is a GL security construct that controls which users, via their assigned responsibilities, can view, modify, or process specific financial entities such as ledgers, data access sets, and journal sources. This table serves as the junction point, defining which responsibilities have access to which sets of definitions, thereby enforcing data security and operational segregation within the GL module.

Key Information Stored

The table stores the composite key that uniquely identifies each assignment. The critical columns are DEFINITION_ACCESS_SET_ID, which references the specific security set (GL_DEFAS_ACCESS_SETS), and the responsibility identifiers: RESPONSIBILITY_ID, APPLICATION_ID, and SECURITY_GROUP_ID. The latter three columns together uniquely identify a responsibility within the FND_RESPONSIBILITY table, adhering to Oracle's data group and security group architecture. This structure ensures that a Definition Access Set can be precisely granted to a single responsibility instance.

Common Use Cases and Queries

A primary use case is auditing security setup to verify which responsibilities can access financial data for a given ledger. Administrators often query this table to troubleshoot user access issues or to document the security model. A typical query joins to FND_RESPONSIBILITY_TL for the responsibility name and GL_DEFAS_ACCESS_SETS for the access set name.

  • Sample Query: To list all responsibility assignments for a specific Definition Access Set (e.g., ID 1001):
    SELECT resp.responsibility_name, da.definition_access_set_name
    FROM gl_defas_resp_assign gra,
    fnd_responsibility_tl resp,
    gl_defas_access_sets da
    WHERE gra.definition_access_set_id = 1001
    AND gra.responsibility_id = resp.responsibility_id
    AND gra.application_id = resp.application_id
    AND gra.definition_access_set_id = da.definition_access_set_id
    AND resp.language = USERENV('LANG');

Related Objects

This table maintains direct foreign key relationships with other core security objects. As per the provided metadata, it references FND_SECURITY_GROUPS via the SECURITY_GROUP_ID column. Crucially, its composite primary key columns (RESPONSIBILITY_ID, APPLICATION_ID, SECURITY_GROUP_ID) implicitly reference the FND_RESPONSIBILITY table, which is the master source for responsibility definitions. Furthermore, the DEFINITION_ACCESS_SET_ID column references the GL_DEFAS_ACCESS_SETS table, which stores the master definition of the access sets themselves. This makes GL_DEFAS_ACCESS_SETS and FND_RESPONSIBILITY the primary parent tables for this assignment entity.