Search Results ak_excluded_items




Overview
Explore in AI Chat

Overview

The AK_EXCLUDED_ITEMS table is a core security and personalization component within the Oracle E-Business Suite (EBS) AK (Common Modules-AK) technology stack. It functions as a repository for declarative security rules that govern the visibility of specific application attributes. Its primary role is to enforce responsibility-level security by maintaining a list of secured attributes that must be hidden from users assigned a particular responsibility. This mechanism allows administrators to tailor the user interface dynamically, removing fields or data points based on a user's functional role without modifying the underlying application code, thereby enhancing both security and user experience.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each security rule. The key columns are RESPONSIBILITY_ID, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID. The RESPONSIBILITY_ID column stores the identifier for the EBS responsibility (from FND_RESPONSIBILITY) for which the attribute is hidden. The ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID columns together identify the specific attribute, as defined in the AK_ATTRIBUTES table, that is to be excluded. This design ensures that a given attribute can be secured for one responsibility while remaining visible for another, providing granular control over data and field access across the application.

Common Use Cases and Queries

A primary use case is auditing and reporting on field-level security configurations. System administrators often query this table to understand which responsibilities have restricted access to specific attributes. A common diagnostic query involves joining to FND_RESPONSIBILITY and AK_ATTRIBUTES to translate IDs into meaningful names. For example:

  • SELECT r.responsibility_name, a.attribute_label, a.application_id FROM ak_excluded_items e, fnd_responsibility r, ak_attributes a WHERE e.responsibility_id = r.responsibility_id AND e.attribute_code = a.attribute_code AND e.attribute_application_id = a.application_id;

Another critical scenario is during the implementation of customizations or extensions, where developers must ensure new fields respect existing security exclusions. The table is also referenced by the Oracle Application Framework (OAF) and other AK-based regions at runtime to dynamically suppress the rendering of excluded items on a page.

Related Objects

AK_EXCLUDED_ITEMS maintains integral relationships with other fundamental EBS objects, primarily through foreign key constraints. The documented relationships are:

  • FND_RESPONSIBILITY: The table references FND_RESPONSIBILITY via the columns AK_EXCLUDED_ITEMS.RESPONSIBILITY_ID and AK_EXCLUDED_ITEMS.ATTRIBUTE_APPLICATION_ID. This validates the responsibility for which the exclusion is defined.
  • AK_ATTRIBUTES: The table references AK_ATTRIBUTES via the columns AK_EXCLUDED_ITEMS.ATTRIBUTE_CODE and AK_EXCLUDED_ITEMS.ATTRIBUTE_APPLICATION_ID. This validates the specific attribute being secured.

These relationships ensure data integrity, linking each exclusion rule to a valid responsibility and a defined application attribute within the system.

  • Table: AK_EXCLUDED_ITEMS 12.1.1

    owner:AK,  object_type:TABLE,  fnd_design_data:AK.AK_EXCLUDED_ITEMS,  object_name:AK_EXCLUDED_ITEMS,  status:VALID,  product: AK - Common Modules-AK ,  description: List of secured attributes that should be hidden from a user based on their responsibility id ,  implementation_dba_data: AK.AK_EXCLUDED_ITEMS , 

  • Table: AK_EXCLUDED_ITEMS 12.2.2

    owner:AK,  object_type:TABLE,  fnd_design_data:AK.AK_EXCLUDED_ITEMS,  object_name:AK_EXCLUDED_ITEMS,  status:VALID,  product: AK - Common Modules-AK ,  description: List of secured attributes that should be hidden from a user based on their responsibility id ,  implementation_dba_data: AK.AK_EXCLUDED_ITEMS , 

  • Table: AK_ATTRIBUTES 12.2.2

    owner:AK,  object_type:TABLE,  fnd_design_data:AK.AK_ATTRIBUTES,  object_name:AK_ATTRIBUTES,  status:VALID,  product: AK - Common Modules-AK ,  description: Attribute name, properties and the application ID which define an attribute ,  implementation_dba_data: AK.AK_ATTRIBUTES , 

  • Table: AK_ATTRIBUTES 12.1.1

    owner:AK,  object_type:TABLE,  fnd_design_data:AK.AK_ATTRIBUTES,  object_name:AK_ATTRIBUTES,  status:VALID,  product: AK - Common Modules-AK ,  description: Attribute name, properties and the application ID which define an attribute ,  implementation_dba_data: AK.AK_ATTRIBUTES ,