Results for “c_attribute20”

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

Overview

MTL_EAM_ATTR_VALUES is a transaction and reference table in the Inventory (INV) schema of Oracle E-Business Suite, holding the descriptive flexfield attribute values that qualify an enterprise asset instance. In Oracle EBS, an asset instance is uniquely identified by the combination of inventory item, serial number, and organization. The attribute values stored here allow organizations to capture maintenance-specific characteristics of that asset without altering the item master definition.

The table resides in the INV schema, which governs item, serial, and asset data across Enterprise Asset Management (EAM) and related maintenance flows. It is populated primarily through the asset definition and asset attribute entry screens in Oracle Enterprise Asset Management, and its records are consumed by work order, preventive maintenance, and condition monitoring functionality.

Based on the documented foreign key structure, the table can be characterized heuristically as a link table. It mediates among the item, serial number, and organization relationships that together identify an asset instance, while also storing descriptive attribute values. This classification is a modeling suggestion derived from the referenced keys rather than a formally declared Data Vault construct.

Key Information Stored

The primary key, MTL_EAM_ASSET_ATTR_VALUES_PK, is a composite three-column key comprising INVENTORY_ITEM_ID, SERIAL_NUMBER, and ATTRIBUTE_CATEGORY. Together these three columns constitute the business-key candidate as well as the physical primary key, distinguishing one attribute-category record per asset instance. No independent surrogate key is documented.

• INVENTORY_ITEM_ID — the item master identifier of the asset; part of the composite primary key.
• SERIAL_NUMBER — the serialized asset instance identifier; part of the composite primary key and a foreign key to MTL_SERIAL_NUMBERS.
• ORGANIZATION_ID — the inventory organization owning the asset; a foreign key to MTL_PARAMETERS.
• ATTRIBUTE_CATEGORY — the descriptive flexfield context or category; part of the composite primary key and the mechanism by which multiple attribute sets attach to one asset.
• ASSOCIATION_ID — an association identifier linking the attribute value record to its owning asset entity.
• C_ATTRIBUTE1 through C_ATTRIBUTE20 — twenty character flexfield segments for textual asset attributes.
• N_ATTRIBUTE1 through N_ATTRIBUTE10 — ten numeric flexfield segments for quantitative attributes such as meter readings or tolerance values.
• D_ATTRIBUTE1 through D_ATTRIBUTE10 — ten date flexfield segments for temporal attributes such as calibration or installation dates.
• DESCRIPTIVE_FLEXFIELD_NAME — identifies the flexfield definition that governs the attribute structure.
• APPLICATION_ID — the application owning the flexfield definition.
• MAINTENANCE_OBJECT_TYPE and MAINTENANCE_OBJECT_ID — identify the specific maintenance object that the attributes describe.
• Standard audit columns include LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN; concurrent program context is captured in PROGRAM_ID, PROGRAM_APPLICATION_ID, REQUEST_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

The table is typically queried to retrieve maintenance attributes for a specific asset, to report on assets matching attribute criteria, or to audit attribute configuration. A common pattern joins the table to the item and serial masters using the documented keys.

• Retrieve all attribute categories for an asset: filter on INVENTORY_ITEM_ID, SERIAL_NUMBER, and ORGANIZATION_ID, and return ATTRIBUTE_CATEGORY with the relevant C_, N_, or D_ segments.
• Report assets by numeric attribute value: select from MTL_EAM_ASSET_ATTR_VALUES where N_ATTRIBUTE1 exceeds a threshold, joined to the item master for descriptive context.
• Identify assets lacking attribute data: use an outer join from MTL_SERIAL_NUMBERS to this table and filter for null ATTRIBUTE_CATEGORY.
• Audit attribute maintenance: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY for changes within a period.
• Reporting by organization: group by ORGANIZATION_ID after joining to MTL_PARAMETERS for organization name resolution.

Because the descriptive flexfield columns are generic, reporting queries must resolve DESCRIPTIVE_FLEXFIELD_NAME and ATTRIBUTE_CATEGORY against FND_DESCRIPTIVE_FLEXS and the associated segment definitions to translate C_, N_, and D_ columns into meaningful labels.

Related Objects

• MTL_PARAMETERS — joined on ORGANIZATION_ID; supplies organization context and is a foreign key target.
• MTL_SERIAL_NUMBERS — joined on SERIAL_NUMBER and INVENTORY_ITEM_ID; the primary source of asset instance identity and a foreign key target.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID for item descriptions and EAM asset flags.
• MTL_EAM_ASSET_ATTR_CATEGORIES — defines the attribute categories referenced by ATTRIBUTE_CATEGORY.
• FND_DESCRIPTIVE_FLEXS — resolves DESCRIPTIVE_FLEXFIELD_NAME and APPLICATION_ID to the flexfield definition.
• MTL_EAM_WORK_ORDERS — consumes asset attribute values when generating maintenance work orders.
• MTL_EAM_ASSET_NUMBERS — provides the asset numbering context associated with the maintenance object.
• EAM_OBJECTS and related EAM views — expose attribute values for asset inquiry and reporting.

Collectively, these dependencies place MTL_EAM_ASSET_ATTR_VALUES at the intersection of inventory item definition, serialized asset tracking, and enterprise asset maintenance configuration in Oracle EBS 12.1.1 and 12.2.2.