Stores

This chapter covers the following topics:

Stores

Material issue to work orders and returns to inventory are typical store room functions and can be performed by using the Maintenance Super User - Stores tab.

There are two activities involved in delivering material from stores to a work order.

  1. A Material Issue Request is generated to request the material to a work order. This process is automated upon work order release by selecting a check box in the Enterprise Asset Management Parameters (See: Defining eAM Parameters).

  2. The Material Issue Verification is generated when you access the Stores tab and select material for a work order, based on available, unprocessed move orders.

Note: A one-step material issue is a substitute for these two activities; a request is not created.

There are two primary methods used to issue material to a work order:

You can return material to inventory from a maintenance work order. If excess or defective material is issued to a work order, it needs to be returned.

The section includes the following topics:

Delivering Material from Stores to a Work Order

There are two activities involved in delivering material from stores to a work order:

  1. Material Issue Request is generated (move order in Oracle Inventory) to request the material to a work order.

    You may automate this process upon work order release by selecting the Enable Material Issue Requests check box in the Enterprise Asset Management Parameters (See: Defining eAM Parameters). You may override this setting at the work order level. The Auto Request Material check box is located in the Material Requirements window. (See: Routine Work Orders).

  2. The Material Issue Verification (move order in Oracle Inventory) is generated when you access the Stores tab and select material for a work order, based on available, unprocessed move orders.

    A one-step material issue is a substitute for these two activities; a request is not created.

If you want to issue multiple rebuild able items in a single transaction, select Yes in the Allocate Serial Numbers field in the Organization Parameters: Revision, Lot, Serial Number, LPN page. See Issuing Multiple Rebuildable Items for more information.

If the Material Issue Request process is not automated, you can perform a manual request within the Request All Materials page, located on the Work Orders tab.

You can also run the Work Order Component Pick Release concurrent program to perform the material allocation for a group of work orders.

You can also run the EAM Work Orders Component Pick Release concurrent process from the Reports tab under the Maintenance Super User (self-service) responsibility.

To perform the required setup steps for the two-step material delivery process

Prerequisites

  1. Define a Default Pick Slip Grouping Rule within the WIP Parameters window.

    This information is used when pick slips are created for the material issue requests, detailing subinventory and locator information.

  2. Decide if your organization will allocate serial numbers.

    If No, then the quantity of the material issued is allocated and no serial numbers are allocated. The picker then enters the picked serial numbers from the available serial numbers.

    If Yes, then the serial numbers are allocated during the material request, and therefore, are not available for any other transaction.

  1. Navigate to the Work In Process Parameters window.

  2. Select the Other tab.

    Work in Process Parameters

    the picture is described in the document text

  3. Select a Default Pick Slip Grouping Rule. This information is used when pick slips are created for the material issue requests, detailing subinventory and locator information.

  4. Save your work.

  5. Navigate to the Organization Parameters window.

  6. Select the Revision, Lot, Serial tab.

    Organization Parameters

    the picture is described in the document text

  7. Select an Allocate Serial Numbers value. If you select No, the quantity is allocated, but individual serial numbers are not. If you select Yes, you can allocate multiple serial numbers when material requests are created. These serial numbers are not available to any other transaction.

    Organizations typically select No, enabling the picker to enter the picked serial numbers. In most cases, the requestor is not partial to specific serial numbers.

  8. Save your work.

Running the Work Order Component Pick Release Concurrent Program

Prerequisites

The work orders must meet the following criteria:

Using this concurrent program enables you to perform material allocation for work orders that were released earlier with insufficient on-hand material, but now have sufficient on-hand quantity for the material allocation.

