Skip Headers

Oracle Inventory User's Guide
Release 12.1
Part Number E13450-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

On-hand and Availability

This chapter covers the following topics:

Overview of On-hand and Availability

Oracle Inventory enables you to view on-hand quantities, reservations, and supply and demand information.

Features

Material Workbench

The Material Workbench enables you to view material in receiving, on-hand quantities, and intransit 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.

Viewing On-Hand Quantities

  1. Navigate to the Query Material window.

  2. Optionally, enter a query name to create a new query, or select a query from the list of values to use an existing query.

    Note: The Public Query check box indicates whether all users can use the query. If the query is not public, then only the user who created the query can use it.

  3. Modify the search organization if necessary. You can clear the search organization to 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.

    the picture is described in the document text

  4. Optionally, enter a material location. The available choices are:

    For more information about subinventory types see, Defining Subinventories .

    You can select any combination of material locations. The following table shows the search restrictions that apply.

    Tab On-hand Receiving Inbound
    Item Yes Yes Yes
    Lot Yes Yes Yes
    Serial Yes Yes Yes
    LPN (License Plate Number) Yes Yes Yes
    Project Yes No No
    Consigned / VMI Yes No No
    Interorg No No Yes
    Supplier No No Yes
  5. Optionally, enter the subinventory to search if you selected Receiving or On-hand as the material location type. If you select both Receiving and On-hand, then you cannot enter a subinventory.

  6. If you entered a subinventory to search, enter a locator if desired.

  7. Optionally, enter the range of quantities.

  8. Select how to view the query results. The available choices are:

    Note: The lot information the system displays in the Material Workbench depends on the information that you enter in the query window. If you do not enter item or lot information in the Query window, then the lot information the system displays shows only fields from the global context. If you enter the lot information, but not item information, the Material Workbench displays the global context as well as the inventory context. If you enter the lot controlled item and the lot information in the Query window, then the system displays the global context, the inventory context, and the Oracle Warehouse Management context if you are in a warehouse enabled organization.

  9. Optionally, enter more search criteria under the following tabs:

  10. Click Find.

Material Workbench Display Options

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

Material Workbench Information

The Material Workbench contains two panes the View by pane, and the Quantity pane. You determine the information that appears on the view by pane when you select a view option on the Find Query window. The material location option that you select dictates which viewing options the information the Material Workbench displays. The following table shows the view by restrictions.

View By On-hand Receiving Inbound
Location Yes Yes Yes
Item Yes No No
Cost Group Yes No No
Status Yes No No
LPN Yes Yes No
Serial Yes No No
Lot Yes No No
Grade Yes No No

Material Workbench View by Information

The Material Workbench tree shows the different types of inventory. The Material Workbench lists each type of material location (on-hand, receiving, and inbound) as a different node under an organization. The information under each material location type differs. The on-hand and receiving material location types enable you to view material in on-hand and receiving subinventories. The document type node enables you to view incoming material. You can view information about purchase orders, intransit shipments, and internal orders.

As you navigate through the tree structure, the information the quantity pane displays changes. The quantity pane summarizes the material information at the next lower level from the current tree node. For example, if you select the top-level Organizations node, then the quantity pane summarizes information for each organization. If you select a particular organization on the tree structure, then the quantity pane displays information for the subinventories of the organization.

the picture is described in the document text

the picture is described in the document text

the picture is described in the document text

Material Workbench Quantity Information

The following information is available on the Quantity pane of the Material Workbench:

Note: You cannot view this field if you select LPN as the display option.

Note: You cannot view this field if you select Item as the display option.

Note: You cannot view this field if you select Item, Location, or Cost Group as the display option.

Note: You cannot view this field if you select Cost Group or Status as the display option.

Note: You cannot view this field if you select Cost Group, Item, or Lot as the display option.

Note: You cannot view this field if you select Cost Group as the display option.

Note: You cannot view this field if you select Cost Group or item as the display option.

Note: You cannot view this field if you select Cost Group as the display option.

Note: You cannot view this field if you select Cost Group, Item, or Lot as the display option.

Note: This field appears only if you are currently in a Warehouse Management enabled organization, and you select LPN or Location as the display type.

Note: This field appears only if you select LPN or Location as the display type.

Related Topics

Inventory Attribute Group

Viewing Item Availability

