Skip to the content.

INV Cycle count unscheduled items – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Inventory · all Inventory reports

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

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

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, xxen_report_org_access

Report Categories

Enginatics, R12 only

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, INV Items, INV Item Upload, INV Item Upload 11i, INV Cycle count schedule requests

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import INV_Cycle_count_unscheduled_items.xml
SQL Source INV Cycle count unscheduled items.sql
Full Report 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

Technical Analysis

Core Tables

Key Joins & Logic

Key Parameters


© Enginatics GmbH