Results for “mtl_cycle_count_items”

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

Overview

MTL_CYCLE_COUNT_ITEMS is an Oracle Inventory (INV) base table that defines the individual inventory items scheduled for cycle counting within a given cycle count header. In Oracle EBS 12.1.1 and 12.2.2, cycle counting is a continuous physical inventory verification process that classifies items—typically through ABC analysis—so that high-value or high-velocity items are counted more frequently than low-value ones. MTL_CYCLE_COUNT_ITEMS is the intersection entity that binds a specific INVENTORY_ITEM_ID to a specific CYCLE_COUNT_HEADER_ID, and it carries the operational attributes (ABC class, scheduling sequence, last schedule date, approval tolerances) that drive how and when each item is counted.

From a dimensional-modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification, with a possible link interpretation. It functions primarily as an attribute-bearing child of the cycle count header, not as a standalone hub for items or headers.

Key Information Stored

The table contains 33 documented columns. The composite primary key MTL_CYCLE_COUNT_ITEMS_PK is defined on (CYCLE_COUNT_HEADER_ID, INVENTORY_ITEM_ID). The most significant columns include:

• CYCLE_COUNT_HEADER_ID — FK to MTL_CYCLE_COUNT_HEADERS; identifies the parent cycle count definition.
• INVENTORY_ITEM_ID — FK to the item master; the item being counted.
• ABC_CLASS_ID — references MTL_ABC_CLASSES / MTL_CYCLE_COUNT_CLASSES; determines count frequency.
• ITEM_LAST_SCHEDULE_DATE — date the item was last scheduled for counting.
• SCHEDULE_ORDER — sequence used when generating count schedules.
• APPROVAL_TOLERANCE_POSITIVE / APPROVAL_TOLERANCE_NEGATIVE — variance thresholds for auto-approval of count adjustments.
• CONTROL_GROUP_FLAG — indicates whether the item belongs to a control group.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program audit columns.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — DFF/descriptive flexfield segments.

The unique indexes MTL_CYCLE_COUNT_ITEMS_U1 (CYCLE_COUNT_HEADER_ID, INVENTORY_ITEM_ID) and MTL_CYCLE_COUNT_ITEMS_U2 (CYCLE_COUNT_HEADER_ID, ABC_CLASS_ID, INVENTORY_ITEM_ID) are business-key candidates.

Common Use Cases and Queries

Typical uses include listing items within a count header, driving the "Generate Cycle Count Schedules" concurrent program, reporting count frequencies by ABC class, and reviewing approval tolerances.

SELECT mcci.inventory_item_id, mcci.abc_class_id,
       mcci.item_last_schedule_date, mcci.schedule_order
FROM   mtl_cycle_count_items mcci
WHERE  mcci.cycle_count_header_id = :header_id
ORDER BY mcci.schedule_order;

Joining to the header and item master supports cycle count reporting:

SELECT mch.cycle_count_header_name, msi.segment1 item_number,
       mcci.abc_class_id, mcci.item_last_schedule_date
FROM   mtl_cycle_count_items mcci,
       mtl_cycle_count_headers mch,
       mtl_system_items_b msi
WHERE  mcci.cycle_count_header_id = mch.cycle_count_header_id
AND    mcci.inventory_item_id = msi.inventory_item_id
AND    msi.organization_id = :org_id;

Related Objects

• MTL_CYCLE_COUNT_HEADERS — parent header; join on CYCLE_COUNT_HEADER_ID.
• MTL_ABC_CLASSES — ABC class definition; join on ABC_CLASS_ID.
• MTL_CYCLE_COUNT_CLASSES — cycle count class definition; join on ABC_CLASS_ID.
• MTL_CC_SCHEDULE_REQUESTS — schedule request lines; references (CYCLE_COUNT_HEADER_ID, INVENTORY_ITEM_ID).
• MTL_SYSTEM_ITEMS_B — item master; join on INVENTORY_ITEM_ID plus ORGANIZATION_ID.
• MTL_CYCLE_COUNT_ENTRIES — recorded count entries generated from scheduled items.
• INV_CYCLE_COUNT_PUB / INV_ABC_ASSIGNMENT_PUB — public APIs governing cycle count scheduling and ABC assignment.