You can use the Material Workbench to view item availability. The system can calculate item availability for a given item at the subinventory, locator, lot, serial, or revision level.

On-hand Availability:

  1. Select the item you want to view. If you are viewing receiving material locations, you cannot view item availability.

  2. Click Availability.

    the picture is described in the document text

    You can view the following information in the Availability window:

  3. Close the Availability window.

Inbound Availability

If you are viewing inbound material, you can view availability information for items that you expect to receive.

  1. Select an item for which you want to view availability information.

  2. Click Availability.

    the picture is described in the document text

    You can view the following information in the Inbound Availability window:

  3. Close the Availability window.

Viewing Item Status Information

You can use the Material Workbench to view material status information. You can view the subinventory, locator, lot, or serial status. You can also see the allowed and disallowed transaction types for the item.

To view status information:

  1. Select the desired item.

    Note: If you selected Cost Group as the display option, you cannot view status information.

  2. Click Status.

    the picture is described in the document text

    You can view the following information in the effective status window:

Viewing Attribute Information

You can view the attributes of a particular lot, serial, or LPN (Warehouse Management only) from the Material Workbench. For lots or serials, the system displays the item attributes and categories. For LPNs the system displays the weight and volume of the selected LPN.

To view attribute information:

  1. Click Attributes.

    Note: If you selected Cost Group, Location, or Status as the display option, you cannot click Attributes.

    Note: If you select Items, Serial, or Lot as the display type, you can view only items that are under serial or lot control. If you select LPN (available only in an Oracle Warehouse Management enabled organization) as the display type, you can view only the LPN attributes.

    the picture is described in the document text

  2. Close the window when finished viewing the attributes.

Material Workbench Transactions

You can use the Material Workbench Tools menu to perform the following transactions:

To perform a mass move

  1. Select the item to move in the Material Workbench.

  2. Select Mass Move from the Tools menu.

  3. Enter the destination subinventory.

    the picture is described in the document text

  4. Click OK.

To perform a mass issue

  1. Select the item to issue in the Material Workbench.

  2. Select Mass Issue from the Tools menu.

  3. Enter the destination account.

  4. Click OK.

    the picture is described in the document text

To perform a status update

  1. Select the item to update in the Material Workbench.

  2. Select Status Update from the Tools menu.

    the picture is described in the document text

    Note: The system administrator can restrict access to fields and status levels on the Status Update Details window by setting security parameters on the Form Functions window. For more information, see To set up security parameters for the Status Update Details window (Material Workbench).

  3. Enter the applicable status changes.

    Note: If you do not set an inventory control for the item, you cannot update that status. For example, if the item is not lot controlled, you cannot update the lot status.

  4. Enter the applicable reason changes.

    Note: If you do not set an inventory control for the organization, you cannot update that status reason.

To perform a cost group transfer

  1. Select the item in the Material Workbench.

  2. Select Cost Group Update from the Tools menu.

  3. Enter the new cost group in the Transfer Cost Group field.

    Note: You must be in a warehouse management enabled organization to change cost groups.

    the picture is described in the document text

  4. Optionally, enter a default cost group.

  5. Enter the new cost group in the Transfer Cost Group field.

    the picture is described in the document text

  6. Select Override Entered Cost Group to override any cost group that is entered in the Transfer Cost Group window.

  7. Click OK.

  8. Click Update.

To create a cycle count

  1. Select the item in the Material Workbench.

  2. Select Cycle Counting from the Tools menu.

    the picture is described in the document text

  3. Enter the cycle count details. For more information, see Cycle Count Items, Defining Cycle Count Items andCycle Count Scheduling .

  4. Click OK.

To perform a grade update

  1. Select the item in the Material Workbench.

    Important: You must view the on-hand quantity by grade in the Material Workbench window to perform a grade upgrade. To view the quantity by grade, select Grade from the View By list in the Material Workbench window.

  2. Select Update Grade from the Tools menu. The Grade Update Details window displays the From Grade, Reason, Primary On-hand, and Secondary On-hand information.

    the picture is described in the document text

  3. Enter the new grade in the To Grade field.

  4. Enter the reason for the update.

  5. Click Update to change the grade, or Cancel to cancel the transaction.

Viewing Inventory Positions

You can view inventory on-hand quantities of an item or a group of items across multiple organizations. In particular, you can view the inventory position of a given organization hierarchy origin as the sum of the inventory positions of all subordinate organizations to that hierarchy origin.

