Search Results ak_web_user_sec_attr_values

Overview

The table AK_WEB_USER_SEC_ATTR_VALUES is a core repository for user-specific security attribute data within the Oracle E-Business Suite (EBS) framework. It is owned by the AK (Common Modules-AK) schema, which underpins the Application Object Library and the flexfield architecture. This table's primary role is to store runtime values for security attributes assigned to individual web users. These attributes are a fundamental component of the EBS security model, enabling fine-grained access control and personalization based on dynamic user characteristics beyond standard responsibilities and menus. The table is integral to the function of the Oracle Applications Framework (OAF) and other web-based components in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to hold various data types for a given user and attribute combination. Its primary key uniquely identifies a user's specific attribute value through the columns WEB_USER_ID, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID. The value itself is stored in one of three typed columns: VARCHAR2_VALUE, DATE_VALUE, or NUMBER_VALUE, depending on the attribute's definition. This design allows the table to support a wide range of security criteria, from textual codes and numeric identifiers to date-based conditions. The WEB_USER_ID typically corresponds to the FND_USER.USER_ID, linking the attribute value to a specific EBS user session.

Common Use Cases and Queries

This table is primarily accessed by the EBS security engine to evaluate a user's privileges for data and function access. Common use cases include implementing attribute-based security on regions or items in OAF pages, securing custom flexfields, and driving personalized application behavior. A typical query to retrieve a user's security attribute values for reporting or debugging would join to the attribute definition table.

• Sample Query: SELECT w.WEB_USER_ID, u.USER_NAME, a.ATTRIBUTE_LABEL, w.VARCHAR2_VALUE FROM AK_WEB_USER_SEC_ATTR_VALUES w, FND_USER u, AK_ATTRIBUTES a WHERE w.WEB_USER_ID = u.USER_ID AND w.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE AND w.ATTRIBUTE_APPLICATION_ID = a.APPLICATION_ID;
• Debugging Access: Developers and administrators query this table to verify the security context of a user when diagnosing "Insufficient Privileges" errors in OAF or custom code that leverages the AK security APIs.

Related Objects

The functionality of AK_WEB_USER_SEC_ATTR_VALUES is tightly coupled with several other AK schema objects, as indicated by its foreign keys.

• AK_ATTRIBUTES: This is the master definition table for all security attributes. The foreign key from AK_WEB_USER_SEC_ATTR_VALUES (ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID) references AK_ATTRIBUTES, ensuring that only defined attributes can have user values.
• FND_USER: While not a formal foreign key in the provided metadata, the WEB_USER_ID column is logically related to FND_USER.USER_ID, linking the attribute value to the core EBS user identity.
• AK Security APIs: Data is typically populated and retrieved via proprietary AK package APIs rather than through direct DML. These APIs manage the business logic for evaluating security based on the stored values.