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, INV Items
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 | None |
| 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