You can inquire on inventory quantity information, such as the quantity on-hand, the quantity received in a particular time period, and the quantity issued in the same time period for a particular item across multiple levels of a specified organization hierarchy.

Complete the following tasks in order to view you inventory position across multiple inventory organizations:

To define query criteria

In order to view inventory positions you need to specify query criteria.

  1. Navigate to the Build Inventory Positions form.

    the picture is described in the document text

    To narrow the focus of information that you want to view, enter search criteria for the following fields:

  2. Press the Build button.

    The Inventory Position Processor concurrent program populates a temporary table with the inventory position data.

To display inventory positions

You can display a graphical tree representation of position information for each organization and for each organization hierarchy level.

  1. Navigate to the Display Inventory Positions form.

    the picture is described in the document text

  2. Drill down from the Hierarchy Origin Organization to base level organizations using a graphical tree representation of your hierarchy. The tree represents the organization hierarchy that was chosen when the data set was built.

    In the Organizations tab, you can examine quantity received, quantity issued and ending quantity on hand for any organization in the hierarchy, arranged into time buckets.

    In the Hierarchy tab, you can see the aggregate ending on hand balances for the hierarchy level you have chosen. By selecting the top level organization and entering the Hierarchies tab, you can see the total ending on hand balances for the entire hierarchy.

  3. Save your work.

To purge unused data

You can delete unused data sets using flexible criteria.

  1. Use the Request Reports or Submit Requests window and enter Inventory Position Purge in the name field to submit the report.

  2. Enter the following parameters:

    Data Set: Enter the Data Set Name that you would like to purge.

    Created By: Enter the appropriate profile information.

    Created Before: Enter a date. All data older than this date will purge.

  3. Submit your request.

    Important: You can export data sets that you built and viewed by accessing the data in the same table used for on line view.

To view Quality results

  1. If Oracle Quality is installed and if there are quality results for the current line, you can select the Quality button to open the View Quality Results window.

Related Topics

Customizing the Presentation of Data in a Folder, Oracle Applications User's Guide

Creating Organization Hierarchies, Using Oracle HRMS- The Fundamentals

Requesting the Multi-Organization Quantity Report

Use the Multiple Organization Inventory Report to show the inventory quantity on hand for items in more than one organization. The report has no limitations on the number of organizations you can enter. The report is sorted by inventory item for all of the organizations. You can include quantities that are in transit. If you have revision control items, you can report on the revision quantities individually (for each revision) or summed for the item. You can run the report for all items, or you can specify a range of items.

To request the Multi-Organization Quantity Report

  1. Navigate to the Run Multi-Organization Quantity Report window.

    the picture is described in the document text

  2. Indicate whether to report items in intransit inventory.

  3. Indicate whether to report the revision level of items.

  4. Enter the range of items to include in the report. If you leave this field blank, the report contains all inventory items.

  5. Enter the organization codes for the organizations you want to include in the report. If you leave this field blank, the report will run for all organizations. The Seq field displays a number indicating the order in which the organization appears on the report.

  6. Choose Run to submit the report.

Viewing Item Supply and Demand Information

You can view supply/demand information, and the current and projected available quantities of an item.

To choose the item for which you want to view supply/demand information

  1. Navigate to the Find Supply Demand Item window.

    the picture is described in the document text

  2. Enter the item for which to review supply and demand history.

  3. Optionally, enter a cutoff date. Supply and demand scheduled beyond the cutoff date are not displayed in the Supply/Demand Detail window.

  4. Select the on-hand source. Choose from ATP subinventories only, Net subinventories only, or All subinventories.

  5. Click Find. The results display in the Supply/Demand Detail window.

    the picture is described in the document text

  6. View information for:

    Supply/Demand Type: The supply source or demand source type, such asAccount number, Purchase order, Sales order, and WIP discrete job.

    Identifier: The identifier for the supply source or demand source, such as the purchase order number or work in process discrete job number.

    UOM: The primary unit of measure for the item.

    Quantity: The scheduled supply quantity or demand quantity for the item. Demand quantities are displayed as negative numbers. Supply quantities are displayed as positive numbers.

    Available Quantity: The projected on-hand quantity of the item, defined as Current Available + all future sources of supply and - all future sources of demand.

    Secondary UOM: The item secondary UOM if applicable.

    Secondary Quantity: The scheduled supply quantity or demand quantity for the item in the secondary UOM. Demand quantities are displayed as negative numbers. Supply quantities are displayed as positive numbers.

    Secondary Available Quantity: The projected on-hand quantity of the item defined as Current Available + All future sources of supply - all future sources of demand in the secondary UOM.

    Important: Oracle Inventory does not deduct a reservation from this value as it already deducted reservations from Current On-hand to calculate Current Available.

