Search Results gl_das_auto_alloc_sets

Overview

APPS.GL_AUTO_ALLOC_SETS_V is a data-secured reporting view over the General Ledger automatic allocation set definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the rows of the underlying GL_AUTO_ALLOC_SETS synonym while enriching each row with three decoded privilege columns — VIEW_PRIVILEGE, USE_PRIVILEGE, and MODIFY_PRIVILEGE — and a formatted owner display value. The view is a consumer-facing layer intended for Oracle Forms-based maintenance, self-service reporting, and integration queries that must honour Oracle's data access security model. Because the security check is embedded in the SELECT list, two users querying the same row can receive different privilege values, which makes the view unsuitable as a bulk data extract without awareness of the FND_DATA_SECURITY dependency. The view is owned by APPS and is documented in ETRM 12.2.2 with a dependency set consisting of two packages, one synonym, and one custom package.

Underlying Base Objects

The view is defined over four documented objects. GL_AUTO_ALLOC_SETS (a synonym owned in APPS, resolving to the GL base table) supplies every persisted column, including the SECURITY_FLAG that drives conditional logic. FND_DATA_SECURITY is the security engine invoked three times per row through fnd_data_security.check_function, using the security group identifiers GL_DAS_AUTO_ALLOC_SETS_V, GL_DAS_AUTO_ALLOC_SETS_U, and GL_DAS_AUTO_ALLOC_SETS_M for view, use, and modify rights respectively. FND_GLOBAL supplies the runtime user context via fnd_global.user_name, which is passed as the key to each security check. GL_AUTO_ALLOC_VW_PKG provides the GET_OWNER_DSP function that translates the stored OWNER value into a 240-character display string for the OWNER_DSP column. The join to FND_DATA_SECURITY is scalar and per-row, meaning query cost scales with row count and the number of enabled security checks.

Key Columns

ALLOCATION_SET_ID is the primary key and the value passed to every security check. ALLOCATION_SET_NAME, DESCRIPTION, OWNER, and ORG_ID identify the allocation set. ALLOCATION_SET_TYPE_CODE and ALLOCATION_CODE classify the allocation. CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, and ACCOUNTED_PERIOD_TYPE bind the set to a ledger's accounting configuration. SECURITY_FLAG is the pivot column: when set to 'Y', the three privilege columns are resolved through FND_DATA_SECURITY; otherwise all three default to 'Y'. VIEW_PRIVILEGE, USE_PRIVILEGE, and MODIFY_PRIVILEGE return 'Y' or 'N' based on the 'T'/'Y' mapping performed by DECODE. OWNER_DSP holds the formatted owner through SUBSTR(...,1,240). The fifteen ATTRIBUTE columns and CONTEXT provide the standard Oracle descriptive flexfield storage. Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN are carried through unchanged.

Common Use Cases and Queries

The view supports security-aware maintenance screens and reporting. A typical query filters to allocation sets the user may modify:

• SELECT allocation_set_id, allocation_set_name, owner_dsp FROM apps.gl_auto_alloc_sets_v WHERE security_flag = 'Y' AND modify_privilege = 'Y' — returns only sets the current user may change.
• SELECT allocation_set_id, allocation_set_name FROM apps.gl_auto_alloc_sets_v WHERE view_privilege = 'Y' AND org_id = :org — a reporting extract restricted to visible sets within an operating unit.
• SELECT allocation_set_name, owner_dsp, use_privilege FROM apps.gl_auto_alloc_sets_v WHERE owner = :owner ORDER BY allocation_set_name — lists ownership with per-row use rights, useful for allocation run eligibility checks.
• SELECT COUNT(*) FROM apps.gl_auto_alloc_sets_v WHERE security_flag = 'Y' AND modify_privilege = 'N' — identifies secured sets deliberately withheld from the user.

Because each privilege column triggers an independent call to fnd_data_security.check_function, queries selecting all three columns incur three security evaluations per row. For high-volume extracts, restricting the projection to VIEW_PRIVILEGE alone, or filtering on security_flag = 'N' first, materially reduces overhead. The security group naming convention — GL_DAS_AUTO_ALLOC_SETS with _V, _U, and _M suffixes — confirms that the view is the registered object for Data Access Set enforcement on automatic allocations in both 12.1.1 and 12.2.2.