Results for “mtl_eam_asset_attr_groups”

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

Overview

MTL_EAM_ASSET_ATTR_GROUPS is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores asset attribute group definitions used by Oracle Enterprise Asset Management (EAM). The table associates an inventory item within a specific organization with a descriptive flexfield context, allowing organizations to attach supplementary, user-defined attribute groups to asset items. This mechanism enables EAM users to capture non-standard asset characteristics—such as warranty terms, location details, or maintenance classifications—beyond the standard item master columns.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link table. It resolves relationships between independent business entities: an organization, an inventory item, and a descriptive flexfield context. It is not a pure hub (it carries no single natural business key) nor a satellite (it references multiple hubs simultaneously), so the link classification is the appropriate modeling suggestion.

Key Information Stored

The table contains 13 documented columns. The surrogate primary key is ASSOCIATION_ID, enforced by constraint MTL_EAM_ASSET_ATTR_GROUPS_PK. A unique index, MTL_EAM_ASSET_ATTR_GROUPS_U1, also exists on ASSOCIATION_ID, making it the documented business-key candidate as well.

• ASSOCIATION_ID – Surrogate primary key uniquely identifying each asset attribute group association.
• ORGANIZATION_ID – The inventory organization owning the asset; references MTL_PARAMETERS.
• INVENTORY_ITEM_ID – The asset item to which the attribute group applies; references MTL_SYSTEM_ITEMS_B.
• APPLICATION_ID – Identifies the application owning the descriptive flexfield; part of the FK to FND_DESCR_FLEX_CONTEXTS.
• DESCRIPTIVE_FLEXFIELD_NAME – The descriptive flexfield (DFF) name providing the attribute structure.
• DESCRIPTIVE_FLEX_CONTEXT_CODE – The specific flexfield context segment selected for this asset.
• ENABLED_FLAG – Indicates whether the attribute group association is active.
• CREATION_ORGANIZATION_ID – The organization in which the record was originally created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard EBS audit columns tracking who created and last modified the row.

Common Use Cases and Queries

Typical uses include reporting which assets have attribute groups defined, validating DFF context assignments, and migrating attribute configurations between environments. A common query joins to the item master and organization parameters:

• Inventory of asset attribute groups by organization: SELECT a.ASSOCIATION_ID, a.INVENTORY_ITEM_ID, a.DESCRIPTIVE_FLEXFIELD_NAME, a.DESCRIPTIVE_FLEX_CONTEXT_CODE FROM MTL_EAM_ASSET_ATTR_GROUPS a WHERE a.ORGANIZATION_ID = :org_id AND a.ENABLED_FLAG = 'Y';
• Join to MTL_SYSTEM_ITEMS_B to resolve item names and descriptions.
• Join to FND_DESCR_FLEX_CONTEXTS to retrieve context prompt and display information.
• Confirm correct DFF context usage across organizations for data-governance reporting.

Related Objects

• MTL_PARAMETERS – joined on ORGANIZATION_ID; defines the inventory organization.
• MTL_SYSTEM_ITEMS_B – joined on INVENTORY_ITEM_ID and ORGANIZATION_ID; holds the asset item master.
• FND_DESCR_FLEX_CONTEXTS – joined on APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and DESCRIPTIVE_FLEX_CONTEXT_CODE; defines the flexfield context.
• FND_DESCRIPTIVE_FLEXS – describes the flexfield itself; useful for context reporting.
• MTL_EAM_ASSET_ATTR_VALUES (where present) – stores the actual attribute values associated with these groups.