Results for “mtl_abc_assignment_groups”

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

Overview

MTL_ABC_ASSIGNMENT_GROUPS is an Inventory (INV) module table within Oracle E-Business Suite 12.1.1 and 12.2.2. It defines ABC assignment groups, the organizational containers used to scope and control ABC classification and cycle counting activity. An ABC assignment group establishes the parameters under which inventory items are analyzed and partitioned into ABC classes (typically A, B, and C) based on their transaction velocity or value. Each group links to an inventory organization, optionally to a secondary inventory, and to the compilation run that produced its classifications.

Because it stores stable, descriptive state about a classification grouping rather than transaction events, the heuristic Data Vault classification supplied in the metadata is hub. In a Data Vault model this would be treated as a hub entity keyed on ASSIGNMENT_GROUP_ID, with organization and naming attributes potentially distributed to satellites. This is a modeling suggestion; the physical table is a conventional normalized master table in the INV schema, owned by INV, with 31 documented columns.

Key Information Stored

The table's surrogate primary key is ASSIGNMENT_GROUP_ID, enforced by the unique index MTL_ABC_ASSIGNMENT_GROUPS_PK. Two business-key candidates are documented. MTL_ABC_ASSIGNMENT_GROUPS_U1 enforces uniqueness on ASSIGNMENT_GROUP_ID alone, while MTL_ABC_ASSIGNMENT_GROUPS_U2 enforces the natural composite business key of ORGANIZATION_ID and ASSIGNMENT_GROUP_NAME, meaning a group name must be unique within its inventory organization.

• ASSIGNMENT_GROUP_ID — surrogate primary key that identifies the group and is referenced by all dependent ABC and cycle count tables.
• ASSIGNMENT_GROUP_NAME — user-defined name of the ABC assignment group, unique within an organization.
• ORGANIZATION_ID — the inventory organization that owns the group; foreign key to MTL_PARAMETERS.
• SECONDARY_INVENTORY — optionally restricts the group's scope to a specific subinventory; foreign key to MTL_SECONDARY_INVENTORIES.
• COMPILE_ID — links the group to the ABC compile run that generated or refreshed its classifications; foreign key to MTL_ABC_COMPILE_HEADERS.
• ITEM_SCOPE_TYPE — defines how items are selected into the group's scope (for example, all items versus a defined subset).
• CLASSIFICATION_METHOD_TYPE — identifies the method used to classify items into ABC classes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns for user-defined extensions.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program and request audit context for the last process that touched the row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard WHO audit columns.

Common Use Cases and Queries

The primary operational use is defining and reviewing ABC assignment groups before running ABC classification or cycle count generation. Typical reporting includes listing active groups per organization, identifying groups tied to a particular secondary inventory, or tracing which compile run last refreshed a group.

• List all ABC assignment groups for an organization:

SELECT assignment_group_id, assignment_group_name, organization_id,
       secondary_inventory, item_scope_type, classification_method_type
FROM   mtl_abc_assignment_groups
WHERE  organization_id = :org_id;

• Join to MTL_ABC_ASSIGNMENTS to report how many items fall in each group and class.
• Join to MTL_ABC_COMPILE_HEADERS to verify which compile run produced current classifications.
• Identify groups referenced by MRP parameters as the default ABC assignment group.
• Audit stale groups by evaluating LAST_UPDATE_DATE and PROGRAM_UPDATE_DATE.

Related Objects

MTL_ABC_ASSIGNMENT_GROUPS is a hub referenced by several dependent tables and itself references organizational and compile metadata. The most significant related objects follow.

• MTL_PARAMETERS — joined on ORGANIZATION_ID; supplies inventory organization context.
• MTL_SECONDARY_INVENTORIES — joined on ORGANIZATION_ID and SECONDARY_INVENTORY; defines optional subinventory scope.
• MTL_ABC_COMPILE_HEADERS — joined on COMPILE_ID; the parent compile run for the group's classifications.
• MTL_ABC_ASSGN_GROUP_CLASSES — references ASSIGNMENT_GROUP_ID; defines the ABC classes belonging to each group.
• MTL_ABC_ASSIGNMENTS — references ASSIGNMENT_GROUP_ID; stores per-item ABC class assignments.
• MTL_CYCLE_COUNT_HEADERS — references ABC_ASSIGNMENT_GROUP_ID; links cycle count runs to the governing group.
• MTL_CYCLE_COUNT_CLASSES — references ABC_ASSIGNMENT_GROUP_ID; defines count classes per group.
• MRP_PARAMETERS — references DEFAULT_ABC_ASSIGNMENT_GROUP; identifies the default group used by planning.
• WMS_SELECTION_CRITERIA_TXN — references ASSIGNMENT_GROUP_ID where Warehouse Management is deployed.

These relationships confirm the table's role as a central grouping hub for both ABC analysis and cycle counting across the Inventory and planning modules.