Search Results default_value_date




Overview
Explore in AI Chat

Overview

AK_ATTRIBUTES is a core metadata repository table in the Oracle E-Business Suite, owned by the AK (Common Modules-AK) schema. It stores the definition of individual attributes, their display and validation properties, and the application identifier that scopes each attribute. In practical terms, this table describes how a field used within Oracle Application Framework (OAF) regions, personalizations, and flexfield-style layouts should be rendered, formatted, and interpreted. Each row captures presentation attributes such as alignment, bold and italic flags, item style, CSS class names, and poplist (LOV) configuration, alongside data-type and precision information.

The primary key is AK_ATTRIBUTES_PK, defined on the composite of ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID. A unique index, AK_ATTRIBUTES_U1, covers ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID, and ZD_EDITION_NAME, extending the business key to accommodate edition-based redefinition. From a Data Vault modeling perspective, the table is heuristic-classified as hub-leaning, meaning it functions primarily as a durable business-key reference (the attribute identity) from which dependent satellite and link structures are derived. The physical schema documented for ETRM 12.2.2 contains 47 columns; the 12.1.1 release follows the same structural design.

Key Information Stored

The most consequential columns include:

Common Use Cases and Queries

Developers and administrators query AK_ATTRIBUTES to understand how a field is configured, to audit personalizations, and to build metadata reports. A typical join with the translatable table retrieves display labels:

  • SELECT a.ATTRIBUTE_CODE, t.ATTRIBUTE_LABEL, a.DATA_TYPE, a.ITEM_STYLE
    FROM AK.AK_ATTRIBUTES a, AK.AK_ATTRIBUTES_TL t
    WHERE a.ATTRIBUTE_CODE = t.ATTRIBUTE_CODE
    AND a.ATTRIBUTE_APPLICATION_ID = t.ATTRIBUTE_APPLICATION_ID
    AND t.LANGUAGE = USERENV('LANG');
  • Reporting which attributes belong to a given application: SELECT ATTRIBUTE_CODE, DATA_TYPE FROM AK.AK_ATTRIBUTES WHERE ATTRIBUTE_APPLICATION_ID = :app_id;
  • Identifying all attributes used by a region: join AK_REGION_ITEMS to AK_ATTRIBUTES on ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID.
  • Surfacing default values and styling for form-generation scripts or accessibility reviews.

Related Objects

AK_ATTRIBUTES is referenced by several dependent tables through the composite key columns ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID. The most significant include AK_ATTRIBUTES_TL (the translatable child holding language-specific labels), AK_OBJECT_ATTRIBUTES (mapping attributes to objects), AK_REGION_ITEMS (mapping attributes to regions), AK_EXCLUDED_ITEMS, AK_RESP_SECURITY_ATTRIBUTES, and AK_WEB_USER_SEC_ATTR_VALUES (responsibility and user security attribute assignments). Outside the AK schema, HZ_STYLE_FMT_LAYOUTS_B in the Trading Community/Receivables area also references AK_ATTRIBUTES, demonstrating cross-module reuse of the attribute definitions.