DOC

On-hand and Availability

By Vanessa Garcia,2014-10-06 00:41
9 views 0
On-hand and Availability

    On-hand and Availability

    Overview

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 1 of 40 Rev 1

On-hand and Availability

    System References

    Oracle Inventory > Material Workbench

    Oracle Inventory > Query Material

    Oracle Inventory > Material Workbench > Availability Oracle Inventory > Material Workbench > Reservations

    Distribution

    *Job Title

    Ownership

    The Job Title [list@YourCompany.com?Subject=EDU40C0Y.doc] is responsible for ensuring that this document is necessary and that it reflects actual practice.

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 2 of 40 Rev 1

    R12 On-hand and Availability

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 3 of 40 Rev 1

Objectives

     Copyright ? Oracle, 2007. All rights reserved. On-hand and Availability 85708552.DOC Effective mm/dd/yy Page 4 of 40 Rev 1

Overview of On-hand Quantity

Overview of On-hand Quantity

    On-hand quantity is the physical quantity that resides in your subinventory. For example, the Bulk subinventory has 15 items that reside in it. Therefore, the on-hand quantity for the Bulk subinventory is 15.

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 5 of 40 Rev 1

Overview of Reservations

Overview of Reservations

     A reservation is a link between a supply source and a demand source. A reservation creates a permanent data link between a supply source and a demand source, and represents a guaranteed allotment of material to a specified demand source. Item reservations prevent the allocation of material you previously set aside for a sales order, account, account alias, inventory allotment, user-defined source, process batch components or, Oracle Complex Maintenance and Repair Overhaul work order components. You can also create reservations for different types of supplies such as on-hand inventory, purchase orders, internal requisitions, discrete jobs, shop floor jobs, and process manufacturing batches. In addition, you can create reservations for advanced shipment notices (ASNs) and material in receiving for Oracle Warehouse Management enabled organizations.

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 6 of 40 Rev 1

Overview of Availability

    To Planning functions, avail = supply - demand for a particular time period To Inventory, avail = on hand-res-pending transactions

    Note

     Availability to Inventory is not the same as availability to Planning- Planning looks at

    inbound supply in addition to on hand quantity and deducts other demand. Inventory only

    looks at what is on hand and subtracts what is committed to other uses (i.e reserved or about

    to be moved or issued out the door)

     Availability to Inventory depends on what you want to use the material for. For example, if

    you have material that is in a non-reserved subinventory, that quantity will not be available to

    reserve but it may be available to transact (for miscellaneous issues etc).

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 7 of 40 Rev 1

Reservation Versus Allocation

Reservation Versus Allocation

    For Oracle Inventory, a reservation is a guarantee of inventory. These can be made at a variety of levels. For example, you can reserve five mountain bikes in the FGI subinventory. You can create a reservation any time you book an order or schedule a job. Reservations do not have to be for on-hand inventory. You can reserve purchase orders, wip jobs, process manufacturing batches, and so on.

    An allocation is a transaction suggestion generated by the allocation process (essentially a pending pick). It honors the reservations made, if any, and the picking rules specified. Allocations are detailed down to the subinventory, locator, and if applicable, lot level. Allocations are the result of the pick release process. Allocations are only created against on-hand inventory.

    Both allocations and reservations deduct from available inventory but in different ways. There are checks in place to ensure that the system does not double deduct when you have a reserved sales order that has also been allocated but not picked.

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 8 of 40 Rev 1

Material Workbench

Material Workbench

    The Material Workbench enables you to view material in receiving, on-hand quantities, and inbound material. You can also view material across organizations. In addition, you can create and save queries, create move orders, and request cycle counts, as well as change material statuses.

    You can view item quantity across organizations. You can view only material in organizations to which you have access. If you do not enter an organization, you must enter an item.

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 9 of 40 Rev 1

Display Options

Display Options

    The viewing option that you select dictates the information the Material Workbench displays. The viewing options are:

     Location: Location information includes the subinventory and associated locators. You

    can also view subinventory quantities, including packed and unpacked quantities. This is

    the only view by option that you can use if the material location type is Inbound.

     Item: Item information includes the organization, item number, UOM, available quantity,

    lot, and serial number. You can use this option only if the material location type is On-

    hand.

     Cost Group: Cost Group information that is assigned to the item. You can use this option

    only if the material location type is On-hand.

     Status: Status information that includes the statuses assigned to subinventories, locators,

    lots, and serials. You can use this option only if the material location type is On-hand.

     LPN: If you are in an Oracle Warehouse Management enabled organization, you can view

    LPN information for the item. You can use this option if the material location type is On-

    hand, Receiving, or both.

     Copyright ? Oracle, 2007. All rights reserved.

    On-hand and Availability 85708552.DOC

    Effective mm/dd/yy Page 10 of 40 Rev 1

Report this document

For any questions or suggestions please email
cust-service@docsford.com