Creating New Items

Items are used to represent:

Each item that you create in the catalog has several standard operational attributes that determine the behavior of the item with respect to various functions such as Purchasing, and Inventory Management. In addition to these operational attributes, the item has several user-defined attributes defined by its item catalog category. These user-defined attributes can capture item specifications and other information relevant to the product definition.

You can choose from multiple methods to create a new item:

If the item catalog category specified when creating the item requires an item request approval, proceed to Creating New Item Requests after you create the item.

Warning: It is possible to create duplicate items if two users simultaneously create the same item using any of the above methods. To prevent this problem, create a unique index for the MTL_SYSTEM_ITEMS_B table. For more information about creating this index, refer to My Oracle Support Doc ID 383195.1.

arrow icon   To create a new item:

  1. From the menu, select either Create Engineering Items or Create Production Items.

    Note: The only difference between these two menu choices is whether or not the Engineering Item box is pre-selected.

  2. On the Create Item page, enter values in the following fields:

  3. On the Create Item: Enter Number/Description page, enter the required information. Optionally, you can update the primary attribute values (for multiple items, click the Show link to view the primary attributes).

    The item catalog category definition determines the new item's generation method. The item number already appears when the item catalog category specifies that it is Sequence-generated. If the category specifies that the item number or item description is User Entered, then enter an item number or item description. A Function-generated item number or item description is generated after the item and description attributes are entered.

  4. Click Finish.

    If you created one item, the system creates the item and returns you to the item Overview page (the item workbench) where you can further define the item or change attribute values. If you created more than one item, the system notifies you that the items have been submitted for creation and provides the Concurrent Request ID.

    If the item's catalog category requires approval, a warning message appears in the item workbench stating that this item does not have an associated new item request. The item's status remains as Pending with an approval status of Not Submitted for Approval until a new item request is created and approved. See: Creating New Item Requests.

Optionally, you can now update item characteristics using the item workbench subtabs:

arrow icon   To create copies of an existing item:

If you are familiar with an item in the same item catalog category in which you wish to create a new item, then you can save time by creating the new item from an existing item. When you copy an item, select the attribute groups and attachment categories to copy; also choose whether or not to copy people and organizational assignments (you can add new manufacturer part numbers, but you cannot copy existing ones). You can modify the copied information to define the new item's specifications.

Note that you must have the appropriate privileges to copy the item's user-defined attributes, operational attributes, attachments, people, and organizational assignments. For example, if you wish to copy the item's attachments, you must have--at a minimum--the View Item Attachments List privilege. Likewise, if you want to copy the item's people, you must have the View Item People List privilege for the base item.

  1. Follow the same steps as described above in "To create a new item:", except in the Create field, select Copies of an Existing Item. You can then enter the item and revision to copy.

  2. In the Copy Item Details region, select the sequence in which to copy the template item details and the copied item details. Select which specific item details (such as item attribute groups, attachment categories, and people) to copy.