Results for “validation_code”

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

Overview

MTL_ITEM_ATTRIBUTES is an Oracle Inventory (INV) base table that defines and describes the attributes used in the Oracle E-Business Suite item master. Each row corresponds to a single item attribute — such as a descriptive, physical, or planning characteristic — and carries the metadata that controls how that attribute is presented, validated, and maintained for every item defined in the inventory organization model. The table therefore acts as the dictionary of item attributes rather than as the attribute values themselves, which reside on the item-level attribute tables.

The object is owned by the INV schema and is documented across Oracle EBS 12.1.1 and 12.2.2. From a data-vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification, because MTL_ITEM_ATTRIBUTES is the referenced parent for multiple dependent tables keyed by ATTRIBUTE_NAME. This is a heuristic suggestion rather than a formal Data Vault designation.

Key Information Stored

The table comprises 24 documented columns. The most significant are the following:

• ATTRIBUTE_NAME — the internal identifier of the attribute; the primary business-key candidate, appearing in unique index MTL_ITEM_ATTRIBUTES_U1 alongside ZD_EDITION_NAME, and also in the primary key constraint.
• USER_ATTRIBUTE_NAME — the user-facing display name of the attribute.
• USER_ATTRIBUTE_NAME_GUI — the name of the attribute as rendered in the graphical user interface.
• ATTRIBUTE_GROUP_ID — the attribute group to which the attribute belongs.
• ATTRIBUTE_GROUP_ID_GUI — the attribute group identifier used by the GUI layer.
• CONTROL_LEVEL — controls whether the attribute is maintained at master, organization, or subinventory level.
• DATA_TYPE — the data type of the attribute value.
• SEQUENCE and SEQUENCE_GUI — the display ordering of the attribute in the attribute group.
• LEVEL_UPDATEABLE_FLAG — indicates whether the attribute can be updated at its assigned control level.
• STATUS_CONTROL_CODE — the status-control behavior associated with the attribute.
• VALIDATION_CODE — the validation rule applied to entered values.
• PREFIELD_FLAG, POST_CHANGE_FLAG, POST_FIELD_FLAG, MANDATORY_FLAG — behavioral flags governing defaulting, posting, and whether a value is required.
• UPDATE_MESSAGE_NAME and REQUIRED_MESSAGE_NAME — messages surfaced on update or when a required value is missing.
• ZD_EDITION_NAME — supports edition-based redefinition in the 12.2 online patching model, and forms part of the unique key.

Standard audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — are also present.

Common Use Cases and Queries

The table is typically joined to dependent tables by ATTRIBUTE_NAME. A representative pattern retrieves the attributes applicable to a template:

• Join MTL_ITEM_TEMPL_ATTRIBUTES to MTL_ITEM_ATTRIBUTES ON ATTRIBUTE_NAME to list template-level attribute definitions.
• Join MTL_ATTR_APPL_DEPENDENCIES ON ATTRIBUTE_NAME to identify attribute application dependencies.
• Join MTL_STATUS_ATTRIBUTE_VALUES ON ATTRIBUTE_NAME to resolve status-driven valid value lists.
• Report attribute groups and display sequencing by selecting ATTRIBUTE_GROUP_ID, USER_ATTRIBUTE_NAME, and SEQUENCE.
• Identify mandatory or validated attributes using MANDATORY_FLAG, VALIDATION_CODE, and STATUS_CONTROL_CODE.

Typical reporting includes item master attribute dictionaries, template configuration analysis, and validation of organization-level attribute control. Queries should account for ZD_EDITION_NAME when run against 12.2.x environments.

Related Objects

• MTL_ITEM_TEMPL_ATTRIBUTES — references ATTRIBUTE_NAME; defines attributes attached to item templates.
• MTL_ATTR_APPL_DEPENDENCIES — references ATTRIBUTE_NAME; records attribute application dependencies.
• MTL_STATUS_ATTRIBUTE_VALUES — references ATTRIBUTE_NAME; maps status values to attribute constraints.

These relationships confirm MTL_ITEM_ATTRIBUTES as the referenced parent for attribute-driven configuration across the Oracle Inventory item master.