Related Topics

Searching for Information, Oracle Applications User's Guide

Item 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 ASNs and material in receiving for Warehouse Management enabled organizations.

For on hand inventory supply, there are two types of reservations, high level reservations, and low level reservations. High level reservations contain information about the item and the organization. Low level reservations contain more detailed information about the item such as revision, lot, subinventory, serial, and locator. You use the Item Reservations window to create, view, update, transfer, and delete reservation requests.

Crossdocking and Reservations

If you are in a Warehouse Management enabled organization, and use crossdocking for fulfilling sales order demand, then the system uses planned crossdocking to create a reservation between incoming supply and sales order existing demand. At supply receipt, the system directs you to move the material to appropriate staging lane instead of to a storage location.

Material Status and Reservations

You cannot create reservations against items with a non-reservable material status. You also cannot create a reservation that causes on hand quantity to be negative. Though you can create reservations against individual serial items, you may not be able to reserve items because of material status. This also applies to subinventory and locator level reservations. If you cannot reserve material in a locator, it may prevent you from creating a subinventory level reservation.

Reservations of Lot Indivisible Items

If you set an item as lot indivisible, then you must reserve the entire lot quantity. A lot level reservation must reserve the full lot quantity, or disregard the entire lot. If an indivisible lot exceeds the required lot quantity, you cannot select the lot, if it surpasses the order tolerance.

Inventory does not automatically create high level reservations for lot indivisible items. If a reservation is required at sales order scheduling, you must use the Reservations window to manually create a low level reservation.

When you manually create a low level reservation, you must enter the organization, item, lot demand information, quantity, UOM, and need-by date. The system prompts you to enter the lot, subinventory, locator, and LPN if applicable. The system also ensures the full lot is reserved. If a single lot resides in multiple locations, then the system requires you to create multiple reservations to wholly reserve the lot.

When you manually create a reservation, the system ensures the on hand quantity of the lot equals the available to reserve quantity. If the on hand quantity and the available to reserve quantity do not match, then you cannot create a reservation for that lot. The system does however allow you to over reserve a lot as long as it is within shipment tolerances.

Assemble-to-Order Completions for Lot Indivisible Items

You can complete an assemble-to-order (ATO) item into an existing reserved lot only if the lot is not reserved to a different demand source. WIP validates that you can create the new reservation without violating lot indivisibility. If the new reservation violates lot indivisibility, then the completion transaction generates an error.

Complex Maintenance Repair and Overhaul Reservations

You can create reservations for material based on scheduled demand for a Complex Maintenance Repair and Overhaul work order. If the material does not exist in on hand inventory you can create a reservation against a purchase order or any other supply source.

Reservations Change Management for Supply Sources

If you make changes to supply sources, then the system behaves as follows for the different supply types:

Reservations Change Management for Demand Sources

Subinventory Transfers with Reserved Serials

You can use the mobile device to perform serial triggered subinventory transfers for reserved serialized items. When you transfer the serial to another subinventory and locator, the system automatically transfers the corresponding reservation.

Note: You cannot perform a subinventory transfer transaction for staged serials.

Pick Release Allocation

If you reserve serials against a demand line, then pick release honors the reservations and allocates material at the serial level for reserved quantity regardless of the organization parameter that determines serial allocation. The system checks the status availability of the reserved serials and allocates them against the demand line without performing the other rules engine checks. If the serials are reserved, but fail the status availability check, then the system backorders the unavailable quantity. If a line is partially reserved at serial level, then pick release allocates the reserved serials against that line, and uses the organization level parameter to determine allocation for the remaining quantity.

LPN Reservations

