Results for “assignment_group_id”

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

Overview

MTL_ABC_ASSIGNMENTS is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that assigns inventory items to ABC classes within an ABC assignment group. ABC analysis classifies items by transaction volume or value so that cycle counting frequency, physical inventory scope, and replenishment controls can be applied selectively to high-value, medium-value, and low-value inventory. Each row in MTL_ABC_ASSIGNMENTS represents a single item-to-class linkage, giving the table a pure intersection structure with no descriptive attributes of its own beyond the standard 11 Who columns used for audit and concurrent program tracking.

The ETRM Data Vault classification heuristic identifies this object as a link. This is a modeling suggestion rather than a property of the EBS table itself: the row resolves a many-to-many relationship between items, assignment groups, and ABC classes, and carries only the mandatory key and audit data expected of a link construct. It contains no independent descriptive payload, which distinguishes it from a satellite.

Key Information Stored

The composite primary key, enforced by MTL_ABC_ASSIGNMENTS_PK, consists of INVENTORY_ITEM_ID, ASSIGNMENT_GROUP_ID, and ABC_CLASS_ID. A separate unique index, MTL_ABC_ASSIGNMENTS_U1, covers ASSIGNMENT_GROUP_ID and INVENTORY_ITEM_ID, which is the practical business-key candidate: the rule that a given item may belong to only one ABC class within a given assignment group is enforced here rather than by the primary key.

• INVENTORY_ITEM_ID — identifier of the item in MTL_SYSTEM_ITEMS_B being classified.
• ASSIGNMENT_GROUP_ID — the ABC assignment group that scopes the classification; groups allow separate ABC schemes for different organizations or inventory segments.
• ABC_CLASS_ID — the ABC class (for example A, B, or C) to which the item is assigned within that group.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard auditing columns recording who created and last modified the assignment.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — traceability columns populated when the assignment is created or refreshed by the ABC assignment compile concurrent program.

Because assignments are generally regenerated by the ABC compile process rather than maintained manually, the concurrent request columns are the principal mechanism for auditing how and when a given classification was produced.

Common Use Cases and Queries

Typical reporting needs include listing all items in a class for a group, verifying that every active item received a classification, and driving cycle count schedules by class. A representative query joins the assignment table to the item master and to the class definition:

• Listing assignments for one group: SELECT inventory_item_id, abc_class_id FROM mtl_abc_assignments WHERE assignment_group_id = :p_group_id.
• Counting items per class to validate compile results: SELECT abc_class_id, COUNT(*) FROM mtl_abc_assignments WHERE assignment_group_id = :p_group_id GROUP BY abc_class_id.
• Identifying unclassified items: an outer join from the organization item master to MTL_ABC_ASSIGNMENTS where the assignment key is null.
• Auditing compile runs: filtering on REQUEST_ID to isolate rows produced by a specific compile, useful when investigating unexpected reclassification.

Circular reporting is another common consumer: because classifications may change between compiles, historical extracts should be staged rather than queried directly at report time.

Related Objects

• MTL_ABC_ASSIGNMENT_GROUPS — joined on ASSIGNMENT_GROUP_ID; defines the assignment group header.
• MTL_ABC_CLASSES — joined on ABC_CLASS_ID; holds the class definition and its sequence or ranking.
• MTL_ABC_ASSGN_GROUP_CLASSES — joined on ASSIGNMENT_GROUP_ID and ABC_CLASS_ID; defines which classes are valid within a given group.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID; supplies item descriptions and status.
• MTL_ITEM_LOCATIONS / MTL_ONHAND_QUANTITIES — commonly combined with class assignments for cycle count and valuation reporting.

No public PL/SQL API owns this table directly; assignments are populated by the ABC compile concurrent program, and consumers should treat the rows as derived data.