Item relationship in oracle inventory

Oracle Inventory User's Guide

item relationship in oracle inventory

Use the Item Relationships Listing to list items with related or substitute item relationships. Item relationships are a way of defining acceptable substitutes for. Item Relationships with Oracle Purchasing Within Oracle Purchasing you can define acceptable substitute items for receiving. You must define a list of substitutes before you Oracle Applications Fusion Cloud - Inventory. We have defined item substitute relationship in Oracle Inventory. The relationship is reciprocal. We would like the plan to use PartA or PartB - whatever is.

You can assign the same item to multiple manufacturer part numbers. To associate an item with an existing manufacturer part number Navigate to the Manufacturer Part Numbers window. Assigning Subinventories to an Item You can assign one or more subinventories to an item. You can restrict an item to the list of subinventories by selecting Restrict Subinventories Inventory tab when the item is defined or updated. In these cases you do not have to set the Restrict Subinventories attribute, only establish the relationship between the item and subinventory.

You can also specify planning information and locators for the item in its assigned subinventories.

item relationship in oracle inventory

This information is used to perform min-max planning and replenishment processing at the subinventory level. To assign subinventories to an item Navigate to the Item Subinventories window.

Oracle SCM Functional Guide: Oracle Order Management - Related Items

On the Planning tab, enter a Subinventory to assign to the item. Select whether to use min-max planning for the item in this subinventory. If this subinventory uses PAR Level planning, this field is disabled. If you select Min-Max Planning, enter minimum quantity and maximum quantity for on-hand values. The minimum on-hand quantity at which to place an order. The suggested maximum quantity to maintain as on-hand inventory.

This maximum displays on the min-max report, indicating that any order placed should not force the on-hand quantity of the item to exceed this quantity. If you do not select Min-Max Planning, the item is not planned at the subinventory level for this subinventory. Optionally, enter a locator for the item subinventory.

Defining and Maintaining Item Information

Locators identify physical areas where you store inventory items, and can be used for tracking item quantities by locator location. Optionally, if you are using periodic automated replenishment PAR level counting, then enter a PAR level to define the stock replenishment level. You can assign an item to multiple locators within a subinventory, each with a different PAR level. However you cannot assign multiple PAR levels to the same locator.

To enter order modifier information for the item Select the Order Modifiers tabbed region. Enter the fixed lot multiple quantity for the item. Enter the minimum order quantity for the item in this subinventory. Planning algorithms min-max and replenishment place orders of at least this quantity. Enter the maximum order quantity of the item in this subinventory. Planning algorithms min-max and replenishment place orders no greater than this quantity.

To enter sourcing information for the item Select the Sourcing tabbed region. Select a source type. Fill requests for this item in this subinventory by creating internal requisitions that pull stock from existing inventory. Fill requests for this item in this subinventory by creating purchase requisitions that become purchase orders, procuring the material from a supplier. Fill requests for this item in this subinventory by creating move order requisitions that become move orders, pulling the stock from an existing subinventory.

Enter the organization from which an internal requisition draws the item. You must enter a value here when you select Inventory as the replenishment source type. Enter the subinventory within the source organization from which an internal requisition draws the item. You enter a value here only when you select Inventory as the replenishment source type and you specify a source organization.

To enter lead time information for the item in this subinventory: Select the Lead Times tabbed region. Enter pre-processing, processing, and post-processing lead times. Assigning items to a subinventory does not restrict the subinventory to that list of items. Rather, the items are restricted to that subinventory. Thus, you can always issue and receive unrestricted items to any subinventory, but you can only issue and receive restricted items to their list of subinventories.

This relationship enables you to split support for an item so you do not have to manually split support at contract renewal. To use this relationship, you must be in a planning enabled organization.

INV Item Cross References, Oracle Applications Training

This relationship enables rules based consolidation of contracts. You may use the earliest or latest target end date for consolidation.

item relationship in oracle inventory

This allows you to choose how contracts are consolidated. During contact renewal you are given the option of renewing contracts based on new licenses, or old licenses.

You use the Repair to item relationship with field service operations that use spares management functionality. If a part has been superseded by another part, the Repair to item relationship determines the replacement part.

Log in or register to post comments Book traversal links for Item Relationships. This feature in Order Management enables the user to perform functions such as: Allows the user to suggest a better item to a customer who is placing an order. This occurs when a product is replaced superseded by another product. Allows the user to suggest additional items to a customer who is placing an order. Usability features included in this release include: Notification of the existence of related items by a color change on the ordered item and a message hint.

The ability to have the Related Items window open automatically if desired. Overview of Related Items: The idea is to propose to the customer that they order a larger model or a more deluxe version of the product.

If the up-sell item is then selected, it replaces the item that was originally entered on the order line. Up-selling is the capability to suggest a better item to a customer who is placing an order.