Results for “ak_objects”

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

Overview

AK_OBJECTS is a foundational metadata repository table in the Oracle E-Business Suite, owned by the AK (Common Modules-AK) schema. It defines the set of business objects registered with the Oracle Application Object Library (AOL) and records the application identifier of the owner of each object. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the registry that ties a logical object name, such as an entity exposed by a self-service or region-based framework, to its physical database representation and to the API packages responsible for defaulting and validating that object's attributes. Because many AK-family tables—attributes, unique keys, foreign keys, and regions—reference it, AK_OBJECTS is effectively the parent table for the AK metadata model.

From a Data Vault modeling perspective, the heuristic classification for AK_OBJECTS is hub-leaning. The table carries a stable business key and is referenced by numerous dependent tables, which is characteristic of a hub whose business key is DATABASE_OBJECT_NAME. This classification is a modeling suggestion only, derived from the foreign-key topology and the presence of a naturally unique identifier.

Key Information Stored

AK_OBJECTS contains 29 documented columns in the 12.2.2 physical schema. The most important are:

• DATABASE_OBJECT_NAME — the business key and part of the composite unique index; uniquely names the registered database object.
• PRIMARY_KEY_NAME — the name of the primary key constraint associated with the object, if any.
• DEFAULTING_API_PKG and DEFAULTING_API_PROC — the package and procedure invoked to default values for the object's attributes.
• VALIDATION_API_PKG and VALIDATION_API_PROC — the package and procedure invoked to validate attribute values.
• APPLICATION_ID — foreign key to the application that owns the object, tying the record to its owning product.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF-style descriptive flexfield columns used to store extensible, customer-specific metadata.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard WHO audit columns.
• ZD_EDITION_NAME — the editioning column supporting Oracle EBS 12.2 online patching, which segregates data by edition.

The surrogate primary key is AK_OBJECTS_PK on DATABASE_OBJECT_NAME. The unique index AK_OBJECTS_U1 on (DATABASE_OBJECT_NAME, ZD_EDITION_NAME) serves as the business-key candidate in the editioned 12.2 schema.

Common Use Cases and Queries

Developers and administrators query AK_OBJECTS to discover which API packages handle defaulting and validation for a given object, to locate the owning application, and to trace all metadata attributes registered against an object. A typical lookup joins the object to its descriptive flexfield attributes:

SELECT o.DATABASE_OBJECT_NAME, o.APPLICATION_ID, o.VALIDATION_API_PKG, a.ATTRIBUTE_NAME
FROM AK.AK_OBJECTS o, AK.AK_OBJECT_ATTRIBUTES a
WHERE o.DATABASE_OBJECT_NAME = a.DATABASE_OBJECT_NAME
AND o.DATABASE_OBJECT_NAME = :object_name;

Reporting scenarios include auditing which application owns the most registered objects and verifying that every object resolves to a valid defaulting and validation routine. Because ZD_EDITION_NAME is part of the unique index, queries run during or after an online patch cycle should filter or group on the edition column to avoid returning duplicate business keys.

Related Objects

AK_OBJECTS is referenced by multiple dependent tables through DATABASE_OBJECT_NAME, and by external modules through their own AK_OBJECT columns:

• AK_OBJECTS_TL — translated (language) rows for each object, joined on DATABASE_OBJECT_NAME.
• AK_OBJECT_ATTRIBUTES — attribute definitions belonging to each object.
• AK_UNIQUE_KEYS and AK_FOREIGN_KEYS — key constraint metadata for the object.
• AK_REGIONS — UI region definitions that map to an object.
• ASO_APR_OBJ_APPROVALS, ASO_APR_RULES_B, and ASO_APR_RULE_GROUPS_B — Oracle Order Capture approval objects referencing AK_OBJECTS.AK_OBJECT.
• HZ_STYLES_B — Trading Community Architecture style definitions keyed by DATABASE_OBJECT_NAME.
• OE_AK_OBJECTS_EXT — Order Management extension table for AK objects.