| layout | default |
|---|---|
| title | INV Transaction Upload | Oracle EBS SQL Report |
| description | INV Transaction Upload ====================== This upload can be used to create Inventory Material Transactions. The following upload modes are supported… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Upload, INV, Transaction, org_organization_definitions, mtl_system_items_vl, mtl_onhand_quantities_detail |
| permalink | /INV%20Transaction%20Upload/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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.
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
org_organization_definitions, mtl_system_items_vl, mtl_onhand_quantities_detail, mtl_item_locations_kfv, wms_license_plate_numbers
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)
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.
| 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/ |
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.
Manual data entry of inventory transactions is slow and error-prone.
- Data Migration: "We are going live on Monday and need to load the opening balances for 50,000 items."
- Adjustments: "The auditors found 500 discrepancies. We need to post 500 adjustments to fix them."
- Integration: "Our legacy manufacturing system produces a CSV file of usage. We need to load that into Oracle."
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:
- Multiple Types: Supports Misc Receipt, Misc Issue, Subinventory Transfer, Account Alias Issue/Receipt.
- On-Hand Visibility: The upload template can display current on-hand balances to help users calculate the adjustment quantity.
- Validation: Checks for valid Items, Subinventories, Locators, Lots, and Serials.
The tool uses the Oracle Inventory Interface tables (MTL_TRANSACTIONS_INTERFACE) to process the data.
MTL_TRANSACTIONS_INTERFACE: The open interface table where data is staged.MTL_TRANSACTION_LOTS_INTERFACE: For lot-controlled items.MTL_SERIAL_NUMBERS_INTERFACE: For serial-controlled items.MTL_ONHAND_QUANTITIES_DETAIL: Used to display current stock in the template.
- Upload: Reads transaction details from Excel.
- Validation: Ensures the item exists in the org and the subinventory is valid.
- Interface Insert: Populates the interface tables.
- Processing: Launches the standard "Material Transaction Manager" to process the records.
- Speed: Reduces data entry time by 90% compared to manual forms.
- Accuracy: Pre-validation in Excel prevents common errors (e.g., typing a non-existent item number).
- Flexibility: Can be used for ad-hoc adjustments or recurring bulk loads.
- 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