Results for “ak_object_attribute_navigation”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AK_OBJECT_ATTRIBUTE_NAVIGATION is a reference table in the AK (Common Modules-AK) product schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its documented purpose is to define a specific object attribute value that allows access to a region, effectively serving as the navigation-routing metadata used by the Oracle Application Framework (OAF) / AK personalization and extensibility infrastructure. Each row binds a qualifying attribute value on a registered database object to a target region, so that the framework can resolve "if this attribute holds this value, present that region."

From a dimensional modeling perspective, the mined Data Vault classification is link. This suggests the table is best modeled as an associative entity connecting two business keys: an object attribute definition (in AK_OBJECT_ATTRIBUTES) and a target region (in AK_REGIONS), qualified by the attribute value carried in VALUE_VARCHAR2, VALUE_DATE, or VALUE_NUMBER.

Key Information Stored

The table contains 30 documented columns. The most significant are grouped below.

• DATABASE_OBJECT_NAME — identifies the registered database object whose attribute is being qualified. Part of the primary key and of the foreign key to AK_OBJECT_ATTRIBUTES.
• ATTRIBUTE_CODE — the attribute on that object; also part of the AK_OBJECT_ATTRIBUTES foreign key.
• ATTRIBUTE_APPLICATION_ID — the owning application of the attribute; the third component of the AK_OBJECT_ATTRIBUTES foreign key.
• VALUE_VARCHAR2 — the character value that triggers navigation to the target region. This column is the focus of the user's search and is a component of the primary key and unique index, confirming that navigation rules are keyed by the literal attribute value.
• VALUE_DATE and VALUE_NUMBER — the date and numeric counterparts of the qualifying value, supporting typed navigation rules. All three VALUE columns participate in the primary key and unique index.
• TO_REGION_CODE — the target region reached when the value matches; part of the AK_REGIONS foreign key.
• TO_REGION_APPL_ID — the application owning that region; the second component of the AK_REGIONS foreign key.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive-flexfield columns, available for extension without schema change.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.
• ZD_EDITION_NAME — the editioning column introduced for online patching in 12.2.x.

The primary key is AK_OBJECT_ATTRIBUTE_NAVIGAT_PK over (DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID, VALUE_VARCHAR2, VALUE_DATE, VALUE_NUMBER). The unique index AK_OBJECT_ATTRIBUTE_NAVIGAT_U1 covers the same six columns plus ZD_EDITION_NAME, making these the business-key candidates; there is no separate surrogate identifier.

Common Use Cases and Queries

The table is queried when diagnosing why a particular region is or is not displayed, when documenting personalization behavior, or when auditing navigation metadata after a patch. A typical lookup by value is:

• Find all navigation rules tied to a literal value: SELECT database_object_name, attribute_code, to_region_code FROM ak.ak_object_attribute_navigation WHERE value_varchar2 = :p_value;
• Resolve the target region description by joining AK_REGIONS on TO_REGION_CODE and TO_REGION_APPL_ID.
• Confirm attribute context by joining AK_OBJECT_ATTRIBUTES on DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID.
• Edition-aware reporting should filter or group by ZD_EDITION_NAME on 12.2.x to isolate the active edition.

Because VALUE_VARCHAR2 is a key component rather than a mere descriptor, queries filtering on it are index-supported and inexpensive.

Related Objects

• AK_OBJECT_ATTRIBUTES — parent definition of the object attribute; joined on DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID.
• AK_REGIONS — target region registry; joined on TO_REGION_CODE and TO_REGION_APPL_ID.
• AK_OBJECT_ATTRIBUTE_NAVIGAT_PK / AK_OBJECT_ATTRIBUTE_NAVIGAT_U1 — primary key constraint and unique business-key index enforcing row uniqueness.
• AK_OBJECT_ATTRIBUTE_NAVIGATION.DATABASE_OBJECT_NAME → AK_OBJECT_ATTRIBUTES and TO_REGION_CODE → AK_REGIONS — the two documented referential relationships that define this table's link semantics.