My Oracle Support Banner

Item Supply/demand For WIP Job Reservations Reduces Inventory 2x - Subtracts Quantity For Both Work Order And Reserved User Source (Doc ID 2816137.1)

Last updated on MARCH 25, 2023

Applies to:

Oracle Materials Requirement Planning - Version 12.2.4 and later
Information in this document applies to any platform.



After implementing new WIP reservation functionality available via Patch 31947255:R12.WIP.C - INVDVDSD supply demand form shows wrong quantities when WIP reservation is setup in WIP Parameters -- on the Material tab


NOTE: In the images.examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


Testcase to match customer screen shots - Download XLS for detailed screen shots and navigation
1. 100 on hand for item DGCP01 which is used in assembly DGFG01
2. Setup /WIP /Setup / Parameters - Material tab - Automatic Reservation - Job Release (New functionality released in 12.2 )
3. Create job for qty = 2
4. Item supply demand shows WIP job and 100 available - 2 for Work Order = 98
5. Release job - this triggers the reservation functionality
6. Now Available shows 98 and 2 lines showing -2 for Work Order and -2 for Reserved User Source  and total remaining shows 96 -- BUT it should still be 98
7. Reservation and On Hand form show correct totals

No extra decrement of quantity when reservation is created - Line showing job quantity should switch from Work Order to Reserved user source


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.