INV Cycle Count Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Enters counts for open cycle count requests and unscheduled counts, as the Cycle Count Entries window (Inventory > Counting > Cycle Counting > Cycle Count Entries).

Download the open count requests of a cycle count, enter Count Quantity, Counted By and Count Date, and upload. The counts are processed by the cycle count open interface api: counts within the approval tolerances are adjusted right away, others go to Pending Approval or Recount according to the cycle count setup. Count Date must be in an open inventory period.

New rows without a count request create an unscheduled count, where the cycle count allows unscheduled entries. Approving counts is done in the Approve Adjustments window.

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

Upload Mode, Organization Code, Cycle Count, Subinventory, Item, Include Recounts

Oracle EBS Tables Used

mtl_item_locations_kfv, mtl_transaction_reasons, mtl_employees_current_view, gl_code_combinations_kfv, mtl_cycle_count_entries, mtl_parameters, mtl_cycle_count_headers, mtl_system_items_vl, org_access_view

Report Categories

Enginatics, R12 only, Upload

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_Upload.xml
SQL Source INV Cycle Count Upload.sql
Full Report on Enginatics www.enginatics.com/reports/inv-cycle-count-upload/

© Enginatics GmbH