Search Results ak_attributes

Overview

The AK_ATTRIBUTES table is a core repository table within the Oracle E-Business Suite (EBS) Application Object Library (AK) module. It serves as the master definition table for attributes, which are the fundamental building blocks of the EBS framework's flexible data modeling and user interface components. An attribute represents a single piece of data, analogous to a column in a database table, but defined at the application level. This table stores the technical name, key properties, and application context for every attribute registered within the system, forming the basis for defining regions, objects, and security rules in the AK architecture.

Key Information Stored

The table's primary key is a composite of ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID, ensuring uniqueness across different EBS applications. Key columns include ATTRIBUTE_CODE, which holds the internal name of the attribute (e.g., 'CUSTOMER_NAME'), and ATTRIBUTE_APPLICATION_ID, which links the attribute to its owning application via the FND_APPLICATION table. Other critical columns define the attribute's data type, format, maximum length, and whether it is required or translatable. The table also contains columns for controlling display properties, such as prompt text and tooltip references, though the actual translated prompts are stored in the related AK_ATTRIBUTES_TL (Translation) table.

Common Use Cases and Queries

This table is primarily queried for metadata analysis, troubleshooting, and impact assessment during customizations or upgrades. Common scenarios include identifying all attributes defined for a specific application, finding where a particular attribute is used across the system, or analyzing attribute properties for data migration planning. A typical query retrieves attribute details for a known code:

• SELECT attribute_code, attribute_application_id, data_type, maximum_length FROM ak_attributes WHERE attribute_code = '&ATTRIBUTE_CODE' AND attribute_application_id = &APP_ID;

Another frequent use case is joining with AK_OBJECT_ATTRIBUTES to list all attributes assigned to a specific framework object, or with AK_REGION_ITEMS to understand the attributes used on a particular UI region.

Related Objects

As indicated by the foreign key relationships, AK_ATTRIBUTES is central to the AK framework. Key dependent tables include AK_ATTRIBUTES_TL for translated prompts, AK_OBJECT_ATTRIBUTES which assigns attributes to AK objects, and AK_REGION_ITEMS which places attributes on UI regions. It is also referenced by security objects (AK_RESP_SECURITY_ATTRIBUTES, AK_WEB_USER_SEC_ATTR_VALUES), exclusion lists (AK_EXCLUDED_ITEMS), and even by other modules like Oracle Trading Community Architecture (HZ_STYLE_FMT_LAYOUTS_B). Direct manipulation of this table is strongly discouraged; definitions should be managed through the appropriate Oracle Application Developer responsibilities and APIs.