Results for “mtl_abc_assgn_group_classes”

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

Overview

MTL_ABC_ASSGN_GROUP_CLASSES is an Inventory (INV) application table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines the membership relationship between ABC assignment groups and ABC classes. The table answers a single structural question: which ABC classes belong to which ABC assignment group. Each row associates one ABC class with one assignment group, and the combination of the two identifiers is guaranteed unique by the MTL_ABC_ASSGN_GROUP_CLASSES_U1 unique index (ASSIGNMENT_GROUP_ID, ABC_CLASS_ID).

ABC classification in Oracle Inventory is used to stratify inventory items by annualized usage value so that cycle counting frequency and planning attention can be calibrated to item importance. Assignment groups provide the container that scopes a classification exercise (for example, by organization or by a specific compile run), while ABC classes supply the discrete buckets (typically A, B, C, and sometimes D) into which items fall. This table is the bridge that makes those buckets available within a given group, and it also carries the threshold metrics used by the ABC compile to determine class boundaries.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table is keyed on two foreign keys rather than a single independent business key, and its non-key descriptive payload (sequence, percentages, attributes) changes over time, which is characteristic of satellite behavior attached to the group/class link. Practitioners modeling this data in a warehouse should treat the group-class pair as the link, with the threshold and audit columns as satellite attributes.

Key Information Stored

The primary key of the table is defined as MTL_ABC_ASSGN_GROUP_CLASSE_PK1, spanning ASSIGNMENT_GROUP_ID and ABC_CLASS_ID. The same two columns form the unique business-key candidate MTL_ABC_ASSGN_GROUP_CLASSES_U1. The most significant columns are:

• ASSIGNMENT_GROUP_ID — foreign key to MTL_ABC_ASSIGNMENT_GROUPS; identifies the parent ABC assignment group.
• ABC_CLASS_ID — foreign key to MTL_ABC_CLASSES; identifies the ABC class being assigned to the group.
• SEQUENCE_NUMBER — ordering sequence in which classes are evaluated or displayed within the group.
• ITEM_SEQ_NUMBER — sequence value used during the ABC compile to rank items against class boundaries.
• PERCENT_OF_ITEMS — target or computed percentage of items that should fall into the class.
• PERCENT_OF_VALUE — target or computed percentage of annualized value attributed to the class.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context identifying the request and program that last populated or updated the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard EBS who-columns used for auditing and incremental extraction.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns available for site-specific extension.

The 30 documented columns therefore divide cleanly into two surrogate/business keys, two boundary metric columns, a sequence pair, concurrent program context, audit columns, and the DFF block.

Common Use Cases and Queries

Typical reporting scenarios include listing all classes configured for a given assignment group, comparing the configured PERCENT_OF_VALUE thresholds against actual compiled results, and identifying groups where class definitions are incomplete or duplicate.

A representative query joining the parent group and the class definition is:

• SELECT g.ASSIGNMENT_GROUP_ID, g.GROUP_NAME, c.ABC_CLASS_ID, c.CLASS_NAME, a.SEQUENCE_NUMBER, a.PERCENT_OF_ITEMS, a.PERCENT_OF_VALUE FROM MTL_ABC_ASSGN_GROUP_CLASSES a, MTL_ABC_ASSIGNMENT_GROUPS g, MTL_ABC_CLASSES c WHERE a.ASSIGNMENT_GROUP_ID = g.ASSIGNMENT_GROUP_ID AND a.ABC_CLASS_ID = c.ABC_CLASS_ID ORDER BY g.ASSIGNMENT_GROUP_ID, a.SEQUENCE_NUMBER;

To reconcile configured thresholds against the items actually classified, join outward to MTL_ABC_ASSIGNMENTS using both ASSIGNMENT_GROUP_ID and ABC_CLASS_ID, since that table references this one on the full group-class pair. Incremental extracts for a warehouse can filter on LAST_UPDATE_DATE and REQUEST_ID, which is the standard pattern for EBS interface tables and setup tables alike. Setup-validation queries should confirm that every active assignment group has at least one class row, and that SEQUENCE_NUMBER values are contiguous.

Related Objects

The most significant related objects, based on the documented foreign key relationships, are:

• MTL_ABC_ASSIGNMENT_GROUPS — parent of this table via ASSIGNMENT_GROUP_ID; holds the group definition that scopes the classification.
• MTL_ABC_CLASSES — referenced via ABC_CLASS_ID; holds the class name, description, and class-level defaults.
• MTL_ABC_ASSIGNMENTS — references this table on ASSIGNMENT_GROUP_ID and ABC_CLASS_ID; stores the compiled assignment of individual items to a class within a group, and is the primary transactional consumer of this setup data.
• MTL_SYSTEM_ITEMS_B — the item master providing the items that ultimately receive ABC classes through MTL_ABC_ASSIGNMENTS.
• MTL_PARAMETERS — organization-level inventory parameters that govern ABC compile behavior and cycle count defaults driven by the resulting classes.
• MTL_CYCLE_COUNT_CLASSES — cycle count class definitions frequently linked to ABC classes to drive count frequency.

Updates to this table should be performed through the Inventory ABC analysis and compile setup forms rather than by direct DML, so that the concurrent program context columns and dependent MTL_ABC_ASSIGNMENTS rows remain consistent.