If you are in a Warehouse Management enabled organization, you can create reservations against LPNs. You can reserve an entire LPN against a sales order if the LPN quantity does not exceed the unreserved quantity for the sales order line. If the LPN quantity exceeds the sales order line you cannot reserve the entire LPN. You also cannot create a new reservation for an LPN that is partially that reserved against a different demand source. You can reserve an LPN with multiple lots with a quantity less than or equal to order line quantity. The system creates separate reservations for each lot. You can perform a subinventory transfer for a reserved LPN. The system transfers the LPN and the corresponding reservations automatically.

Creating Reservations

  1. Navigate to the Item Reservation window. The Find Reservations window appears.

  2. Choose New.

    the picture is described in the document text

  3. In the Demand Source region, select from one of the following system default options, or select one of the transaction types you previously defined. To define transaction source types, see Defining and Updating Transaction Source Types, Oracle Inventory User's Guide .

    Sales Order: Demand source is a sales order. If you select this option, enter a sales order number and a line number that identifies the item quantity to reserve. The system deletes the reservation when it ship-confirms the order.

    Inventory: Demand name is an inventory. If you select this option, enter the name against which you want to make the reservation.

    Account: Demand source is an account. If you select this option, enter the organization code and account number.

    Account Alias: Demand source is an account alias. If you select this option, enter the organization code and account number.

    Internal Order: Demand source is an internal order. If you select this option, enter an internal order number, and a line number that identifies the item quality to reserve. This reservation is deleted when the order is ship confirmed.

    Cycle Count: Demand source is a cycle count. Shipping Execution and Inventory create cycle count reservations when material is missing during picking or shipping. You use this reservation type to ensure no one else tries to use or allocate the material. Oracle deletes this reservation when you perform a cycle count of the item in the specified location.

    Job or Schedule: Demand source is a process execution or maintenance job. You can create reservations for material based on schedule demand to a work order. If the material does not exist in inventory, you can create a reservation against a purchase order, or any other supply type.

    Important: The Item Reservations window will not support creating reservations with WIP discrete jobs as demand source.

  4. In the Demand tabbed region, enter or select the following:

  5. In the Supply tabbed region, enter or select the following:

  6. Save your work.

To reserve multiple serial numbers

  1. Click Serials.

    the picture is described in the document text

  2. Enter a serial number in the Serial field.

  3. Repeat step two for the remaining serial numbers.

  4. Click Done.

To view current item availability information

  1. Review the following fields:

    Available Quantity: The Available Quantity field displays the quantity available to reserve. This is equal to the on hand quantity minus the reserved quantity (including the reserved quantity of other lines in the current reservation) and minus pending transactions

    Note: Allocating move order lines for reservable items creates a reservation. If the item on a pick wave move order line is reservable, when you allocate the move order, the system creates a reservation and detailed suggestion. If the item on a pick wave move order line is not reservable, when you allocate the move order the system only creates a detailed suggestion.

    Note: Material contained in a non-reservable subinventory is not included in the available-to-reserve quantity.

    On Hand Quantity: The On Hand Quantity field displays the total quantity for the item that is specific to your current organization, and the revision level, lot number, subinventory, and locator you define for the item.

To transfer supply

  1. Select the item reservation.

  2. Choose Transfer Supply from the Tools menu. The Transfer Supply window appears.

    the picture is described in the document text

  3. Enter or select the following:

    Supply Type: Supply source type.

    Revision: Revision for the item. You can enter a value here only if you establish revision quantity control for the item.

    Lot Number: Lot number for the item. You can enter a value here only if you establish lot control for the item.

    Subinventory: Subinventory from which to reserve the item.

    Locator: Locator to which to reserve the item if it is under locator control.

    Transfer Quantity: Quantity of the specified item to transfer. If the item is under dual UOM control, then the system displays the secondary quantity.

  4. Choose Transfer.

To transfer demand

  1. Select the item reservation.

  2. Choose Transfer Demand from the Tools menu. The Transfer Demand window appears.

    the picture is described in the document text

  3. Enter or select the following:

    Demand Type: Demand source type.

    Demand Header: Demand header identification number.

    Demand Name: User-defined name to reference the demand.

    Transfer Quantity: Quantity of the specified item to transfer.

  4. Choose Transfer.

To delete a record in the Transfer Supply or Transfer Demand windows

  1. Select the record you want to delete.

  2. Choose Delete.

Related Topics

Transaction Source Types

Transaction Types

Transaction Actions

Customizing the Presentation of Data in a Folder, Oracle Applications User's Guide

Viewing Reservation Interface Activity

