Search Results mtl_cycle_count_classes




Overview
Explore in AI Chat

Overview

The MTL_CYCLE_COUNT_CLASSES table is a core data object within the Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. It serves as a critical junction table that defines the relationship between cycle count headers and ABC classes. Its primary role is to enable the assignment of specific ABC classification criteria to a cycle count, thereby facilitating the automatic generation of cycle count schedules based on item value and usage. This table is fundamental to implementing ABC analysis within the cycle counting process, allowing organizations to prioritize counting efforts on high-value items (Class A) more frequently than lower-value items (Class C).

Key Information Stored

The table's structure centers on foreign key relationships that link several master entities. The primary key is a composite of ABC_CLASS_ID and CYCLE_COUNT_HEADER_ID, enforcing a unique combination of a classification and a specific count schedule. The most significant columns are these two foreign keys, which reference MTL_ABC_CLASSES and MTL_CYCLE_COUNT_HEADERS, respectively. Additional foreign key columns include ORGANIZATION_ID, linking to MTL_PARAMETERS to identify the inventory organization, and ABC_ASSIGNMENT_GROUP_ID, which references MTL_ABC_ASSIGNMENT_GROUPS to specify which group of item assignments the cycle count class rule applies to. The table itself is lean, primarily storing these relational identifiers rather than descriptive attributes, which are held in the parent tables.

Common Use Cases and Queries

The primary use case is the setup and maintenance of ABC-based cycle counting. A common operational query would retrieve all cycle count classes defined for a specific organization or a particular cycle count header to review the counting strategy. For reporting and audit purposes, one might join this table to its parents to produce a summary of ABC assignments per cycle count.

  • Sample Query: List Cycle Count Classes with Descriptions
    SELECT ccch.cycle_count_header_name, abc.abc_class_name, mccc.organization_id
    FROM inv.mtl_cycle_count_classes mccc,
    inv.mtl_cycle_count_headers ccch,
    inv.mtl_abc_classes abc
    WHERE mccc.cycle_count_header_id = ccch.cycle_count_header_id
    AND mccc.abc_class_id = abc.abc_class_id
    AND mccc.organization_id = :p_org_id
    ORDER BY 1, 2;
  • Integration Point: When a cycle count is generated automatically, the system uses the rules defined in this table, in conjunction with MTL_CYCLE_COUNT_HEADERS and item assignments from MTL_ABC_ASSIGNMENTS, to create specific count entries in MTL_CYCLE_COUNT_ITEMS.

Related Objects

As indicated by its foreign keys, MTL_CYCLE_COUNT_CLASSES has strong dependencies on several key Inventory tables. It is a child of MTL_CYCLE_COUNT_HEADERS (which defines the count schedule), MTL_ABC_CLASSES (which defines the classification codes like A, B, C), MTL_PARAMETERS (for the organization context), and MTL_ABC_ASSIGNMENT_GROUPS. Most importantly, it is a direct parent to the MTL_CYCLE_COUNT_ITEMS table. The foreign key from MTL_CYCLE_COUNT_ITEMS to this table (on ABC_CLASS_ID and CYCLE_COUNT_HEADER_ID) ensures that every automatically generated count item is traceable to a specific cycle-count-class rule. This relationship is central to the automated scheduling workflow within the Inventory module.