Search Results gl_defas_assignments_v




Overview
Explore in AI Chat

Overview

GL_DEFAS_ASSIGNMENTS_V is a dictionary view owned by the APPS schema in Oracle E-Business Suite, classified under the General Ledger (GL) product family. It exposes row-level assignment records that govern Definition Access Sets, the security mechanism used in EBS release 12.1.1 and 12.2.2 to control which users may view, use, or modify specific General Ledger definitions such as ledgers, budgets, recurring journals, allocations, and consolidation definitions. Each row of the view represents a single assignment of an object (identified by type and key) to a Definition Access Set, together with the access privileges granted for that assignment.

The view is primarily a reporting and integration object. It denormalizes several technical identifiers into user-readable descriptions by joining the underlying assignment table to FND_OBJECTS_VL for the object type display name and to GL_DEFAS_ACCESS_SETS for the access set name. It also invokes a PL/SQL function to resolve the object key into a descriptive object name. The DEFINITION_ACCESS_SET_ID column, which users frequently search on, is the primary foreign key linking an assignment to its parent Definition Access Set.

Underlying Base Objects

The view is defined over the following documented base objects:

Because the assignments table stores only technical keys, the joins and function call in the view are essential for producing consumable output.

Key Columns

  • DEFINITION_ACCESS_SET_ID — identifier of the parent Definition Access Set; the principal join key.
  • ROW_ID — the underlying ROWID of the assignment row, useful for update-safe addressing.
  • OBJECT_TYPE / OBJECT_DESCRIPTION — the internal object type name and its translated display name from FND_OBJECTS_VL.
  • OBJECT_KEY / OBJECT_NAME — the technical key of the assigned object and its resolved descriptive name.
  • VIEW_ACCESS_FLAG, USE_ACCESS_FLAG, MODIFY_ACCESS_FLAG — the privilege grants (view, use, modify) applied to the assignment.
  • NAME — the user-defined access set name from GL_DEFAS_ACCESS_SETS.
  • STATUS_CODE, CONTEXT, ATTRIBUTE1–15 — status and descriptive flexfield context/segments supporting extensibility.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID — standard audit and concurrent request columns.

Common Use Cases and Queries

Typical uses include security audits, reporting which objects are assigned to which access sets, and diagnosing why a user can or cannot access a given GL definition.

List assignments for a specific access set:

SELECT definition_access_set_id, name, object_type, object_description, object_name, view_access_flag, use_access_flag, modify_access_flag FROM gl_defas_assignments_v WHERE definition_access_set_id = :p_set_id;

Find all access sets containing a given object:

SELECT name, definition_access_set_id, object_type, object_name FROM gl_defas_assignments_v WHERE object_name = :p_object_name ORDER BY name;

Report effective grants by privilege:

SELECT name, object_description, object_name, view_access_flag, use_access_flag, modify_access_flag FROM gl_defas_assignments_v WHERE modify_access_flag = 'Y' ORDER BY name, object_name;

These queries make the view suitable for seeded or custom concurrent programs, BI Publisher reports, and read-only integrations requiring Definition Access Set visibility.