Search Results mtl_abc_assignment_groups




Overview
Explore in AI Chat

Overview

The MTL_ABC_ASSIGNMENT_GROUPS table is a core data object within the Oracle E-Business Suite Inventory (INV) module. It serves as the master definition table for ABC Assignment Groups, which are logical containers used to classify inventory items based on their activity value, such as annual usage or transaction volume. These groups are fundamental to executing ABC analysis, a critical inventory management technique for prioritizing cycle counting efforts, setting service levels, and focusing management attention on high-value items. The table's integrity is maintained through a primary key and multiple foreign key relationships that enforce data consistency across the inventory and manufacturing applications.

Key Information Stored

The table's primary identifier is the ASSIGNMENT_GROUP_ID. Each record is scoped to a specific inventory organization via the ORGANIZATION_ID column. The COMPILE_ID links the group to a specific ABC analysis compilation run stored in MTL_ABC_COMPILE_HEADERS. The group is also associated with a specific subinventory through the SECONDARY_INVENTORY column. Other descriptive columns, such as the group name and description, are stored to facilitate user identification and reporting. The primary key constraint MTL_ABC_ASSIGNMENT_GROUPS_PK ensures the uniqueness of each ASSIGNMENT_GROUP_ID.

Common Use Cases and Queries

A primary use case is identifying the default ABC assignment group for an organization, particularly in the context of Material Requirements Planning (MRP), as indicated by the foreign key from MRP_PARAMETERS. A common query retrieves all assignment groups for a given organization to support setup or audit activities. For example:

  • SELECT assignment_group_id, assignment_group_name, compile_id FROM inv.mtl_abc_assignment_groups WHERE organization_id = :p_org_id;

Another critical scenario involves tracing the items assigned to a specific group for cycle counting purposes. This requires joining to the MTL_ABC_ASSIGNMENTS table using the ASSIGNMENT_GROUP_ID. Reporting often focuses on the relationship between compiled ABC classes (MTL_ABC_ASSGN_GROUP_CLASSES) and the groups to which they belong, analyzing the distribution of items across A, B, and C categories within each logical group.

Related Objects

The table maintains documented foreign key relationships with several key Inventory and Manufacturing objects, as per the provided metadata:

  • MTL_PARAMETERS: Links via ORGANIZATION_ID to define the inventory organization.
  • MTL_ABC_COMPILE_HEADERS: Links via COMPILE_ID to the specific ABC compilation.
  • MTL_SECONDARY_INVENTORIES: Links via SECONDARY_INVENTORY and ORGANIZATION_ID to the subinventory.
  • MRP_PARAMETERS: Referenced by MRP_PARAMETERS.DEFAULT_ABC_ASSIGNMENT_GROUP to define a default group for planning.
  • MTL_ABC_ASSGN_GROUP_CLASSES: Child table holding the specific A, B, and C class definitions for the group.
  • MTL_ABC_ASSIGNMENTS: Child table storing the individual item assignments to this group.
  • MTL_CYCLE_COUNT_HEADERS & MTL_CYCLE_COUNT_CLASSES: Referenced to associate cycle count processes with a specific ABC assignment group.