Oracle EBS Work in Process Reports

11 ready-to-run SQL reports for Oracle E-Business Suite Work in Process, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Work in Process tables in these reports are wip_entities, mtl_system_items_vl, wip_discrete_jobs, wip_lines, bom_departments, org_access_view.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Work in Process SQL Reports

Report Description
WIP Account Distribution Detail WIP report that lists resource transaction account distributions.
WIP Discrete Job Shortage WIP report that lists discrete job Open Requirements and/or Shortages. Report Modes ========== The report can be run in the following modes: 1. Open…
WIP Entities Detail WIP report that lists job, type, status, planner, item, item description, planning method, pegging type, entity, job Description, WIP resource…
WIP Entities Summary Overview of WIP entities of different types and their various statuses.
WIP Move Transactions WIP move transactions of discrete jobs, lot based jobs, repetitive schedules and flow schedules, one row per transaction, as shown in the View Move…
WIP Move Transactions 11i WIP move transactions of discrete jobs, lot based jobs, repetitive schedules and flow schedules, one row per transaction, as shown in the View Move…
WIP Outside Processing Imported from BI Publisher Description: WIP Outside Processing Report Application: Work in Process Source: WIP Outside Processing Report (XML) Short Name…
WIP Required Components Detailed project WIP report that lists discrete jobs and required components. The parameter ‘Show Shortage List’ can be used to show a shortage list of…
WIP Resource Transactions WIP resource, overhead and outside processing transactions, one row per transaction, as shown in the View Resource Transactions form. Quantity is in the unit…
WIP Value Application: Work in Process Description: WIP Value Report This report will display Period To Date (PTD) and Cumulative To Date (CTD) WIP costs/variances for…
WIP Value Summary Report to get the WIP and Material accounting distributions, by WIP job,period, Org . It displays detailed information from both sources WIP and Material…

← All Oracle EBS modules

© Enginatics GmbH