How You Manage Reservations for Work Order Materials in Manufacturing

To manage reservations automatically for work order materials in Oracle Manufacturing, you can select one or more work orders in released or unreleased status and reserve materials in the following two ways:

  • In the Manage Work Orders page, you can create reservations using the Reserve Materials Automatically action, for the on hand quantity. A scheduled process starts in the background, to create reservations for all the eligible work order materials.

  • In the Material Availability Assignments page, you can select one or more work orders in released or unreleased status and reserve materials. You can create reservations using the Reserve Materials Automatically action, for the on hand quantity. It's the same action as on the Manage Work Orders page, and a scheduled process starts in the background.

You can review the scheduled process output report and check the reservation details. The materials of the selected work orders are reserved based on the ATR (Available to Reserve) quantity. If not, an appropriate error message is displayed for those materials that aren't reserved. If a reservation has already been made for one or more materials, the lock icon is displayed for the work order.

You can also reserve materials manually for work order materials in Manufacturing in the following two ways:

  • In the Edit Work Order Operations page, use the Reserve Materials Manually action to reserve materials for the work order operation. The inventory reservation user interface is launched, and you can create detailed reservations for the materials, with Subinventory, Locator, Lot, and Serial details.

  • In the Material Availability Assignments Details page, use the Reserve Materials Manually action to reserve materials for the work order operation. The inventory reservation user interface is launched, and you can create detailed reservations for the materials, for the Subinventory, Locator, Lot, and Serial details.

If the reservation for the work order material is made for another work order, the details are displayed in the existing Edit Work Order page Reservations tab. You can review the details of the work order product as supply and the details of the work order component as demand. After the reservation is made for the work order material, the reserved quantity is displayed, and can be viewed in the Edit Operations Items page.

Transact Reserved Materials to Work Orders

You can transact the reserved materials to the work order. The View Reservations details of the work order material displays the details of the reserved material. These details include Document Type, Document Number, Revision, Lot, Subinventory, Locator, Reserved quantity, UOM, and Serial.

The reservation for the material is relieved when you transact reserved materials or when you perform material issue transaction. You can create reservations and perform the work in process issue transactions, which relieves the reservation. When you use the work order pick release, then the detailed reservation is also carried forward to the destination subinventory, and this reservation is relieved when the material issue transactions are performed for the work order.

Use Case 1 for Item Variations

When the item isn't enabled for lot or serial control, and the detailed reservation for work order material is performed for subinventory named Stores. Then this reservation is relieved only when the material is issued from the subinventory named Stores and is retained if you use material from a subinventory other than the one named Stores. When the reservation isn't detailed for a specific subinventory or locator, the reservation is relieved regardless of the subinventory you use to issue material to the work order.

Use Case 2 for Item Variations

If you have performed a reservation for a specific lot or serial, the reservation is relieved only when the reserved lot or serial is issued to the work order. When the reservation isn't detailed for a specific lot or serial, then the reservation is relieved regardless of what lot or serial is reserved. Also, when the reservation is detailed to a subinventory but not detailed to specific lot or serial, then the reservation is relieved as long as serials or lots in that subinventory are issued to the work order else the reservation is retained.

Delete Reservations of Work Order Materials

You can delete the existing reservations of the work order materials if you do any of the following:

  • Change the work order status

  • Decrease the work order quantity

  • Decrease the operation item quantity

You can delete the pending reservations if you complete, cancel, or close the work order. If you have already allocated the materials, then the movement requests will also be deleted before the reservations are deleted.