[WIP] Main Tables for Work In Process (WIP) Job

WIP_DISCRETE_JOBS_V - work order main info

WIP_REQUIREMENT_OPERATIONS - material and resource requirements

Sample codes:

SELECT MSI.SEGMENT1 AS "PART NO", WDJ.WIP_ENTITY_NAME, WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
WRO.REQUIRED_QUANTITY, WRO.QUANTITY_ISSUED
FROM WIP_REQUIREMENT_OPERATIONS WRO, WIP_DISCRETE_JOBS_V WDJ,
MTL_SYSTEM_ITEMS MSI
WHERE WRO.REQUIRED_QUANTITY-WRO.QUANTITY_ISSUED>0
AND WRO.ORGANIZATION_ID=1234
AND WRO.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WRO.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND WRO.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND WRO.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE=3 --Released
AND MSI.SEGMENT1='myItem'

[WIP] Before You Start

To get started with WIP module, you must first setup the WIP parameters (Setup -> Parameters) and setup at least 1 WIP Accounting Class (Setup -> WIP Accounting Classes).

[WIP] Missing Item Code in LOV

In order to build an assembly item in WIP, the "Pick Components" check box should NOT be checked (Order Management tab in Item form).

If it is checked, it will not appear in the Assembly LOV when user tried to create a WIP discrete job. It will also not appear in Routing LOV. Anyway, it will still appears in BOM LOV.

[WIP] Work Order is Canceled and Onhand Stock Not Released

Stock is reserved due to the allocation done during WIP Component Pick Release process. Even job is canceled, the allocation will not be released. Hence, the onhand is still not available for other transactions' use.

In order to increase the availability, we need to remove the job allocation.

Go to "Transact Move Orders" menu, go to "Pick Wave" tab, "Work Order" section, enter the job number, query the job. Cancel allocation at Tools->Cancel Allocations