Item Relationships

You can define relationships between items. This allows you to search for items through these relationships. Except in Oracle Purchasing, these relationships are for inquiry and reporting purposes only.

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 receive a substitute item in place of an originally ordered item. Attention: If you receive a substitute item, you must have previously defined a unit of measure conversion between the unit of measure on the purchase order and the unit of measure on the receipt.

 
Cross–Sell: This relationship indicates that one item may be sold in lieu of another item.

Up–Sell: This relationship indicates that a newer version of the item exists, and can be sold in place of the older item.

Service: This relationship establishes service items for a repairable item.

Prerequisite: This relationship indicates that you must possess one of the items as a requirement to possessing the other item.

Collateral: This relationship indicates collateral, such as marketing brochures, that you possess for an item.

Superceded: This relationship indicates that one item has replaced another item that is no longer available.

Complimentary: This relationship indicates if a customer purchases one item, the other item is received for free.

Impact: This relationship is used to relate items to each other but only under special conditions.

Conflict: This relationship indicates that these items may never be used together.

Mandatory Charge: This relationship indcates a mandatory charge if the customer purchases both items.

Optional Charge: This relationship indicates an optional charge if the customer purchases both items.

Promotional Upgrade: This relationship enables a customer to upgrade from one item to another item or equal or higher value, without an additional charge.

Split: 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.

Merge: This relationship enables rules based consolidation of contracts. You may use the earliest or latest target end date for consolidation. This allows you to choose how contracts are consolidated. To use this relationship, you must be in a planning enabled organization.

Migration: During contact renewal you are given the option of renewing contracts based on new licenses, or old licenses. To use this relationship, you must be in a planning enabled organization.

Repair to: 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.