Results for “validation_api_proc”

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

Overview

AK_OBJECT_ATTRIBUTES is a metadata repository table in the AK (Common Modules) product of Oracle E-Business Suite. It is the central linkage table that associates an attribute definition with the object on which that attribute is exposed. In the Oracle Application Framework and Flexfield/Descriptive Flexfield infrastructure, an "object" is a registered entity within the application (stored in AK_OBJECTS), and an "attribute" is a reusable column or business property definition (stored in AK_ATTRIBUTES). AK_OBJECT_ATTRIBUTES resolves the many-to-many relationship between the two, thereby defining which attributes are valid members of which objects, together with the presentation, defaulting, validation, and LOV behavior for each attribute-on-object pairing.

The table is classified, as a heuristic Data Vault modeling suggestion, as hub-leaning. This reflects its role as a durable, business-key-identified registry of attribute-to-object associations, with strong referential integrity around the composite key and a large surrounding network of dependent tables.

Key Information Stored

The table carries a composite primary key defined by AK_OBJECT_ATTRIBUTES_PK, spanning DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID. A unique index, AK_OBJECT_ATTRIBUTES_U1, extends this business key with ZD_EDITION_NAME to support edition-based redefinition. The most significant columns include:

• DATABASE_OBJECT_NAME — the object to which the attribute is attached; foreign key to AK_OBJECTS.
• ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID — the attribute identity; foreign key to AK_ATTRIBUTES.
• COLUMN_NAME, TABLE_NAME, and BASE_TABLE_COLUMN_NAME — physical storage mapping for the attribute.
• DATA_SOURCE_TYPE and DATA_STORAGE_TYPE — control how values are sourced and persisted.
• REQUIRED_FLAG, DISPLAY_VALUE_LENGTH, ATTRIBUTE_LABEL_LENGTH — validation and display controls.
• BOLD, ITALIC, VERTICAL_ALIGNMENT, HORIZONTAL_ALIGNMENT — rendering attributes.
• LOV_REGION_CODE, LOV_REGION_APPLICATION_ID, LOV_FOREIGN_KEY_NAME — list-of-values configuration.
• DEFAULTING_API_PKG, DEFAULTING_API_PROC, VALIDATION_API_PKG, VALIDATION_API_PROC — server-side defaulting and validation hooks.
• DEFAULT_VALUE_VARCHAR2, DEFAULT_VALUE_NUMBER, DEFAULT_VALUE_DATE — typed default values.
• TRANSLATION_FLAG and ZD_EDITION_NAME — multi-language and editioning support.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and a DESC_FLEX segment block (ATTRIBUTE1–ATTRIBUTE15).

Common Use Cases and Queries

Because AK_OBJECT_ATTRIBUTES drives descriptive flexfield and page-level attribute rendering, common uses include auditing which attributes belong to a given object, troubleshooting defaulting or LOV behavior, and reporting on required versus optional fields.

A typical lookup by object:

SELECT a.ATTRIBUTE_CODE, a.COLUMN_NAME, a.REQUIRED_FLAG
FROM   AK.AK_OBJECT_ATTRIBUTES a
WHERE  a.DATABASE_OBJECT_NAME = :object_name
AND    a.ATTRIBUTE_APPLICATION_ID = :app_id;

Resolving labels through the translation table joins AK_OBJECT_ATTRIBUTES_TL on the same three key columns. Reviewing defaulting and validation logic is common during upgrade or extension work in 12.1.1 and 12.2.2, where the editioning column ZD_EDITION_NAME must be considered in 12.2.2 queries to target the correct edition.

Related Objects

• AK_OBJECTS — parent object registry; joined on DATABASE_OBJECT_NAME.
• AK_ATTRIBUTES — attribute definitions; joined on ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID.
• AK_OBJECT_ATTRIBUTES_TL — translated label/description extension; joined on DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID.
• AK_OBJECT_ATTRIBUTE_NAVIGATION — navigation metadata for the attribute-on-object registration.
• OE_AK_OBJ_ATTR_EXT — Order Management extension mapping; joined on the same three key columns.
• ASO_APR_RULE_STEPS_B — Oracle Sales rules referencing attribute codes as LHS_AK_OBJECT and RHS_AK_OBJECT.