INV Cycle count unscheduled items – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Imported Oracle standard Cycle count unscheduled items report Source: Cycle count unscheduled items report (XML) Short Name: INVARUIR_XML DB package: INV_INVARUIR_XMLP_PKG
Report Parameters
Organization Code, Cycle Count Name
Oracle EBS Tables Used
mfg_lookups, mtl_abc_classes, mtl_system_items_vl, mtl_cycle_count_headers, mtl_cycle_count_items, mtl_cycle_count_classes, org_organization_definitions, gl_ledgers, org_access_view
Report Categories
Related Reports
INV Cycle count hit/miss analysis, INV Cycle count open requests listing, INV Cycle count listing, INV Cycle count entries and adjustments, INV Cycle counts pending approval, CAC Deferred COGS Out-of-Balance, CAC Recost Cost of Goods Sold, INV Item Upload
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | |
| Blitz Report™ XML Import | INV_Cycle_count_unscheduled_items.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-cycle-count-unscheduled-items/ |
INV Cycle count unscheduled items - Case Study & Technical Analysis
Executive Summary
The INV Cycle count unscheduled items report identifies items that are part of a cycle count definition (header) but have not been scheduled for counting within a specific timeframe. This is a “gap analysis” report used to ensure that no items are falling through the cracks of the cycle counting process, which is critical for maintaining 100% inventory coverage over the course of a year.
Business Use Cases
- Coverage Verification: Ensures that every item in the warehouse is being counted at least once per year (or as defined by its ABC class).
- Scheduler Troubleshooting: If the auto-scheduler is running but items aren’t appearing on count sheets, this report helps identify which items are being skipped.
- New Item Audit: Verifies that newly created items have been properly picked up by the cycle count logic.
Technical Analysis
Core Tables
MTL_CYCLE_COUNT_ITEMS: The list of items eligible for the cycle count.MTL_CC_SCHEDULE_REQUESTS: The table checked to see if a schedule exists.MTL_CYCLE_COUNT_HEADERS: The cycle count definition.
Key Joins & Logic
- Exclusion Logic: The report selects items from
MTL_CYCLE_COUNT_ITEMSwhere there is NO corresponding record inMTL_CC_SCHEDULE_REQUESTS(orMTL_CYCLE_COUNT_ENTRIES) for the given period. - Class Logic: It often groups by ABC class to show, for example, “Which ‘A’ items haven’t been counted this month?”.
Key Parameters
- Cycle Count Name: The specific count definition.
- Organization Code: The inventory organization.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics