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 - Account Alias needs to be selected for this Transaction Type, Don’t select Transaction Source. – For “Account receipt” transaction Type - Account Alias needs to be selected for this Transaction Type, Don’t select Transaction Source.

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, R12 only, Upload

INV Cycle count listing, INV Onhand Quantities, INV Cycle count entries and adjustments, INV Cycle counts pending approval, INV Item Upload, INV Items, INV Cycle count open requests listing, CAC Inventory Lot and Locator OPM Value (Period-End)

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_Transaction_Upload.xml
Full SQL 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

© 2026 Enginatics