WIP Completion Upload – Oracle EBS SQL Report

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

Overview

Creates assembly completions and returns as in the Completion Transactions form, for discrete jobs with and without routing and for the repetitive schedules of a line and assembly, into a completion subinventory and locator, with lot and serial numbers and overcompletions. Each row is inserted into the inventory transaction interface and processed immediately by the transaction manager, with backflush of the assembly pull and operation pull components, as for a completion entered in the form.

Upload Mode Create opens an empty sheet. Create, Update downloads the jobs and schedules of the selected Transaction Type: for completions the quantity at To move of the last operation, or without routing the quantity not completed yet, as Available; for returns the completed quantity. Enter Quantity on the rows to transact, rows left unchanged are not uploaded. An existing transaction is never updated; correct a completion with a return.

Quantity above Available needs Overcompletion, within the overcompletion tolerance, and follows the Allow Overcompletion parameter. A blank Final Completion takes the form’s default. Each row carries one lot and one serial number range; transact several lots as several rows.

Not supported: serialized jobs, sales order reservations and kanban replenishment, e-records and e-signatures, and backflush lot and serial entry. A completion fails when a backflush component is serial controlled, or lot controlled with a lot that cannot be derived.

To enter descriptive flexfield values, use the All Columns template, which shows the Completion Attribute segment prompts.

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, Line, Assembly, Job, Transaction Type, Allow Overcompletion

Oracle EBS Tables Used

mtl_parameters, wip_discrete_jobs, wip_entities, mtl_system_items_vl, mtl_transaction_types, mtl_item_locations_kfv, org_access_view, wip_repetitive_schedules, wip_repetitive_items, wip_lines

Report Categories

Enginatics, R12 only, Upload

CRP Resource Plan, WIP Discrete Job Shortage, WIP Move Transaction Upload, WIP Outside Processing, WIP Required Components, MRP Pegging, WIP Value Summary, WIP Account Distribution

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 WIP_Completion_Upload.xml
SQL Source WIP Completion Upload.sql
Full Report on Enginatics www.enginatics.com/reports/wip-completion-upload/

© Enginatics GmbH