Follow these steps to run the Work Order Component Pick Release concurrent program.

  1. Navigate to Enterprise Asset Management > Work Orders > Work Order Component Pick Release or Maintenance Super User > Reports > EAM Work Orders Component Pick Release.

  2. Select the work orders to which you want to perform material allocations.

    Only work orders with a status of Released and that have open material quantity are available for selection.

    The following list of parameters will be used to select work orders to perform material requirement allocations:

    Parameter Type Default Value Field/LOV
    Days forward Mandatory 1 To enter Number of days
    Pick slip grouping rule Mandatory Default rule specified in WIP parameters (PICKSLIP_GROUPING_RULE_NAME in WIP_PARAMETERS_V) Pickslip grouping rules LOV (PICK_SLIP_RULES in WSH_PICK_GROUPING_RULES
    Print Pick slips Optional Yes LOV values 'Yes' and 'No'

    Example

    Days forward: The number of days into the future to consider material requirements for the pick release.

    If the Days forward value is entered as 3, then the program selects the work order material lines whose Date Required is less than or equal to the 'sys date + 3'.

  3. Click the Submit button.

To generate a Material Issue Verification

Assuming that you have set the eAM Parameters to automatically create a Material Issue Request upon work order release, the following procedures execute the Material Issue Request; they physically allocate material to a work order.

Note: Ensure that the requested material is available in subinventories that are enabled for picking. Enabled subinventories might be governed by picking rules. See: Defining Picking Rules, Oracle Inventory User's Guide.

  1. Navigate to the Stores tab (Maintenance Super User: Stores tab).

  2. Click the Material Issue link, and the Simple Search page appears.

    You can also use the Advanced Search page.

  3. Optionally enter at least one of the following fields in both the Simple and Advanced Search modes.

    • Material Request Number - to include results for a specific material request number.

    • Work Order Number - to include only requests for a specific work order.

    • Material - to include requests for specific a material.

    • Subinventory - to include requests for a specific Subinventory.

    • Line Number - if using the Advanced search mode (Advanced button), to include only specified lines on a request.

    • Operation number - to include requests or a specific operation on a work order.

    • Add Another search option from the list of values, and then choose Add.

      • Locator - if a subinventory was selected and requires a locator.

      • Created By value - to include the person who created the material request.

  4. Choose Go to display material issue request information in the Results region.

    Material Issue

    the picture is described in the document text

    The results region is divided between Material with no Lot or Serial Control and Material with Lot or Serial Control.

  5. Optionally update the default Issue Qty.

  6. Optionally select a Reason for the Material Issue.

  7. Optionally enter a Reference.

  8. Optionally select the Delete Remaining Allocation check box to delete the remaining, unissued quantity, if the Issue Qty is lower than the allocated amount within the material requirements.

    Conditional Action: The Update Material Requirements check box is also available.

  9. Optionally select the Update Material Requirement check box if you want to revise the material requirements for the work order.

    Conditional Action: You must select the Delete Remaining Allocation check box before the Update Material Requirements check box is available.

  10. Click the Issue button to issue the material, and apply any changes to the remaining allocation and material requirements for the work order.

  11. Optionally update the fields in the Material with Lot or Serial Control region of the page.

  12. For results within the Material with no Lot or Serial Control region, optionally select the Replace Rebuild Details pencil icon to specify a Serialized Rebuildable to issue to the current work order. This icon is enabled if the associated work order is for Rebuildable Inventory maintenance.

    If you are issuing material for multiple rebuild able serial numbers, the Replaced Rebuild Details region is unavailable. Material for multiple rebuild able items can then be issued in a single transaction. See Issuing Multiple Rebuildable Items.

    If you are issuing material for one serialized rebuild able, indicate the following within the Replaced Rebuild Details region:

    • Rebuild Item - defaults as the current Rebuild Item; you can update it.

    • Rebuild Serial Number - optionally enter if you know what serial number is coming out (for serialized rebuilds only).

    • Rebuild Activity - the activity you want to associate with the created rebuild work order.

    • Rebuild Work Order - the name of the work order created for the replaced Rebuildable Item.

    If you specify a replaced rebuild able item, a work order generates for the replaced rebuild able item because it is most likely problematic, and you can have it repaired. If a serial number is provided for the replaced Rebuildable Item, it is removed from the asset hierarchy and the configuration history is updated.

    If nothing is specified within the Replaced Rebuild Details page, the rebuild item is issued for the selected work order. The rebuild work order is automatically created only if the replaced rebuild details are entered.

  13. Optionally select the Delete icon to delete the current material allocation. You might want to use this feature if you want to free material and use it within the One-Step process.

  14. Click the Issue button to issue the material to the work order.

  15. Optionally for results within the Material with Lot or Serial Control region, perform these steps to issue material, delete remaining allocation, and update material requirements to the current work order:

    1. Select the material.

    2. Click the Proceed to Issue button, and the Issue Serial (Lot Control) Numbers page appears.

    3. Select the item in the Available for Issue check box that you want to issue.

      You must select each specific serial or lot controlled item.

    4. Click the right arrow to move the item into the Issue region.

    5. Optionally select the Delete Remaining Allocation check box.

      The Update Material Requirements button is available.

    6. Optionally select the Update Material Requirements check box.

      You must select the Delete Remaining Allocation check box before the Update Material Requirements check box is available.

    7. Select a Reason and a Reference.

    8. Click the Apply button.

      This action will issue the material, and if selected, delete any remaining material allocation, and update material requirements for the work order.

      the picture is described in the document text

  16. A confirmation message appears that the material was successfully issued.

To perform a one step material issue

A one-step material issue is a substitute for the Material Issue Request and Material Issue Verification activities; a separate request is not created. This is performed if the Enable Material Issue Requests check box is not selected in the eAM Parameters (See: Defining eAM Parameters).

  1. Navigate to the Stores tab.

  2. Select the One Step Material Issue sub-tab.

  3. Select the work order that you wish to issue material. It must be enabled for material issue requests. See: Routine Work Orders.

    Click the Go button.

    One Step Material Issue

    the picture is described in the document text

  4. You can perform one-step material issues to work orders in different units of measure (UOMs).

    Click the UOM field for the specific material issue; all other UOMs defined for that material will be available for selection.

    If the default UOM is changed, then the Issued Qty field will display the default issued quantity converted to the new UOM.

  5. Click the Show/Hide link for the material to view material details.

    Details associated with the default UOM appear.

    The converted quantity based on the transaction (new) UOM displays in the Required Qty, Allocated Qty, and Open Qty fields.

  6. Click the icon in the On Hand Details column to view the on-hand quantity details for the material.

    the picture is described in the document text

    The system displays on hand quantity for the material issue in the user-selected transaction UOM.

    Close the popup window.

    Enter values for the subinventory, locator, lot, serial information, and so on.

  7. You can search to add inventory items by using one of these options:

    • Item

    • Description

    • Cross Reference

    • Cross Reference Description

    • Manufacturer

    • Manufacturer Part Number

    Click the Select radiobutton for the item to be added.

    Click the Select button.

  8. Optionally select the specific Operation to view results on existing one step material issues that were issued to that operation. Only operations existing within the selected work order are available.

  9. Optionally select a specific Material if your query is to view the existing one step material issues.

  10. Click the Go button.

    All planned material appears in the Select Material(s) region. Planned material is material that exists in the material requirements for the work order. See: Defining Inventory Material Requirements.

  11. Within the Select Material(s) region, optionally select unplanned Material (material not part of the material requirements) to issue to the current work order.

    • Select an Operation to which to issue the material. The UOM default value comes from the current material.

  12. Select the Quantity of the material that you are issuing to the work order.

  13. Optionally select a Subinventory to pull the material from in Inventory.

  14. If you previously selected a Subinventory requiring a Locator, select a Locator.

  15. If the current material is lot controlled, select a Lot.

  16. If the current material is serial controlled, select From and To Serial numbers.

  17. Optionally select a Revision.

  18. If the material is Rebuildable Inventory, optionally click the Replaced Rebuild Details button to specify the replacement Rebuildable Item information for the current Rebuildable Item. After selected, you can indicate the following within the Replaced Rebuild Details page:

    • Rebuild Item - defaults as the current Rebuild Item; you can update it.

    • Rebuild Serial Number - optionally enter if you know what serial number is coming out (for serialized rebuilds only).

    • Rebuild Activity - the activity you want to associate with the created rebuild work order.

    • Rebuild Work Order - the name of the work order created for the replaced Rebuildable Item.

    If you specify a replaced rebuild able item, a work order generates for the replaced rebuild able item because it is most likely problematic and you can have it repaired. If a serial number is provided for the replaced Rebuildable Item, it is removed from the asset hierarchy and the configuration history is updated.

    If nothing is specified within the Replaced Rebuild Details page, the replaced rebuild defaults as the same rebuild item that you are issuing. A work order is created for the replaced rebuild item.

  19. Optionally select the Details Show/Hide toggle button.

    1. Optionally select a Reason for the current issue.

    2. Select the Date required for the material to the work order. Default values for Today's date and time appear.

    3. Optionally enter a Reference.

  20. Click the Select check box next to the lines you are issuing to the current work order.

  21. Click the Issue button, and the system displays a confirmation message at the top of the page.

Related Topics

Overview of Move Orders, Oracle Inventory User's Guide

Returning Material to Inventory

You can return material to inventory from a maintenance work order. If excess or defective material is issued to a work order, it needs to be returned. Only material issued to work orders can be returned to inventory. The quantity returned cannot exceed the quantity issued; it must be 1 if the material is serial controlled.

To return material to inventory

  1. Navigate to the Stores tab.

  2. Select the Return Material To Inventory sub-tab.

  3. Optionally select a work order to narrow your results to one work order.

  4. Optionally select a Material value to narrow your results to all work orders containing it as a material requirement.

  5. Optionally select a Lot Number to narrow your results to all work order containing the previous Material with the current Lot Number.

  6. Optionally select a specific Operation contained in the previously selected work order.

  7. Optionally select a Serial Number to narrow your selection criteria to only work orders containing it as part of their material requirements.

  8. Click the Go button.

    the picture is described in the document text

  9. Enter the return Quantity for each work order.

  10. Select the Subinventory to which to return the material.

  11. If the previous Subinventory requires a Locator, select a Locator.

  12. Optionally select a Date to return the material. The default value is the current system date and time.

  13. Optionally select a Reason code to indicate the reason the material is not needed.

  14. Optionally enter Reference information.

  15. Enable the Select check box to include the work order rows from which material is being returned.

  16. The Delete Allocation & Material Requirements check box for the material line of the work order indicates that you want to delete all the outstanding (unused) material allocation. The default for this check box is selected.

    This check box enables the following actions to occur when the return to inventory process is performed:

    • Deletes the open and unused material allocation of the work order.

    • Updates the material requirement quantity of the work order to reflect the net issued quantity (Qty Issued - Qty Returned).

    Optionally clear this check box if you do not want to perform these functions.

  17. Click the Return to Inventory button.

Issuing Multiple Rebuildable Items

You can issue multiple rebuild able items in one transaction, using the one-step or two-step issue methods. The rebuild able items include serial, non-serial, lot and non lot-controlled items.

A rebuild work order is automatically created only if the replaced rebuild details are entered.

To perform multiple rebuild able issues for non-serial or non lot-controlled items

  1. Create a work order (status of Released) with rebuild able items with the quantity greater than 1.

    The Replace Rebuild icon will be available for non serialized and non lot-controlled items with a quantity of 1 or more.

    Note: The system will automatically create a rebuild work order if the replaced rebuild details are entered.

    See Creating Work Orders.

  2. Allocate material for issue for the work order (See Materials).

  3. Perform a one-step material issue for the work order. See To perform a one step material issue.

  4. Navigate to the Material Issue page (Maintenance Super User > Home > Stores > Material Issue), and search for the work order with multiple rebuild able items.

  5. Enter the quantity for each rebuild able item to be issued.

    the picture is described in the document text

  6. Click Apply.

To perform multiple rebuild able issues for serial controlled items in a single transaction

  1. Create a work order (status of Released) with rebuild able items with the quantity greater than 1.

    See Creating Work Orders.

  2. Allocate material for issue for the work order (See Materials).

  3. Navigate to the Material Issue page (Maintenance Super User > Home > Stores > Material Issue), and search for the work order with multiple rebuild able serial numbers.

  4. Click the One Step Material Issue subtab.

  5. Enter the quantity for each rebuild able item.

    Note: The Replace Rebuild icon is unavailable if multiple serial numbers are entered for issue.

  6. Click the Replace Rebuild icon to generate automatic rebuild able work orders.

  7. Click Apply.

To perform multiple rebuild able issues for serial controlled items using the two-step method

  1. Create a work order (status of Released) with rebuild able items with the quantity greater than 1.

    See Creating Work Orders.

  2. Allocate the material for issue (See Materials).

  3. Navigate to the Material Issue page (Maintenance Super User > Home > Stores > Material Issue), and search for the work order with multiple rebuild able serial numbers.

  4. Select the serial numbers to be issued.

    The Issue Serial Number page appears.

    the picture is described in the document text

  5. Click Apply.

To perform multiple rebuild able issues for lot controlled items using the one-step method

  1. Create a work order (status of Released) with rebuild able items with the quantity greater than 1.

    Note: The Replace Rebuild icon is unavailable if the quantity is greater than 1.

    See Creating Work Orders.

  2. Allocate the material for issue (See Materials).

  3. Navigate to the Material Issue page (Maintenance Super User > Home > Stores > Material Issue), and search for the work order with multiple rebuild able lot numbers.

  4. Select the lot numbers to be issued.

    the picture is described in the document text

  5. Click Apply.