Skip to the content.

INV Transaction Upload – Oracle EBS SQL Report

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

Overview

INV Transaction Upload ====================== This upload can be used to create Inventory Material Transactions.

The following upload modes are supported:

Create – Generates an empty upload file. Transaction details must be entered manually. The Create mode always opens a blank Excel template, regardless of any parameter settings.

Create, Update – Based on the selected parameters, this mode can generate a pre-populated file with details such as item, primary unit of measure, and transaction date (defaulted to today’s date). It also displays the current on-hand quantity for each item, allowing users to transact against existing stock. Additionally, users can create new transactions by entering details manually

Note : – For “Account alias issue” transaction Type - Transaction Source needs to be selected for this Transaction Type, Don’t select Account Alias. – For “Account alias receipt” transaction Type - Transaction Source needs to be selected for this Transaction Type, Don’t select Account Alias. – For “Account issue” transaction Type - Distribution Account needs to be entered for this Transaction Type (or an Account Alias to default it), Don’t select Transaction Source. – For “Account receipt” transaction Type - Distribution Account needs to be entered for this Transaction Type (or an Account Alias to default it), Don’t select Transaction Source. – For “Intransit Shipment” transaction Type - Shipment Number is mandatory. Expected Receipt Date, Freight Code, Containers, Waybill Airbill, Transportation Cost, Transportation Account and Transfer Cost hold the remaining shipment details.

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, Category Set, Category, Item, Item Like, Item Description, Item Type, Item Status, BOM Item Type, Contract Item Type, Make or Buy, Buyer, Planner, Inventory Planning Method, Cross Reference Type, Cross Reference, Locator Control, Serial Number Control, Lot Control, Revision Control

Oracle EBS Tables Used

org_organization_definitions, mtl_system_items_vl, mtl_onhand_quantities_detail, mtl_item_locations_kfv, wms_license_plate_numbers

Report Categories

Enginatics, Upload

INV Cycle count listing, INV Onhand Quantities, INV Physical Inventory Locator Count Sheet, INV Cycle count entries and adjustments, INV Cycle counts pending approval, INV Items, WSH Pick Confirm Upload, INV Serial Numbers

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_Transaction_Upload.xml
SQL Source INV Transaction Upload.sql
Full Report on Enginatics www.enginatics.com/reports/inv-transaction-upload/

INV Transaction Upload - Case Study & Technical Analysis

Executive Summary

The INV Transaction Upload is a high-volume data entry tool for inventory movements. It allows users to perform miscellaneous receipts, issues, transfers, and account alias transactions in bulk via Excel. This is a critical tool for data migration, system cutovers, and handling large adjustments that are too tedious to enter manually.

Business Challenge

Manual data entry of inventory transactions is slow and error-prone.

Solution

The INV Transaction Upload provides a robust interface for bulk transaction processing. It validates the data against Oracle’s business rules before posting.

Key Features:

Technical Architecture

The tool uses the Oracle Inventory Interface tables (MTL_TRANSACTIONS_INTERFACE) to process the data.

Key Tables and Views

Core Logic

  1. Upload: Reads transaction details from Excel.
  2. Validation: Ensures the item exists in the org and the subinventory is valid.
  3. Interface Insert: Populates the interface tables.
  4. Processing: Launches the standard “Material Transaction Manager” to process the records.

Business Impact


© Enginatics GmbH