Results for “gl_defas_access_sets”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_DEFAS_ACCESS_SETS is a General Ledger table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the GL schema. It stores Definition Access Set definitions, which control how Definition Access Sets are named, secured, and assigned to users for use across General Ledger configuration activities. Definition Access Sets are the mechanism by which administrators grant or restrict a user's ability to create, modify, or use specific Financial Statement Generator (FSG) components, recurring journals, allocation definitions, and other GL definition types. This table therefore acts as the registration and header repository for those access sets.

The ETRM metadata classifies this object heuristically as standalone within a Data Vault model. This suggests treating GL_DEFAS_ACCESS_SETS as a hub-style entity keyed on DEFINITION_ACCESS_SET_ID, with descriptive attributes modeled as satellite columns. It has no documented foreign-key dependencies on other tables, which is consistent with its role as an independent reference/definition table rather than a transactional or intersection table.

Key Information Stored

The table contains 26 documented columns. The most significant are summarized below.

• DEFINITION_ACCESS_SET_ID — The surrogate primary key, enforced by GL_DEFAS_ACCESS_SETS_PK. This is the internal identifier used by all downstream references.
• USER_DEFINITION_ACCESS_SET — The user-facing business name of the access set. It is a documented business-key candidate via unique index GL_DEFAS_ACCESS_SETS_U2 (combined with ZD_EDITION_NAME).
• DEFINITION_ACCESS_SET — The internal/system name for the access set, forming another business-key candidate through GL_DEFAS_ACCESS_SETS_U3 (with ZD_EDITION_NAME).
• DESCRIPTION — Free-text explanation of the access set's purpose and scope.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard EBS audit columns tracking who created and last modified the record.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) infrastructure, allowing customer-specific extensions without schema changes.
• ZD_EDITION_NAME — An editioning-related column present in the 12.2.2 schema, participating in all three unique indexes.

The three unique indexes (U1 on DEFINITION_ACCESS_SET_ID + ZD_EDITION_NAME, U2 on USER_DEFINITION_ACCESS_SET + ZD_EDITION_NAME, and U3 on DEFINITION_ACCESS_SET + ZD_EDITION_NAME) establish both the primary identity and the secondary business keys for the table.

Common Use Cases and Queries

Typical use cases include auditing which Definition Access Sets exist, verifying naming conventions, and reporting on assignment scope. The following query lists all defined access sets:

• SELECT DEFINITION_ACCESS_SET_ID, USER_DEFINITION_ACCESS_SET, DEFINITION_ACCESS_SET, DESCRIPTION FROM GL.GL_DEFAS_ACCESS_SETS ORDER BY USER_DEFINITION_ACCESS_SET;

For troubleshooting a specific set by its business name:

• SELECT * FROM GL.GL_DEFAS_ACCESS_SETS WHERE USER_DEFINITION_ACCESS_SET = :name;

To review recently modified definitions for change-control reporting, filter on the audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY). Because the table is standalone, joins to assignment tables must be resolved through the DEFINITION_ACCESS_SET_ID surrogate key wherever it is referenced downstream.

Related Objects

Although the metadata documents no explicit foreign keys, the following objects are commonly referenced in conjunction with this table in GL access-set administration and reporting:

• GL_DEFAS_ASSIGNMENTS — Maps access sets to users or responsibilities via DEFINITION_ACCESS_SET_ID.
• GL_DEFAS_DEFINITIONS — Associative definitions tying access sets to specific GL definition objects.
• FND_USER — Source of user identities referenced in assignment logic.
• FND_RESPONSIBILITY — Responsibilities that may be granted access through the sets.
• GL_JE_CATEGORIES and GL_ALOC_DEFINITIONS — Definition types typically governed by access sets.
• RG_DEFAS_ACCESS_SETS_VL / _V — Reporting views that expose translated or validated content.

Because GL_DEFAS_ACCESS_SETS is standalone, joins hinge on DEFINITION_ACCESS_SET_ID and should be validated against the corresponding child tables' FK definitions in the target environment.