Results for “mtl_cycle_count_classes”

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

Overview

The MTL_CYCLE_COUNT_CLASSES table is an Oracle Inventory (INV) foundational object that defines cycle count classes. It is the configuration and control table through which an organization instructs Oracle EBS how ABC class assignments should be counted and approved. Each row binds a cycle count header (a specific cycle count run or definition) to an ABC class, and it carries the counting frequency and the tolerance thresholds that govern whether a generated count entry is auto-approved, flagged for review, or rejected.

In modeling terms, the mined metadata suggests a satellite-leaning classification for this table. Its identity is composite: the primary key MTL_CYCLE_COUNT_CLASSES_PK is formed from ABC_CLASS_ID and CYCLE_COUNT_HEADER_ID, meaning the row describes the intersection of a count header and a class rather than holding a single surrogate identifier. Because it stores descriptive and behavioral attributes (tolerances, counts per year) tied to those keys, it behaves less like a transactional fact and more like a configuration satellite attached to the cycle count header and ABC class dimensions.

Key Information Stored

The table documents twenty columns in Oracle EBS 12.2.2, with the most operationally significant listed here.

• ABC_CLASS_ID and CYCLE_COUNT_HEADER_ID — together the primary key. They identify which ABC class is being counted within a given cycle count header.
• ORGANIZATION_ID — the inventory organization that owns the definition. It is a required part of the unique business key and references MTL_PARAMETERS.
• NUM_COUNTS_PER_YEAR — the frequency, in counts per year, at which the ABC class must be counted. This drives cycle count scheduling.
• APPROVAL_TOLERANCE_POSITIVE and APPROVAL_TOLERANCE_NEGATIVE — quantity variance bands within which a count is automatically approved.
• COST_TOLERANCE_POSITIVE and COST_TOLERANCE_NEGATIVE — value-based variance bands used for approval decisions.
• HIT_MISS_TOLERANCE_POSITIVE and HIT_MISS_TOLERANCE_NEGATIVE — thresholds applied to hit/miss count analysis.
• ABC_ASSIGNMENT_GROUP_ID — links the row to the assignment group that determines which items fall into the class.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — concurrent program audit columns recording the process that last touched the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — standard EBS audit trail columns.

The unique index MTL_CYCLE_COUNT_CLASSES_U1 on (ORGANIZATION_ID, CYCLE_COUNT_HEADER_ID, ABC_CLASS_ID) is the documented business-key candidate, guaranteeing that a given class is counted only once per header within an organization.

Common Use Cases and Queries

Typical uses include cycle count scheduling, tolerance configuration review, and variance approval analysis. A common query returns the counting frequency and approval bands for a given organization and header:

• Retrieve all classes defined for a cycle count header: SELECT ABC_CLASS_ID, NUM_COUNTS_PER_YEAR, APPROVAL_TOLERANCE_POSITIVE, APPROVAL_TOLERANCE_NEGATIVE FROM MTL_CYCLE_COUNT_CLASSES WHERE ORGANIZATION_ID = :org_id AND CYCLE_COUNT_HEADER_ID = :header_id;
• Join to MTL_ABC_CLASSES to display class names alongside frequency for scheduling reports.
• Compare configured tolerances across organizations to audit inconsistent approval policies.
• Identify classes with low NUM_COUNTS_PER_YEAR that may require tighter audit coverage.

Related Objects

• MTL_CYCLE_COUNT_HEADERS — referenced via CYCLE_COUNT_HEADER_ID; supplies the count header definition.
• MTL_ABC_CLASSES — referenced via ABC_CLASS_ID; provides the ABC class definition.
• MTL_PARAMETERS — referenced via ORGANIZATION_ID; defines the inventory organization.
• MTL_ABC_ASSIGNMENT_GROUPS — referenced via ABC_ASSIGNMENT_GROUP_ID; controls item-to-class assignment.
• MTL_CYCLE_COUNT_ITEMS — references this table through ABC_CLASS_ID and CYCLE_COUNT_HEADER_ID; holds the individual count entries governed by these class settings.