Material Status Control

This chapter covers the following topics:

Overview of Material Status

Material status control restricts the movement and usage of portions of on-hand inventory. Using material status control enables you to control whether you can pick or ship an internal order or sales order, or issue material for a work order. You can also specify whether material needs to be quarantined until you inspect it. In addition, you can determine whether products with a particular status can be reserved, included in available to promise calculations, or netted in production planning. You assign material statuses at four levels: subinventory, locator, lot, and serial.

You assign subinventory and locator statuses in the subinventory and locator windows. The location status applies to the material in the location and not the location itself. To assign a material status to a lot or serial, you must first enable the item attributes Lot Status Enabled, and Serial Status enabled on the item in the Item Master. You can also optionally assign a default lot or serial status to an item on the Item Master. When you receive the item, the system automatically assigns the default lot or serial status to the item. The lot or serial status remains the same through all inventory transactions including organization transfers. If necessary, you can change the material status at receipt, or use the material workbench or mobile status update page to modify the material status. For more information about setting up lot and serial statuses see Inventory Attribute Group.

You can track on-hand material status at the Subinventory, Locator, or Lot levels. You will also track by on-hand balance levels. After the on-hand status is activated, it will be always available to track and cannot be disabled for a status.

Note: After the status is enabled, it cannot be disabled or set to a null value. Also, after the status is set, the material status window for each status will have the on-hand status tracking activated, and this option cannot be deselected.

When material status is tracked at the on-hand level for an organization, the material status that is assigned at the Subinventory, Locator, or Lot levels serves as the default value for the on-hand level material status (the on-hand material is associated with a status). To enable the On-hand Material Status tracking option, run the Activate Onhand Level Material Status Tracking concurrent request.

On-Hand Balance Material Status

Oracle Inventory enables you to assign the material status in the UI (user interface) to new receipt transactions so that the on-hand records have the material status you specify. Common material statuses include Active, Immature, Expired, Obsolete, Hold, Quarantine, and Rejected.

You can assign a material status to on-hand records during the following receipt transactions:

The material status can be assigned when performing transactions from:

Assigning a material status during receipt provides the following benefits:

Note: Oracle Warehouse Management also provides material status controls. For more information, see Oracle Warehouse Management User's Guide, Material Management.

Material Status Transactions

A material status is a combination of transactions and planning actions that you choose to disallow in a particular circumstance. Disallowed transactions and planning actions are cumulative. When you set up transaction types, you determine whether some transactions can be restricted by material status. The transactions for which you enable status control in the Transactions Types window appear in the Material Status Definition window. If you do not enable status control for a transaction type, then the transaction type is always allowed.

You can also assign the planning attributes Allow Reservations, Include in ATP, and Nettable to the material statuses that you create. When you transact an item, the system checks all of the material statuses. If the system finds a status that disallows the transaction, whether at the serial, lot, locator, or subinventory level, then the transaction fails.

The following table provides examples of material statuses that you might set up for your organization. In this example, each status either allows or disallows certain transactions. For example, the material status of Active allows all transactions and disallows no transactions. Conversely, the material status of Immature allows picking and shipping for internal customer orders, but disallows these transactions for external customer orders.

Status Transactions Allowed Transactions Disallowed
Active Everything Nothing
Hold Subinventory transfers Picking, shipping, and production
Immature Picking and shipping for internal customers Picking and shipping for external customers
Almost Mature Picking for customer Shipping for customer

Setting Up Material Status Control

Before you set up material status codes, you need to identify the transaction types to restrict.

  1. Navigate to the Material Status Definition window.

    the picture is described in the document text

  2. Enter a name and a description for the material status.

  3. Verify that the Enabled check box is selected. Deselect the Enabled check box if you do not want to use the material status.

    Note: You cannot disable a material status that the system currently uses. Verify the material status is correct before using it in transactions.

  4. Select Allow Reservations. If you select this check box, then you can view material associated with this status in the Item Reservations window. You can create a reservation against the material, and the system includes it in the available to reserve calculations. See Item Reservations for more information.

  5. Select Include in ATP if you want material associated with this status to be eligible for available to promise. The system then includes material with this material status in available to promise calculations.

  6. Select Nettable to include material that is associated with this material status with main planning.

    Note: You cannot apply a status that is non-reservable, non-nettable, or non-ATPable to serials.

  7. Indicate whether this status is used at the subinventory, locator, lot, serial, or on-hand level. Consider the following uses:

    • Subinventory: For example, if you select subinventory, the system enables you to assign the material status at the subinventory level.

    • On-hand: Enables checking of material status at the on-hand level.

    Important: The material status for an inventory organization should be set up at either the on-hand level OR the subinventory/locator/lot level. For example, if the on-hand material status is used, and there is on-hand material for the specific SKU, then the system obeys only the on-hand status, not the subinventory/locator/lot status.

  8. In the Allowed Transaction column, select a transaction that you want to disallow and click the greater than button. To move a transaction from the Disallowed Transactions column to the Allowed Transactions column, select the transaction, and click the less than button.

  9. Repeat the previous step to disallow additional transaction types.

  10. Save your work.

Related Topics

Defining and Updating Transaction Types