WIP Inventory Accuracy
You can maintain accurate inventory balances for components and assemblies. Oracle Work in Process and Oracle Inventory combine to provide a number of tools to help you monitor and maintain inventory accuracy.
Transactions and Balances
When components are issued to jobs and repetitive schedules, the system automatically updates the component inventory balances in Oracle Inventory and the component issued quantities in Work in Process. Similarly, when job and repetitive schedule assemblies are completed, the system updates the assembly inventory balances in Oracle Inventory and the job or schedule completed quantities in Work in Process. Component and assembly returns work the same way only in reverse.
As you move assemblies on the shop floor, the system also automatically decrements the balance in the From operation sequence and intraoperation step and increments the To operation sequence and intraoperation step.
If you enter inaccurate information or delay the entry of transactions, the inventory balances become inaccurate. Performing material and move transactions in a timely manner helps you maintain accurate inventory balances.
Cycle Counting WIP Inventories
You can use Oracle Inventory's cycle counting system to cycle count inventory balances in work in process supply and completion subinventories and locators to check that material is being moved in and out of work in process accurately.
Physically Inventorying WIP Inventories
You can use Oracle Inventory's physical inventory system to check inventory balances in work in process supply and completion subinventories and locators to check that material is being moved in and out of work in process accurately.
Component Reports
You can check the timeliness and accuracy of the component balances in jobs and repetitive schedules using the Discrete Job Data Report and the Repetitive Schedule Data Report. Each report provides a complete list of material requirements including quantity required and quantity issued.
You can use these reports to randomly audit certain jobs or repetitive schedules in search of inaccurate balances. Whenever you find a problem, you can use Oracle Inventory's transaction reports and inquiries to identify its source. Once you know the source of the problem, you can take proactive steps to eliminate the causes and thereby improve the accuracy of work in process component balances.
Assembly Reporting
You can check the timeliness and accuracy of assembly balances in jobs and repetitive schedules using the WIP Location Report. This report provides a complete list of assembly balances by operation.
You can use this report to randomly audit certain jobs, repetitive schedules, assemblies, or work centers in search of inaccurate balances. Whenever you find a problem, you can use the Move Transaction Report and/or the View Move Transactions and View Resource Transactions windows to identify its source. Once you know the source of the problem, you can take proactive steps to eliminate the causes and thereby improve the accuracy of work in process assembly balances.
See Also
Overview of Cycle Counting
Overview of Physical Inventory
Viewing On-hand Quantities
