Results for “object_description”

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

Overview

The view AK_OBJECT_ATTRIBUTE_NAVIGATI_V is an Oracle E-Business Suite dictionary view owned by the APPS schema within the AK (Common Modules – AK) product family. The ETRM documentation classifies this object with the description "10SC ONLY," indicating that its applicability is restricted to a specific deployment scope rather than a general-purpose, cross-module interface. Despite this narrow designation, the view plays a supporting role in exposing the metadata that defines how attributes assigned to database objects map to navigable regions within the Oracle EBS framework.

Functionally, the view joins translated objects, attributes, and region definitions with the navigation records held in AK_OBJECT_ATTRIBUTE_NAVIGATION. It presents a flattened, query-ready projection of object-to-attribute navigation metadata, which supports reporting on how application objects route users to destination regions through configured attribute values. This is particularly relevant in the context of Oracle EBS 12.1.1 and 12.2.2, where the AK product underpins the configuration and extensibility framework used across multiple application modules.

Underlying Base Objects

The view is defined over five documented base objects, all accessed through synonyms:

• AK_OBJECT_ATTRIBUTE_NAVIGATION — the primary navigation table supplying the driving rows, including values, region targets, and attribute descriptors.
• AK_OBJECTS_TL — the translated object table, providing the object name and object description.
• AK_ATTRIBUTES_TL — the translated attribute table, supplying the attribute name.
• AK_ATTRIBUTES — the base attribute table, contributing the data type of each attribute.
• AK_REGIONS_TL — the translated region table, providing the destination region name and description.

Joins are performed on application-specific keys (region application ID plus region code, attribute code plus application ID, and database object name), with language predicates of USERENV('LANG') applied to the three translated tables to return rows in the session's current language.

Key Columns

The view returns a broad set of columns. Notable among them is OBJECT_DESCRIPTION, sourced from AOT.DESCRIPTION, which is the term most commonly sought by users searching for "object_description." Other significant columns include DATABASE_OBJECT_NAME, OBJECT_NAME, ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE, ATTRIBUTE_NAME, and the typed value columns VALUE_VARCHAR2, VALUE_DATE, and VALUE_NUMBER. Destination routing is exposed through TO_REGION_APPL_ID, TO_REGION_CODE, TO_REGION_NAME, and TO_REGION_DESCRIPTION. The DATA_TYPE column indicates how the stored value should be interpreted. Standard audit and descriptive flexfield columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15, CREATED_BY, CREATION_DATE, and related fields) round out the projection.

Common Use Cases and Queries

Typical usage centres on investigative queries that resolve object descriptions and their associated navigation targets. A representative query follows:

• SELECT object_name, object_description, attribute_name, to_region_name FROM ak_object_attribute_navigati_v WHERE database_object_name = :object_name;
• SELECT attribute_name, data_type, value_varchar2, value_date, value_number FROM ak_object_attribute_navigati_v WHERE object_description LIKE '%Inventory%';
• SELECT to_region_code, to_region_name, to_region_description FROM ak_object_attribute_navigati_v WHERE attribute_code = :attr_code;

These queries support metadata auditing, troubleshooting navigation configurations, and building custom reports that document how object attributes drive region-level navigation. Users should account for the translation predicates, ensuring the session language is appropriate, and should treat the "10SC ONLY" scope designation as a caution where broader reuse is intended.