Use the Reservations Interface window to view, process, and delete reservation requests. These include processed requests that have errored out and unprocessed requests. (Requests that are successfully processed disappear from the interface table and form.) You can also submit and resubmit reservation requests to the reservations interface manager for processing.

To view reservations requests

  1. Navigate to the Reservations Interface folder window. The Find Reservations Interface Requests window appears.

    the picture is described in the document text

  2. Enter search criteria for the reservation requests you want to view.

  3. Choose Find to start the search. The results display in the Reservations Interface window.

  4. Select a tabbed region to display a type of information:

    Error: Interface reservations error information.

    Demand: Interface reservations demand information.

    Supply: Interface reservations supply information.

    Controls: Interface reservations control information.

    Note: For a list of the available fields in each tabbed region see: Reservations Interface Folder Window Available Fields.

To submit and resubmit reservation requests for background processing

  1. Check the Submit option next to the reservations you want to submit or resubmit or choose Resubmit All from the Tools menu.

    If you have many reservations to resubmit, use the Resubmit All option to select all reservations for processing and then selectively deselect individual reservations you do not want to resubmit.

  2. Save your work to submit the reservations for processing.

    The reservations interface manager will process these requests the next time it runs.

To submit and resubmit reservation requests for online processing

  1. Check the Submit option next to the reservations you want to submit or resubmit or choose Resubmit All from the Tools menu.

    If you have many reservations to resubmit, use the Resubmit All option to select all reservations for processing and then selectively deselect individual reservations you do not want to resubmit.

  2. Choose Process Batch to process a batch of reservations requests at a time or choose Process Line to process reservations requests one line at a time.

To delete reservation requests

  1. Check the Submit option next to the reservation record you want to delete.

  2. Choose Delete from the Tools menu.

Related Topics

Customizing the Presentation of Data in a Folder, Oracle Applications User's Guide

Reservations Interface Folder Window Available Fields

The Reservations Interface folder window allows you to view reservation requests. Using folder options, you can display certain fields for each tabbed region. See: Viewing Reservations Interface Activity.

Fields Shared by All Tabbed Regions

Batch ID Batch identification number.
Interface ID Interface identification number.
Organization Code for the organization in which the item resides.
Item Inventory item referenced by the line item.

Error Tabbed Region

Error Explanation Explanation of the error that occurred when attempting to process the line item.
Status Status of the reservation request.
Mode Transaction processing mode, such as background or online processing.
Partial Quantities Whether the available quantity should be reserved when the available quantity is less than the reservation quantity.

Demand Tabbed Region

Type Demand source type for the line item.
Source Source of the demand for the line item, such as an account number.

Supply Tabbed Region

Type Supply source type of the line item to be reserved.
Source Source of the supply of the line item to be reserved.
To Type Updated supply source type for the line item.
To Source Updated source of the supply for the line item.

Controls Tabbed Region

Revision Inventory item revision of the line item to be reserved.
Lot Source lot number of the line item to be reserved.
Subinventory Source subinventory of the line item to be reserved.
Locator Source lot number of the line item to be reserved.
To Revision Updated inventory item revision of the line item.
To Lot Updated source lot number of the line item.
To Subinventory Updated source subinventory of the line item.
To Locator Updated source locator of the line item.
To: LPN Updated license plates to be reserved and allocated for move order lines. You must be in a WMS enabled organization to use this functionality. See: Overview of the WMS Rules Engine, Oracle Warehouse Management User's Guide

Related Topics

Customizing the Presentation of Data in a Folder, Oracle Applications User's Guide

On-hand Availability Reports

Item Quantities Summary Report

Use the Item Quantities Summary Report to report just the item and the quantity. The report is useful to provide a fast list of the items in the inventory.

Locator Quantities Report

Use the Locator Quantities Report to identify items and their quantities stored in the specified locators. You can transact item quantities to locators and track the movements of items at the locator level. If the locator has zero on-hand quantity, the locator does not print. Items within the locator print only if they have on-hand quantity.

Subinventory Quantities Report

Use the Subinventory Quantities Report to show inventory item quantities by subinventory.

VMI Onhand by Supplier Report

Use the VMI Onhand by Supplier Report to view onhand inventory by supplier across organizations.

Related Topics

Item Quantities Summary Report

Locator Quantities Report

Subinventory Quantities Report

VMI Onhand by Supplier Report