Use custom deletion constraints to enforce specific business rules. Custom deletion constraints prevent the deletion of bills or routings if your data meets the conditions set forth in the constraint.

To create a custom deletion constraint:

1.   Navigate to the Deletion Constraints window:
           
            Inventory->Setup->Items->Delete Constraints
     
2. Enter a name for the deletion constraint.
         
3. Indicate whether the constraint is enabled. An enabled deletion constraint means that it is in effect when the delete concurrent program runs.
         
4. Select what kind of delete entity the constraint applies to: item, bill, routing, component, or operation.
         
5. Enter the SQL Select Statement that the delete concurrent program is to execute. You cannot update SQL statements for predefined deletion constraints.
         
6. Indicate whether to delete if there are rows found or no rows found by the SQL Select Statement
         
7. Enter a failure message from Oracle Application Object Library’s message dictionary to display if the delete fails.

You can define manufacturer part numbers for items. You can use this information for reporting purposes; and in catalog searches for particular items.
Navigate to the Manufacturers window , Enter the name of the manufacturer &  Save your work.

1. Navigate to the Manufacturers window.
2. Choose Parts.
3. Enter a manufacturer part number.
4. Enter an item.
You can assign the same item to multiple manufacturer part numbers.

 

The concept of customer item is to link the customer item with the inventory item of the organization so that the customer can order with their customer item for which we have a refernce to the inventory item. To facilitate the process we use commodity code to group all the customer items.

  • Customer items can be defined at customer category level, customer level and customer ship to level.
  • For a single customer item we can have two differnt inventory items in customer cross reference with rank 1, 2 etc
  • The process of difining customer cross reference is  

1. Define commodity code
2. Define customer item and
3. Enter the customer reference.
Use the Customer Items Summary and Customer Items Detail windows to define and update customer items. You can toggle between these windows with the Summary/Detail option in the Go option on the Toolbar. You can cross reference customer items to your Oracle Inventory items to support processing orders and shipments.

A customer item defined at the Customer level is recognized across all address and address categories for that customer. If you ship an item to multiple customer ship–to sites that have been grouped as an address category, you can define the customer item for that address category. You would define a customer item at the address level if you ship the item to only one ship–to site for that customer.
Commodity Codes
Customer Item Commodity Codes are used to group customer items and can be entered during the definition of customer items.
Navigation : INV -> Setup ->Items -> Customer Item commodity code.

Customer Item1. Select one of the existing Customer Names (in the Details window, you can use either Customer Name or Customer Number,).
2. Select the Definition Level: Customer, Address Category, or Address.
A customer item defined at the Customer level is recognized across all address and address categories for that customer. If you ship an item to multiple customer ship-to sites that have been grouped as an address category, you can define the customer item for that address category. You would define a customer item at the address level if you ship the item to only one ship-to site for that customer.
For the Address Category definition level, enter the address category.
For the Customer Address definition level, enter the customer address.
3. Enter the Customer Item number and description.
4. In the Commodity tabbed region, you can assign the customer item to a Commodity Code.
5. In the Container tabbed region, you can enter the default master and detail containers for this customer item as well as the minimum fill percent for the container.
6. In the Model, Departure Planning tabbed region, you can reference a customer item as a Model by entering the inventory item number of an existing Model item (the BOM Item Type attribute is set to Model).
You can also check Required to indicate that items must be departure planned before they released and Before Build to indicate that ATO items must be departure planned before they are built.
7. In the Demand Tolerances, Active tabbed region, you can enter positive and negative tolerance percentages and select or deselect the Active check box.

Customer Item Cross References
Use the Customer Item Cross References window to define and update cross references between your inventory items and the customer item numbers defined in the Customer Items Summary/Detail windows.
You can also navigate to this window by selecting the Cross Reference button in the Customer Items Summary window. Inventory displays the existing cross references for the customeritem on the current line in the Customer Items Summary window, and you can add new cross references by selecting a new row.
Enter the Rank as a positive number. To permit alternate or substitute inventory items for a customer item, you can define multiple cross references to inventory items for a single customer item. In these cases, you must specify the Rank of the cross reference. The highest rank is 1.

Cross–reference types define relationships between items and entities such as old item numbers or supplier item numbers. For example, you can create a cross–reference type Old to track the old item numbers, and a type Supplier to track supplier part numbers.

Navigate to INV : Items -> Cross reference , Enter a unique cross–reference type name and save it.
Click on Assign an old/supplier item and its corresponding inventory item.

1. item in cloumn1 represents a current inventory item
2. Indicate whether the cross–reference applies only in the specified organization or to all organizations to which the item is assigned
3. Enter a cross–reference value. This value is the entity you cross–reference to the item, such as its old item number or supplier part number.
Cross reference can also be attached from tools in item master
The User Item Type item attribute is a QuickCode you use when you define an item. You can use the types provided by Oracle Inventory or create your own.
Setup Steps
1. Navigate to the Item Type QuickCodes window. The User access level is selected indicating you can add or modify  QuickCodes without restriction.
2. Enter a unique alphanumeric code describing the item type. You can define a maximum of 250 QuickCodes for a single QuickCode type.
You cannot change the values in this field after saving them. To remove an obsolete QuickCode you can either disable the code, enter an end date, or change the meaning and description to match a replacement code.
3. Enter the meaning of the item type. Inventory uses this value in the list of values for the User Item Type item attribute in the Items window.