WIP Material Transaction Upload – Oracle EBS SQL Report

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

Overview

Issues components to, and returns components from, WIP work orders.

The download returns one row per component requirement of the selected work orders, with the operation, department, supply subinventory and locator already filled in, and the required, issued and still open quantities shown. Enter a Transaction Type and a Quantity on the rows you want to transact and leave the rest blank.

Quantity is always entered as a positive number; the Transaction Type decides the direction.

Discrete jobs, lot based jobs and maintenance work orders are supported. Repetitive schedules are not.

Rows are staged in the inventory transaction interface and processed by the inventory transaction manager, so the resulting transactions are identical to those the WIP Material Transactions form creates and relieve the work order requirement in the same way.

Report Parameters

Upload Mode, Organization Code, Job, Job Status, Assembly, Component, Department, Date Required From, Date Required To, Open Requirements Only

Oracle EBS Tables Used

mtl_units_of_measure_vl, org_organization_definitions, wip_entities, wip_discrete_jobs, wip_requirement_operations, mtl_system_items_vl, bom_departments, mtl_item_locations_kfv

Report Categories

Enginatics, Upload

WIP Required Components, CRP Resource Plan, CAC Manufacturing Variance, WIP Job Upload, WIP Value Summary, CAC ICP PII WIP Material Usage Variance, CAC WIP Material Usage Variance, MRP Pegging

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
Blitz Report™ XML Import WIP_Material_Transaction_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/wip-material-transaction-upload/

© 2026 Enginatics