• Home   /  
  • Archive by category "1"

Oracle Item Category Assignment Open Interface Toms Sc430

Inventory | Thursday, August 7, 2014

Use the Item Open Interface to Quickly Add or Update Inventory Items

By: Todd Cerny| Principal Technical Support Engineer

WHAT, time is of the essence when creating your Inventory items!?!? You need to create items, update existing items, item revisions, or update an item attribute from one value to another, posthaste? No worries, Oracle Inventory has the exact functionality needed in the Item Open Interface (IOI). See document How to use the Item Open Interface (Doc ID 1457314.1).

The IOI process is used to create new items and/or update existing item attribute(s). You have the ability to use templates for mass changes or simply change individual attributes. The IOI process can be especially helpful when loading items during a new install or when upgrading.

Doc ID 1457314.1 and the IOI provide ultra helpful item information like the minimum number of columns needed to create an item:



This is just the tiny tip of the iceberg on how this amazing process can increase the speed of updating your items. For full details see Doc ID 1457314.1. Using the IOI process will have you looking like an items update expert in no time at all! Make importing and/or updating your Inventory items an enjoyable process by using the Item Open Interface!
Skip Headers

Using the Item Catalog

This chapter covers the following topics:

Browsing the Item Catalog and Alternate Catalogs

You can browse the hierarchically structured item and alternate catalogs from the application tree menu "Browse Catalog" link. You can also browse the item catalog, but not alternate catalogs, from the Setup Workbench. Expand and collapse levels in the hierarchy to view the current structure of the catalog. You can only browse catalogs for which you have the Catalog Viewer role.

To browse a catalog

  1. In the Items section of the Application tree menu, click the "Browse Catalog" link.

  2. In the Browse Catalog page Catalog field, select either the Item Catalog or another catalog.

  3. In the Categories field, choose to view all categories for the catalog or only the active categories.

  4. Click the Show/Hide link to search for item catalog categories by Name or Description. After entering the search criteria, click Go.

  5. To view the items associated with the item catalog category, select the item catalog category.

    All items associated with the item catalog category and its child categories are listed below.

  6. Click the focus icon next to the desired item catalog category to display it at the top level.

To perform actions on an item within a catalog category

The actions you can perform on items vary depending on whether you select a category within the Item Catalog or another catalog.

From an Item Catalog category, you can select items and perform the following actions:

  • create a new item request

  • add items to a new catalog category

  • add items to an existing catalog category

  • generate a report

  • create a change order, change request, or issue

  • change the lifecycle

  • change the item catalog category

  • compare items

  • add to the Favorites list

  • export all items in the category to a spreadsheet

  • remove items from the catalog category

From any other catalog, you can select items and perform the following actions:

  • create a new item request

  • create a change order, change request, or issue

  • generate a report

  • compare items

  • add to the Favorites list

  1. Complete the steps in To browse a catalog above, then select one or more items.

To export all items to a spreadsheet

  1. Click Export All Items to export all items in the category to a spreadsheet.

To perform all other actions

  1. In the Select Items field, select one of the following actions, then click Go.

To search or browse the item catalog from the Setup Workbench

  1. In the Applications tree menu, click the "Setup Workbench" link.

    On the Search: Item Catalog Categories page, click the Catalog Hierarchy link or the Catalog Hierarchy icon.

    Note: You can only browse the item catalog using this method.

    Tip: In the Search: Item Catalog Categories page, you can also search for item catalog categories by entering search criteria for a category name, description, or parent category.

    When you enter a search string, the wildcard character "%" is appended to the input. For example, entering "mem" enters the search string "mem%", so that the "memory" catalog category could be returned in the search results. If you wish to search for entries that end with a particular string, such as "log", you can type in "%log", and all entries ending in "log" are returned. If you do not enter a search string in the text box, an error is returned.

Related Topics

Overview of Item Catalogs, Oracle Product Information Management Implementation Guide

Overview of Catalogs, Oracle Product Information Management Implementation Guide

Assigning an Item to a Category

Copying Items with Category Assignments

Updating Item Catalog Categories

It is likely that you will need to update item catalog categories at some point--you may need to change an item catalog category so that it can be used for item creation, or modify the inactive date so that the item catalog category will no longer be used. Often, users simply need to correct a mistake or reclassify the item catalog category due to shifting relationships within the item catalog category hierarchy.

To update an item catalog category

  1. On the Search: Item Catalog Categories page, search for the item catalog category you want to update and click the corresponding link.

  2. On the Basic Information page for the item catalog category, click Update.

  3. On the Create/Edit Item Catalog Category page, enter or change the following information:

    Catalog (required)

    Defines the item catalog category name. The number of segments (and respective labels) for the item catalog category depends on how the item catalog group flexfield is defined in Oracle Inventory setup.

    Description

    Optionally enter a brief description of the item catalog category.

    Parent Item Category

    If at any time a parent item catalog category has been created for this item catalog category, then you cannot leave this field blank. In other words, once you have defined a parent for an item catalog category, you always have a parent item catalog category. Also, if a parent item catalog category has already been defined, then you can only choose the item catalog category's siblings, its sibling's children, or the current parent item catalog category, as a parent item catalog category.

    Note: For item catalog categories with versions, once the item catalog category is released, you cannot change the parent item catalog category.

    Item Creation Allowed

    Select to specify that items in the item catalog category can be created (if you do not select, the item catalog category only serves the purpose of being a placeholder in the item catalog category hierarchy). If item creation is not allowed, the item catalog category will typically specify characteristics (attribute groups, etc.) that are inherited by its descendants.

    Inactivate

    Optionally specify a date on which the item catalog category will become inactive. You cannot specify an inactive date that is later than the inactive date of an item catalog category's parent, nor can you specify an inactive date that has already passed. Thus, all children of a parent item catalog category with an inactive date should be made inactive at the same time or earlier. Making an item catalog category inactive has the following implications:

    • You cannot create items of that item catalog category or any of its descendants.

    • You cannot use that item catalog category or any of its descendants as the parent item catalog category upon creation of an item catalog category.

    Note: After you've updated an inactive date, the change propagates to all of the item catalog category's children.

  4. Click Apply.

Related Topics

Defining Item Catalog Categories, Oracle Product Information Management Implementation Guide

Assigning an Item to a Category

When you create an item, it is automatically assigned to the default mandatory item catalog and default category of the functional area in which it is created. You can override the item catalog's default category as well as manually assign the item to an unlimited number of catalogs.

To assign an item to an existing category from the item's Classifications and Categories page

This explains how you can change an item catalog category as well as assign an item to one or more existing catalog categories.

  1. In the Applications tree menu, use either the "Simple Search" or "Advanced Search" links to search for the item whose category you wish to change.

  2. Click the item's link in the search results.

  3. On the Overview page, select the Classification and Categories link.

  4. On the Classification and Categories page, click Update. After the page refreshes, click Add Assignment.

  5. Select a catalog and then a category within that catalog.

    If Enforce List of Valid Categories is enabled in the catalog definition (See: Defining Catalogs, Oracle Product Information Management Implementation Guide), then you can only choose from the list of valid categories defined for that catalog. Otherwise, you can choose any category that has the same flex field structure as the catalog.

    If Allow Multiple Item Category Assignments is disabled in the catalog definition (See: Defining Catalogs, Oracle Product Information Management Implementation Guide), then you can assign an item to only one category in the catalog. Otherwise, you can choose to assign the item to multiple categories in the catalog.

    In a hierarchical item catalog, you can only assign items to leaf categories.

    Tip: If you want to add the selected items to more than one catalog category, click Add Another Row to search for and select another catalog/category combination.

  6. Click Apply.

To add items to an existing catalog category from the Browse Catalog or Search Results page

Using this method, you can select one or more items and assign them to existing catalog categories from the Browse Catalog or Search Results page.

  1. Browse the item catalog or another catalog. Select the items within a catalog category that you want to add to an existing catalog category. See: Browsing the Item Catalog and Alternate Catalogs

    Alternatively, search for one or more items. In the Search Results page, select the items that you want to add to an existing catalog category. See: Searching for Items

  2. In the Select Items field, select the Add to Existing Catalog Category action, then click Go.

  3. The Add to Existing Category page appears. In the Catalog field, search for and select a catalog.

  4. In the Category field, search for and select a category.

  5. If you want to add the selected items to more than one existing catalog category, then click Add Another Row.

  6. If you decide not to add the items to a catalog category, you can either remove the items or remove the catalog category by selecting it, then clicking either Remove for the selected categories or Remove for the selected items.

  7. Click Apply.

To add items to a new catalog category from the Browse Catalog or Search Results page

In addition to creating new catalog categories in the Setup Workbench (see: Defining Catalog Categories, Oracle Product Information Management Implementation Guide), you can create a new catalog category from the Browse Catalog and Search Results pages and add items to it in one flow of steps.

  1. Browse the item catalog or another catalog. Select the items within a catalog category that you want to add to a new catalog category. See: Browsing the Item Catalog and Alternate Catalogs

    Alternatively, search for one or more items. In the Search Results page, select the items that you want to add to a new catalog category. See: Searching for Items

  2. In the Select Items field, select the Add to New Catalog Category action, then click Go.

  3. In the Add to New Category page, Catalog field, search for and select the catalog to which you want to add a new category.

    Caution: You can only select those catalogs for which you have the Manage Catalog privilege.

  4. The Catalog Category field appears. Enter a unique name for the new catalog category.

    Caution: If the search/list of values icon appears next to the Catalog Category field, this means that a value set is assigned to the flex structure associated with the catalog. Any new catalog category name must be a value from this value set that has not been previously used to create a catalog category.

    When you use the list of values icon to search for a value within the value set, you are able to search on all values, including the values already used to create categories. If you select a value that is already assigned to a category, an error appears only after you try to create the new category.

    To avoid this problem, select a catalog that uses free form category creation rather than one based on a value set.

  5. Optionally, enter a description for the catalog category.

  6. Optionally, enter a parent category for the new category.

    The Parent Category field only appears if the catalog's Enable Hierarchy for Categories field is set to No (see: Defining Catalogs, Oracle Product Information Management Implementation Guide).

  7. Optionally, in the Inactive On field, enter the date when you can no longer assign this catalog category:

    • As the default category of a new catalog

    • As a valid category of a catalog

    • To an item

    • As a valid category of an item catalog category

  8. Optionally, you can select any items and click Remove if you no longer want to include them in the new catalog category.

  9. Click Apply.

Related Topics

Overview of Item Catalogs, Oracle Product Information Management Implementation Guide

Overview of Catalogs, Oracle Product Information Management Implementation Guide

Browsing the Item Catalog and Alternate Catalogs

Searching for Items

Copying Items with Category Assignments

Changing an Existing Item's Item Catalog Category

Warning: Before changing an item's ICC, consider the potential loss of user defined attribute data. If attribute groups associated with the existing ICC are not associated with the new ICC, then the item's attribute data for these attribute groups will be lost once the ICC changes.

See: Associating Attribute Groups with an Item Catalog Category, Oracle Product Information Management Implementation Guide

You can change an item's item catalog category (ICC) with the following exceptions:

  • You cannot change the ICC for style items that have SKU items.

  • For style items, the new ICC must have variant attribute groups.

  • You can only change the ICC of items for which you have the Edit Item and the Change Item Status privileges.

  1. In one of the following pages, select the item(s) for which you want to change the item catalog category.

    Alternatively, you can change the ICC from the item's Overview page.

    Warning: If ICC versions are enabled, use one of the HTML interface options as described above to change an item's item catalog category rather than the Forms interface to avoid data corruption. Forms behavior has not been enhanced to support ICC versions.

  2. Select Change Item Catalog Category from either:

    • the Select Items field in the Browse Catalog or Search Results page.

    • the Actions field in the item's Overview page.

    Click Go.

  3. In the Change Item Catalog Category page, search for and select a new ICC, then click Go.

    Note: Items you selected for an ICC change do not appear in the Change Item Catalog Category page when the following conditions apply:

    • The items selected are style items with SKU items.

    • The items selected are style items and the new ICC has no variant attribute groups.

    • You do not have the Edit Item and the Change Item Status privileges for the item(s).

  4. Optionally, you can select new values for the following fields:

    • New Lifecycle

    • New Lifecycle Phase

    • New Item Status

    Any new values selected apply to all items in the list.

  5. Optionally, select any items to remove from the list of items for which you plan to change the ICC. Click Remove.

  6. Click Continue.

  7. In the Change Item Catalog Category: Review Details page, for each item in the list, enter the following field values if you did not enter these field values for all items previously.

    • New Lifecycle. Optional.

    • New Lifecycle Phase. Optional.

    • New Item Status. Required.

  8. Click Finish.

Related Topics

Browsing the Item Catalog and Alternate Catalogs

Searching for Items

Assigning an Item to a Category

Copying Items with Category Assignments

When you assign an item to another organization, the system copies the item level catalogs, organization level default catalog, and the associated categories assigned in the item master organization. For example, if you manually assign an organization item level catalog to the item in the master organization, the system does not copy over that organization item level catalog when you assign that item to another organization.

After assigning an item to another organization, you can disable the item for one or more functional areas in the new organization. However, the system does not remove the corresponding functional area's default catalog. For example, you may have set the value of the Purchased attribute to "Yes" when you defined the item in the item master organization. When you assign this item to another organization, the system copies over the "Yes" value of the Purchased attribute, and therefore assigns the default catalog of the Purchasing functional area. In the new organization, you may decide to set the value of the Purchased attribute to "No." After you disable the item for the Purchasing functional area in the new organization, the item still retains the Purchasing default catalog. You may manually delete the Purchasing catalog in the new organization.

If you copy an object with item catalogs defined at the organization level, the system assigns the new item the default categories of the mandatory catalogs, even if the original item did not have the default categories. This occurs because the system copies the values of the item defining attributes and not the item catalogs and categories themselves.

Assigning Suppliers to Items

Assigning suppliers to items enables you to assign attributes, perform actions, and make rules that only apply to that item/supplier combination. For example, if you choose not to assign suppliers to items, you can assign attributes at:

  • the master item level - all attributes defined at this level apply to the item across all organizations and all suppliers.

  • the item organization level - all attributes defined at this level apply to the item only in this particular organization.

If you choose to assign suppliers to items, you can also assign supplier sites to items. For example, a supplier manufactures an item in two locations, San Francisco and Denver (the supplier sites). The characteristics of the item differ slightly depending on which supplier site ships to your retail store (organization). In this example, you can assign attributes at the following levels, in addition to the item and item organization levels described above:

  • item supplier - all attributes defined at this level apply to this item and supplier combination.

  • item supplier site - all attributes defined at this level apply to this item and supplier site combination.

  • item supplier site organization - all attributes defined at this level apply to this item, supplier site, and your organization combination.

The following graphic depicts an item supplied to a company's retail stores, either directly to the store or through a warehouse. The suppliers can ship the item from more than one manufacturing plant (supplier site). In this scenario, a store either receives the item from it's warehouse or directly from a supplier. Supplier 1 ships to the warehouse, which then ships the item to the store, while supplier 2 ships the item directly to the store. The item attributes differ slightly, depending on which supplier, and even which supplier site, ships the item.

Note: Some users question how item supplier associations relate to the Approved Supplier List (ASL). The item supplier associations serve a different purpose than the Approved Supplier List. The item supplier associations can tell you which supplier and/or supplier location supply an item, but not whether the supplier is approved.

To assign a supplier and supplier site to an item

  1. In the Item Overview page, select the Associations subtab. Select Supplier and Supplier Site Assignment from the left side of the page.

  2. From the Supplier and Supplier Site Assignments page, click Assign.

  3. In the Assign Items to Suppliers: Select Suppliers page, enter at least one of the following to identify the supplier, then click Next.

    • Supplier Name

    • Supplier Number

    • DUNS Number

    • Tax Payer ID

    • Tax Registration Number

    Tip: Check the Show Supplier Sites box to narrow your search for specific suppliers and supplier sites. Checking this box enables you to enter supplier site information.

  4. In the Assign Items to Suppliers: Review Supplier Results page, select the supplier and/or the supplier sites listed. Click Next.

    This page lists the supplier and all supplier sites for the supplier.

  5. In the Assign Items : Review Results page, review supplier and supplier sites selected. Click Finish.

    If the supplier and supplier sites selected are incorrect, click Back to correct the error.

To assign a supplier site and organization to an item

The process of assigning a supplier site and organization to an item is similar to the process described above of assigning a supplier and supplier site to an item, but with one more step - assigning an organization to the item supplier site.

  1. In the Item Overview page, select the Associations subtab. Select Supplier Site Organization Assignment from the left side of the page.

  2. Assign a supplier site as described above in "To assign a supplier and supplier site to an item:".

  3. In the Assign Items to SupplierSites-Org: Select Organizations page, enter an organization code, name or hierarchy. Click Next.

  4. Review the organization selected and click Next again.

    Click Back if you want to change the organization.

  5. In the Assign Items: Review Results page, you can review the supplier, supplier site, and organization assigned to the item. Click Finish.

    Click Back if you want to change the supplier, supplier site, or organization.

To view and update item supplier, item supplier site, or item supplier site organization attributes

You can view or update a single item supplier association from both the Supplier and Supplier Site Assignments page and the Supplier Site Organization Assignment page. To update all item supplier associations at once, you must import the changes using a spreadsheet.

To view and update attributes for a single item/supplier/supplier site/organization association

  1. Navigate to either the Supplier and Supplier Site Assignments page or the Supplier Site Organization Assignment page.

  2. In the Advanced Search region, search for and select an item/supplier/supplier site/organization intersection.

  3. In the Supplier Assignment detail region, select the Attributes tab, then click Update.

  4. Enter any changes to the item/supplier/supplier site/organization intersection attributes, then click Apply.

To view and update attributes for all suppliers, supplier sites, or supplier site organizations at once

  1. Navigate to either the Supplier and Supplier Site Assignments page or the Supplier Site Organization Assignment page.

  2. Click the appropriate button:

    • Update Supplier Attributes

    • Update Supplier Site Attributes

    • Update All Attributes (on the Supplier Site Organization Assignment page)

  3. Select a display format to download, then click Export.

    Note: The display format you select must contain attributes controlled at the appropriate level. For example, if you want to update supplier site attributes, the display format must contain attributes controlled at the supplier site level.

    See Updating Existing Items Using a Spreadsheet for a detailed description of how to export, make changes, and import those changes.

To view and mass update item supplier, item supplier site, or item supplier site organization attributes

  1. For item supplier and item supplier site attributes, navigate to the Supplier and Supplier Site Assignments page. For item supplier site organization attributes, navigate to the Supplier Site Organization Assignment page. Select the supplier, supplier site, and/or organization intersection for which to view or update attributes.

  2. Click one of the following:

    • Update Supplier Attributes

    • Update Supplier Site Attributes

    • Update All Attributes - use for updating the item supplier site organization intersection attributes.

    Tip: You can update the item supplier and item supplier site attributes from the Supplier Site Organization Assignment page. For the selected item supplier site organization, click the Supplier and Supplier Site Assignment tab. All item supplier and item supplier site intersections are listed. Click the Additional Attributes icon for a particular row, then click Update.

  3. Select a display format that contains attributes controlled at the intersection level selected. Click Export.

  4. Select the application on your desktop to use for viewing the exported document. Click Next.

  5. Choose whether to open or save the exported spreadsheet document.

  6. Update the attributes, then save the spreadsheet to import later.

    See: Managing Item Imports

To view and update item-supplier formal packs

  1. Navigate to the Supplier and Supplier Site Assignments page, then select the Formal Packs tab.

  2. To update the pack type, select the Pack Type to use with the selected supplier or supplier site, then click Create Change Order.

    See: Managing the Packaging Hierarchy and Creating a SKU Packaging Hierarchy.

To view, create, and update item-supplier change orders

You can create a change order for:

  • adding or removing a supplier or specific supplier site to or from an item

  • updating item supplier, item supplier site, or item supplier site organization attributes

  1. For item supplier and item supplier site assignments and attributes, navigate to the Supplier and Supplier Site Assignments page. For item supplier site organization assignments and attributes, navigate to the Supplier Site Organization Assignment page. Select the supplier, supplier site, and/or organization intersection for which to view or update attributes.

  2. Click Create Change Order. See: Creating Change Orders

To inactivate an item supplier, item supplier site, or item supplier site organization association

Once you assign an item to a supplier, supplier site, or supplier site organization, you cannot delete this relationship. You can inactivate the relationship, though. In the (item/supplier/supplier site/organization) Assignment: Update Attributes page, change the Status attribute to Inactive.

Related Topics

Approved Supplier List, Oracle Purchasing User's Guide

Entering Suppliers Manually, Oracle Payables User's Guide

Adjusting Suppliers (Adding a New Supplier Site), Oracle Payables User's Guide

Finding Suppliers, Oracle Payables User's Guide

Searching for Items

You can perform searches using keywords that may be part of an item number, item catalog category, manufacturer, manufacturer part number, short description or long description. Keyword searches enable you to search using any or all keywords. You can enter additional keywords to be excluded from a search. For example, the keyword search for “SRAM” may return results that include all items that have “SRAM” in the item name, description, or an attribute value. A Wildcard search enables you to enter the percent (%) sign before and/or after a keyword. For example, a search using “mo%” may return “Monitor” and “Mouse,” but a search using “mon%” would return “Monitor.” A Fuzzy Search enables you to look for records that closely resemble or sound like your word(s), but are spelled differently. For example, a search for “telefone."

Keyword search options include:

  • Exact match

    Enter search criteria for a specific word.

  • Word positioning

    Search using a particular phrase such as “optical sensors relay,” or search for words near each other, such as “optical NEAR relay.”

  • Inexact match

    Search for words that sound like your word to account for common spelling and typing errors.

  • Intelligent match

    Search for an item by entering a word that is about something like a theme--for example searching by the word 'Car' can result in items such as Convertibles, Coupes, and Sedans without having the word car in the item name. You may also ignore the noise words such as 'the', 'of'. A default list of noise words (a stop list) is supplied for each European Language.

  • Non-alphanumeric characters

    You may choose to search with '-' (or other non-alphanumeric characters) as part of the item name such as AS-18947.

  • Boolean combinations

    Combine terms described above using the operators: AND, OR, and NOT.

  • Stemming search

    Search for relevant items. For example, entering the word “pen” returns results that include items like pens and pencils.

The system also enables you to search for items based on item revision attribute values. For example, if the horsepower of an engine has changed from 200 hp to 220 hp between revisions A and B, searching for an item revision with the horsepower attribute value of 220, will return only revision B.

To perform a simple item search

  1. On the Simple Search page, enter as many keywords as possible in the Keyword Search field. For example, entering "CRT Color Monitor" would return more relevant results than simply entering "Monitor." To specify that the search uses all the keywords entered, select Match all word(s) (AND). To specify that the search use any of the keywords entered, select Match any word(s) (OR).

  2. To exclude a keyword from the search, enter it in the Without Keyword(s) field. For example, entering the keywords "Flat LCD Monitor" without the keyword "black " returns all "Flat LCD Monitors" that are not black.

  3. Click Search.

    • Enter % (wildcard) before and/or after a keyword to perform a wildcard search. For example, a search for "mo%" returns Mouse and Monitor; a search for mon% returns Monitor.

    • Include "$" before the item name to perform a stemming search. This indicates that you want to search for items whose spelling is derived, or stems from the keyword. For example, a search on the keyword "$contract" could return: "contract," "contracts," "contracted," and "contracting."

    • Include "?" before the item name to perform a fuzzy search. This indicates that you want to search for items whose spelling is close to the actual item for which you are performing the search. The search engine looks for records that closely resemble the words you have entered, but that are spelled differently. The search returns results that have items with that term in either its name or description. Hence, entering the keyword "?telefone" also would return "telephone."

    • Simple Search is case-insensitive.

    As mentioned above, Item simple search supports wildcard, fuzzy and stemming search. However these different types of search are supported only in certain languages. The following table summarizes the search features and the supported languages.

    LanguageWildcard (%)Fuzzy (?)Stemming ($)
    English Yes Yes Yes
    German Yes Yes Yes
    Japanese No Yes No
    French Yes Yes Yes
    Spanish Yes Yes Yes
    Italian Yes Yes Yes
    Dutch Yes Yes Yes
    Portuguese Yes Yes No
    Korean Yes No No
    Simplified Chinese No No No
    Traditional Chinese No No No
    Danish Yes No No
    Swedish Yes No No
    Finnish Yes No No

To perform an advanced search

Note the following tips and restrictions before conducting an advanced search:

  • Providing values for the indexed attributes improves performance during the search.

  • If no search criteria template is used, you must add your own criteria to be used for the search.

  • If no display format template is used, the following columns will be the default for your search results: Item, Item Catalog Category, Description, and Item Revision.

  • All Advanced Search operators are case-sensitive, except for the operator "contains".

  1. On the Advanced Search page, select an Item Catalog Category and click Go. This determines the search criteria templates that are available to use for this particular search.

    Note: You are not required to search by or select a catalog category. If you do not, the default system search criteria template appears.

    You can also optionally search by Organization and Revision. To search by item revision specific attributes, select the type of Revision on which to base the search. Following are the types of revisions available:

    • All

      Searches for all (past, current and future) revisions.

    • Latest

      Searches for the most current effective revisions that are not yet implemented.

    • Production

      Searches for the revisions that are currently implemented.

  2. Select a search criteria, add or delete attributes and enter values to define your parametric search. You must include at least one indexed attribute in your search. You can select and preview a display format for the search results.

    Note: For details about how to use search criteria and display formats to assist in your advanced search, see Managing Search Criteria, Oracle Product Information Management Implementation Guide and Managing Display Formats, Oracle Product Information Management Implementation Guide.

  3. Click Search.

    The Search Results page appears.

    You can view the AML or Manufacturer Part Numbers for an item in the item search results page within the show/hide region.

To perform actions on items in the Search Results page

You can select items and perform the following actions:

  • create a new item request

  • add items to a new catalog category

  • add items to an existing catalog category

  • generate a report

  • create a change order, change request, or issue

  • change the lifecycle

  • change the item catalog category

  • compare items

  • add to the Favorites list

  • export all items in the category to a spreadsheet

  1. Complete the steps in To perform a simple item search or To perform an advanced search above, then select one or more items.

To export all items to a spreadsheet

  1. Click Export All Items to export all items in the category to a spreadsheet.

To perform all other actions

  1. In the Select Items field, select one of the following actions, then click Go.

Managing Favorite Items

The Favorite Items list provides you a mechanism for creating and managing lists of your favorite or bookmarked items. You can add items to your Favorite Item list from the Search Results page, or while browsing--there are a number of contexts from which the Favorite Items link is available. The following steps describe just one of these contexts.

To add an item to your favorite items list

  1. Navigate to the Favorite Items page by clicking the Favorite Items link in the Items section of the Applications tree menu. You can also get there by navigating to any item Search or Browse page and clicking the Favorite Items tab.

  2. On the Favorite Items page, click Add Favorite Item.

  3. On the Advanced Search page, search for item you wish to add to your favorites list.

  4. On the Search Results page, select the items you wish to add and select Add to Favorites in the Action menu and click Go. A message acknowledging the successful addition of the item to your favorites list appears at the top of the page.

To manage your favorite items list

  1. Navigate to the Favorite Items page by clicking the Favorite Items link in the Items section of the Applications tree menu. You can also get there by navigating to any item Search or Browse page and clicking the Favorite Items tab.

  2. On the Favorite Items page, click Add Favorite Item to add a new item to the list. To remove an item from your Favorite Items list, select the item and then choose Remove from the Action menu and click Go.

    • You can Export to Excel the attributes for your favorite item by selecting it and clicking Export to Excel.

    • You can compare attributes of your favorite items by selecting them and then selecting Compare from the Action menu. Each item's attributes will be listed side-by-side in a table.

    • You can change the lifecycle of an item by selecting it and then selecting Change Lifecycle from the Action menu.

    • You can change an item's catalog category by selecting it and then selecting Change Catalog Category from the Action menu.

Using Recently Visited

Clicking the Recently Visited global button (global buttons appear on all pages in the system's user interface) enables you to view a list of pages that you visited before the current page. This eases navigation throughout the user interface, as the use of your browser's Back button is not supported. The Recently Visited list provides links up to the last 20 pages visited in your current session, in order of most to least recently visited.

Creating New Items

Items are used to represent:

  • Products and services you sell

  • Resources that you maintain

  • Components that make up your products and services

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.

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:

    • Create - select New Items.

      Tip: Alternatively, you can select Copies of an Existing Item in the Create field. See: To create copies of an existing item. If you have multiple similar items to create, consider creating the first item by selecting New Items in the Create field. After this item is thoroughly defined, created, and approved (if necessary), create the remaining items by creating multiple copies of the first item.

    • Item Catalog Category - find and select an item catalog category in which to create the new item.

      Note: You can only create items within a particular item catalog category if you have the Catalog Category User role for that item catalog category.

      Warning: If ICC versions are enabled, use any of the item creation options described above to create an item rather than the Forms interface to avoid data corruption. Forms behavior has not been enhanced to support ICC versions.

    • Number of Items - enter the number of items you want to create.

    • Style Item - select Style Item if you want to create a style item with related SKUs. For more information about style items, see: Overview of Style and SKU Items.

      Note: You can only create a style item if the selected item catalog category includes at least one attribute group with variant attributes. You can only create SKUs from a style item within the style item's Overview page. See: To create SKU items from a style item:

    • GDSN Syndicated - select this box to permit synchronization with a GDSN datapool such as 1SYNC. See: Overview of the Global Data Synchronization Network, Oracle Product Information Management Implementation Guide

      Important: You cannot send data directly from Oracle Product Information Management (PIM) to GDSN since PIM only maintains the master data, but does not validate the data for GDSN. To send data to GDSN, you must build a validation or use a third party software application to perform this function.

    • Engineering Item - if a new item request is not required for the item catalog category, you have the option to check the Engineering Item checkbox. If a new item request is required, the Engineering Item check box is automatically selected and displayed as read-only. See: Creating New Item Requests

    • Select Templates - optionally, select templates to set the operational and user-defined attributes for the item. The selected templates are applied to all of the items created in the order specified. See: Defining Item Templates, Oracle Product Information Management Implementation Guide

  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:

  • Specifications

    View attributes associated with the item catalog category. You can also update or change attribute values, but, depending on your role privileges and the item's lifecycle phase, a change order may be required (see: Managing Item Specifications). You cannot add new attributes. Attribute associations with item catalog categories are performed at the administration level. For more information, see Defining Item Catalog Categories, Oracle Product Information Management Implementation Guide.

  • Revisions

    See: Creating Item Revisions

  • Attachments

    See: Managing Item Attachments

  • Organizations

    See: Enabling Organization Assignments

  • People

    See: Adding People, Oracle Product Information Management Implementation Guide

  • Associations

    See: Assigning Suppliers to Items and Managing AMLs.

    Caution: GTIN cross references are no longer supported for use with GDSN.

  • Syndication

    Oracle Product Information Management no longer supports outbound product data synchronization with customers.

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.

Creating New Item Requests

The create item process enables you to request new items through a standard approval and creation process. Using this process, companies can promote reuse of items and maintain tight controls over item/part creation, avoiding costly maintenance of duplicate items. The item request approval routing ensures that all relevant parties participate in the item's definition.

Note: If there is no item request associated with an item catalog category, then new items are created with an approval status of Approved. For items such as this, users can define the item status during item creation. If there is a new item request associated with the item catalog category, then the approval status of the item is either Not Submitted for Approval, Submitted for Approval, or Approved, depending upon the approval status of the corresponding new item request. The default approval status of the new item request (NIR) is Not Submitted for Approval. For such items, regardless of the default approval status, the item status is Pending (all status controlled flags are disabled). Only Oracle Product Information Management users can view items with the item status of Pending. Users cannot view these items in the Master Item window or in any other Oracle application. Users can manually update the item status after the new item request is approved.

1. Create item. Pending Not Submitted for Approval -
2.Create and save NIR. Pending Not Submitted for Approval Not Submitted for Approval
3. Submit NIR for approval. Pending Submitted for Approval Not Submitted for Approval
4. NIR in approval workflow. Pending Submitted for Approval Approval Requested
5. NIR is approved. Pending Submitted for Approval Approved
NIR is implemented. Pending Approved Approved

Benefits associated with the new item request process:

  • Companies can standardize item numbers and descriptions

  • Prevents duplication and promotes reuse of item number that are functionally equivalent

  • You can automatically trigger actions based on the item creation business event. See: Item Business Events, Oracle Product Information Management Implementation Guide and Managing Business Events, Oracle Workflow Developer's Guide.

New item requests are change objects. See the Using Change Management chapter in the Oracle Product Information Management User's Guide for more information about managing change objects in general.

Prerequisites

  • Associating New Item Requests with an Item Catalog Category, Oracle Product Information Management Implementation Guide

To create a new item request

  1. Create a new item request from either the item Search Results page or the item Overview page.

    In the Search Results page, select the item(s) that you want to add to a new item request. In the Select Items field, select Create New Item Request, then click Go. Using this method, you can create a new item request that contains one or many items.

    In the Overview page, select Create New Item Request in the Actions field, then click Go. Using this method, you create a new item request for only one item, the item displayed, or you can add this item to an existing new item request in the next step.

  2. In the Create New Item Request: Select New Item Request Type page, choose whether to create a new item request or to add the selected item(s) to an existing new item request.

    Click Continue.

  3. On the Create New Item Request page you can customize/edit the new item approval request.

    The following list provides additional information for some fields on this page.

    • New Item Request Name - required. Enter a descriptive name for the new item request.

    • Assigned To - the assignee is defaulted based on the item catalog category role specified in the assignment rule for new item requests.

    • Priority and Reason - use these fields to track the degree of urgency and the reason for requesting the new item.

    • Source Type and Name - use these fields to document who requested the new items.

    You can also update information in the following tabs:

    • New Items (Lines) - lists all of the items included in the new item request. You can select items and remove them from the new item request or add additional items to the request.

      Note: You can only add items that have a status of Not Submitted for Approval, Cancelled, or Rejected.

    • Dependencies and References - add change object dependencies and item reference information in these two tabs. See: Creating Relationships.

    • Workflow Approval - approval routing templates are available for routing the new item request definition/approval. Routing templates are typically defined for standard business processes associated with new item creation/approvals. You can also use the approval routing template to route the new item request to different functional groups, providing those groups the ability to participate in the creation and definition of new items. For example, the Design Engineer may be responsible for entering the item's user-defined attributes. See: Defining New Item Request Workflows, Oracle Product Information Management Implementation Guide.

      If the new item request type has more than one workflow attached to a phase, the Switch Template button appears. Click Switch Template to choose a different workflow. To view workflows associated with a different phase, use the Phase pull down list.

    • Attachments - attach any supporting files, URLs, or text. See: Adding Attachments.

  4. You can submit the new item request or save it if you wish to enter additional information later.

    Submitting the NIR starts the workflow listed for the Open status. Once you submit it, you cannot add more items to it. If you save it for later, the new item request is saved with a Draft status. Upon submission, if set up, an assignment notification is sent via e-mail.

All new items requiring approval have the item status Pending. After the new item is approved, you can change the item status manually to enable the item for viewing/use outside of the system. You can also define or update its operational attributes.

To add SKUs to a new item request

First, create the SKUs as described in Creating Style and SKU Items. You can then add each SKU to a new item request individually as described above in "To create a new item request:" or you can add multiple SKUs all at once to the same new item request as described below.

  1. In the Overview page for the style item, select the associated SKUs that you want to add to a new item request. Click Add to New Item Request.

    From this point on, refer to the steps in "To create a new item request:" above.

To update a new item request

Within a new item request, you can perform the following updates on each individual line item or on all line items, depending on their status and your role:

  • Remove - you can remove an item from a new item request (NIR) as long as the NIR has not been submitted for approval (the NIR status is Draft).

  • Add Items - you can add new items to a NIR when the NIR status is Draft and the item you want to add meets one of the following criteria:

    • the item is not assigned to another NIR and the item's catalog category requires a NIR.

    • if the item is assigned to another NIR, the item's status is Cancelled or Rejected.

      This action effectively copies the item from the original NIR into the NIR currently in view.

  • Update Item Attributes - you can export the item to a spreadsheet, update the attributes, and import the item. See: Mass Updating Items, Item Categories and Item Associations.

  • Add to Category - you can add approved items only to existing catalog categories.

  • Assign Items to Suppliers

    See: Assigning Suppliers to Items

  • Assign Items to SupplierSites

    See: Assigning Suppliers to Items

  • Approve - this action enables you to approve only certain lines in a NIR, while other lines may have a status of Cancelled or Rejected.

  • Reject or Cancel - you can add a rejected or cancelled line to another NIR at a later time, enabling other, approved lines to continue with the current NIR towards final approval.

  • Add to New Item Request - only available for rejected or cancelled items.

    Adding a cancelled or rejected item from one NIR to another effectively copies the cancelled or rejected item to a new NIR.

To manage a new item request from Open to Approved status

A new item request can have many workflows to complete before reaching Approved status. After each workflow is complete, you must promote the NIR to the next workflow.

  1. Navigate to the new item request's Overview page. Select the Workflow tab.

  2. If a Workflow/Approval Status is Completed and the Workflow/Approval Status of the next workflow is Not Started, then click Promote.

  3. In the Promote Status: (NIR number) page, select the next status, then click Apply.

  4. The approver can approve, reject, or transfer the new item request from the Notifications page to complete the workflow or perform these actions on each NIR line item individually from the New Items page.

    Notifications Page

    To navigate to the New Items page, click the New Item Request Details link in the Notifications page, then select the Lines tab.

    You can now select each new item individually and perform the actions described above in "To update a new item request:", depending on your role.

    New Items Page

  5. Once you (the approver) are satisfied that each line item in the NIR is at the correct status (Approved, Rejected, or Cancelled), you must approve, reject, or cancel the entire NIR to complete the workflow.

    From the new item request's Overview page, click on the Approve/Reject link, then approve or reject the NIR.

  6. In the item Overview page, the approval status should now reflect the status of the new item request, but the item status remains at Pending. If the approval status is Approved, you can now update the item status to Active.

Related Topics

Creating New Items

Associating New Item Requests with an Item Catalog Category, Oracle Product Information Management Implementation Guide

Performing Actions

Managing People and Roles

Creating Relationships

Managing Workflows

Defining Workflow Templates, Oracle Product Information Management Implementation Guide

Managing Item Imports

You can use any of the following methods to import items and item-related information:

This topic discusses importing items using the Item Open Interface. The Open Interface program validates all data before importing it into the production tables. You can also import the following item-related data:

  • Item people.

  • User attributes.

  • Customer items.

  • Customer item cross references.

This topic discusses importing items and their associated data using interface tables. You can import and update items and their associated data from any source into Oracle Product Information Management using interface tables. When you import items through the item interface tables, you create new items in your Item Master organization or assign existing items to additional organizations. Validation of imported items is done using the same rules as the item definition pages, so you are insured of valid items.

Before you use the interface tables, you must write and run a custom program that extracts item and/or associated data from your source system and inserts it into the appropriate interface tables. After you load the interface tables, run the appropriate concurrent request(s) to import the data into the production tables. The concurrent request programs assign defaults, validates data you include, and then imports the new data.

You can use the following concurrent request programs to import data:

  • Import Items - imports items and item revisions.

  • Import Catalog Items - imports items, item revisions, and their related user defined attributes, item associations (the relationship between items and suppliers, supplier sites, and/or supplier site organizations), manufacturer part numbers, and item people.

  • Import Item/Item Revision User Attributes - imports user defined attributes for items and item revisions.

  • Import Item People - imports people associated to items.

  • Import Customer Items

  • Import Customer Item Cross References

  • Import Item Cross References - imports item cross references and GTIN cross references.

  • Import Related Items

To import items

  1. Load the Item Open Interface table (MTL_SYSTEM_ITEMS_INTERFACE) with the data you want to import.

    See:

    • Open Item Interface, Oracle Inventory User's Guide and Importing Items, Oracle Inventory User's Guide for a full description of how to import items.

    • My Oracle Support (http://metalink.oracle.com) Document ID 730164.1 for instructions on how to use the Oracle Product Information Management public APIs and sample code examples.

To import items and associated data

You can import items and their associated data from any source into Oracle Product Information Management using interface tables and the Import Catalog Item concurrent request program. Before you use the Import Catalog Item concurrent request program, you must write and run a custom program that extracts item information from your source system and inserts it into the following interface tables:

  • MTL_SYSTEM_ITEMS_INTERFACE - for items.

  • MTL_ITEM_REVISIONS_INTERFACE - for item revisions.

  • EGO_ITM_USR_ATTR_INTRFC - for user defined attribute values associated to items.

  • EGO_ITEM_ASSOCIATIONS_INTF - for suppliers, supplier sites, and supplier site organizations associated to items.

  • EGO_AML_INTF - for manufacturer part numbers associated to items.

  • EGO_ITEM_PEOPLE_INTF - for people associated to items.

The set_process_id and data_set_id values must be consistent across these tables to identify data related to a single batch.

After you load the data into the interface tables, run the Import Catalog Item concurrent request to import the data into the production tables. This program assigns defaults, validates data you include, and then imports the new data.

Tip: Alternatively, use the Catalog Item Maintenance API package to load most of the above information into the production tables. For more information on using the Catalog Item Maintenance API package, navigate to the Integrated SOA Gateway responsibility > Integration Repository > Product Lifecycle Management > Advanced Product Catalog > Catalog Item > Catalog Item Maintenance (Internal Name: EGO_ITEM_PUB). See: My Oracle Support (http://support.oracle.com) Document ID 730164.1 for instructions on how to use the Oracle Product Information Management public APIs and sample code examples.

  1. Navigate to the Development Manager responsibility > Batch Import > Import Items > Import Catalog Items. This opens the Run this Request... window.

    The Name field is automatically filled in with the name of the concurrent program, Import Catalog Items, and the Parameters window opens.

  2. In the All Organizations field, indicate whether to run the interface for all organizations in the item interface table (MTL_SYSTEM_ITEMS_INTERFACE). If you choose No, the interface runs only for the current organization and interface table rows for other organizations are ignored.

  3. In the Validate Items field, indicate whether to validate all items and their data residing in the interface table that have not yet been validated. If items are not validated, they are not processed into Oracle Inventory. You would choose No if you had previously run the item interface and responded Yes for Validate Items and No for Process Items, and now want to process your items.

  4. In the Process Items field, indicate whether to process items. If you choose Yes, all qualifying items in the interface table are inserted into Oracle Inventory. You would choose No, along with Yes for Delete Processed Rows, to remove successfully processed rows from the interface table without performing any other processing.

  5. In the Delete Processed Rows field, indicate whether to delete successfully processed items from the item interface tables. Choose No to leave all rows in the item interface tables for successfully processed items.

  6. In the Process Set (Null for All) field, you can optionally enter a batch ID.

    Use this field to process a particular batch. To process all records in the interface table, leave this field blank.

  7. In the Create or Update Items field, select whether to:

    • Create New Items - only create new items. Do not update existing items.

    • Update Existing Items - only update existing items. Do not create new items.

    • Sync Items - Create new items and update existing items.

  8. Choose OK to close the Parameters window, then choose Submit.

To import user attributes for items

  1. Load the Item User-defined Attributes Open Interface table (EGO_ITM_USR_ATTR_INTRFC) with the data you want to import. For detailed help on loading the Open Interface tables, refer to:

    • My Oracle Support (http://metalink.oracle.com) Document ID 730164.1.

    • the Integration Repository. See: Oracle Integration Repository User's Guide.

  2. Navigate to the Inventory Responsibility in Oracle Applications, and click the Inventory link. Then click the Items link

  3. Click the Import link.

  4. Click the Import Item/Item Revision User Attributes link.

    Note: The Parameters form automatically appears when you select a request that requires parameter values.

  5. After entering the values in the required parameter fields, click OK.

  6. Click Submit.

To import item people

  1. Load the Item People Open Interface table (EGO_ITEM_PEOPLE_INTF) with the data you want to import. For detailed help on loading the Open Interface tables, refer to the Oracle Manufacturing Open Interfaces and APIs manual.

  2. Navigate to the Inventory Responsibility in Oracle Applications, and click the Inventory link. Then click the Items link

  3. Click the Import link.

  4. Click the Import Item People link.

    Note: The Parameters form automatically appears when you select a request that requires parameter values.

  5. After entering the values in the required parameter fields, click OK.

  6. Click Submit.

To import customer items and customer item cross references

  1. In the Navigator menu under the Batch Import : Import Items heading, click the Import Customer Items link or the Import Customer Item Cross References link.

    For more information, see:

    • Customer Item and Customer Item Cross Reference Interfaces, Oracle Inventory User's Guide

    • Importing Customer Items, Oracle Inventory User's Guide

    • Importing Customer Item Cross References, Oracle Inventory User's Guide

To import item cross references

You can import item cross references from any source into Oracle Product Information Management using the Item Cross Reference Interface. Before you use the Item Cross Reference Interface, you must write and run a custom program that extracts item cross reference information from your source system and inserts it into the MTL_CROSS_REFERENCES_INTERFACE table. After you load the item cross references into the interface table, run the Import Item Cross References concurrent request to import the data into the production table. This program assigns defaults, validates data you include, and then imports the new item cross references.

Note: : This program enables importing both seeded (for example, Customer, Vendor, and Substitute) and user defined cross reference types.

Tip: Alternatively, use the Import Item Cross References API to load the cross reference information into the production table. For more information on how to use the Import Item Cross References API, navigate to the Integrated SOA Gateway responsibility > Integration Repository > Product Lifecycle Management > Advanced Product Catalog > Catalog Item > Import Item Cross References (Internal Name: MTL_CROSS_REFERENCES_PUB).

  1. Navigate to the Development Manager responsibility > Batch Import > Import Items > Import Item Cross References. This opens the Run this Request... window.

    The Name field is automatically filled in with the name of the concurrent program, Import Item Cross References, and the Parameters window opens.

  2. Optionally, in the Parameters window, enter the following values:

    • In the Process Set (Null for All) field, enter a batch ID to process a particular batch. To process all records in the interface table, leave this field blank.

    • In the Delete Processed Records field, enter No to retain all processed records. This field defaults to Yes, which deletes all processed records from the MTL_CROSS_REFERENCES_INTERFACE table.

  3. Choose OK to close the Parameters window, then choose Submit.

To import related items

You can import related items from any source into Oracle Product Information Management using the Related Items Interface. Before you use the Related Items Interface, you must write and run a custom program that extracts related item information from your source system and inserts it into the MTL_RELATED_ITEMS_INTERFACE table. After you load the related items into the interface table, run the Import Related Items concurrent request to import the data into the production table. This program assigns defaults, validates data you include, and then imports the new related items.

Note: This program does not support uploading planning details information.

Tip: Alternatively, use the Import Related Items API to load the related items information into the production table. For more information on how to use the Import Related Items API, navigate to the Integrated SOA Gateway responsibility > Integration Repository > Product Lifecycle Management > Advanced Product Catalog >Catalog Item > Import Related Items (Internal Name: MTL_RELATED_ITEMS_PUB).

  1. Navigate to the Development Manager responsibility > Batch Import > Import Items > Import Related Items. This opens the Run this Request... window.

  2. Optionally, in the Parameters window, enter the following values:

    • In the Process Set (Null for All) field, enter a batch ID to process a particular batch. To process all records in the interface table, leave this field blank.

    • In the Delete Processed Records field, enter No to retain all processed records. This field defaults to Yes, which deletes all processed records from the MTL_RELATED_ITEMS_INTERFACE table.

  3. Choose OK to close the Parameters window, then choose Submit.

Related Topics

Creating New Items

EGO_ITM_USR_ATTR_INTRFC

EGO_ITM_USR_ATTR_INTRFC Column Details

EGO_ITEM_PEOPLE_INTF

EGO_ITEM_PEOPLE_INTF Column Details

Importing Items Using a Spreadsheet

Importing Item Revisions Using a Spreadsheet

Importing Item Categories Using a Spreadsheet

Importing Item Organization Assignment Using a Spreadsheet

Importing Item People Assignment Using a Spreadsheet

Updating Existing Items Using a Spreadsheet

Updating Multi-Row Attributes in a Spreadsheet

Overview of Inbound Product Data Synchronization and Data Quality Management

EGO_ITM_USR_ATTR_INTRFC

The following table shows the columns in the EGO_ITM_USR_ATTR_INTRFC database table. For more details about the columns in EGO_ITM_USR_ATTR_INTRFC, see EGO_ITM_USR_ATTR_INTRFC Details.

EGO_ITM_USR_ATTR_INTRFC    
TRANSACTION_ID NUMBER Yes
PROCESS_STATUS NUMBER Yes
DATA_SET_ID NUMBER Yes
ORGANIZATION_CODE VARCHAR2(3) Yes
ITEM_NUMBER VARCHAR2(81) Yes
REVISION VARCHAR2(30)  
ROW_IDENTIFIER NUMBER Yes
ATTR_GROUP_INT_NAME VARCHAR2(30) Yes
ATTR_INT_NAME VARCHAR2(30) Yes
ATTR_VALUE_STR VARCHAR2(150)  
ATTR_VALUE_NUM NUMBER  
ATTR_VALUE_DATE DATE  
ATTR_DISP_VALUE VARCHAR2(150)  
ATTR_UOM_DISP_VALUE VARCHAR2(25)  
ATTR_VALUE_UOM VARCHAR2(3)  
TRANSACTION_TYPE VARCHAR2 Yes
ORGANIZATION_ID NUMBER  
INVENTORY_ITEM_ID NUMBER  
ITEM_CATALOG_GROUP_ID NUMBER  
REVISION_ID NUMBER  
ATTR_GROUP_ID NUMBER  
REQUEST_ID NUMBER  
PROGRAM_APPLICATION_ID NUMBER  
PROGRAM_ID NUMBER  
PROGRAM_UPDATE_DATE Date  
CREATED_BY NUMBER(15) Yes
CREATION_DATE DATE Yes
LAST_UPDATED_BY NUMBER(15) Yes
LAST_UPDATE_DATE DATE Yes
LAST_UPDATE_LOGIN NUMBER(15)  

EGO_ITM_USR_ATTR_INTRFC Column Details

TRANSACTION_ID

The Primary Key for this table; its value must be generated from the sequence EGO_IUA_TRANSACTION_ID_S.

PROCESS_STATUS

Whether this row has yet to be processed, is currently being processed, encountered an error, or was successfully processed; its value should correspond to the following constants in EGO_ITEM_USER_ATTRS_CP_PUB: G_PS_TO_BE_PROCESSED, G_PS_IN_PROCESS, G_PS_ERROR, and G_PS_SUCCESS.

DATA_SET_ID

The identifier for a group of rows to be processed together; all rows being processed as part of a single request must share the same DATA_SET_ID, whose value must be generated from the sequence EGO_IUA_DATA_SET_ID_S.

The following column values will be validated and used to populate the ORGANIZATION_ID, INVENTORY_ITEM_ID, ITEM_CATALOG_GROUP_ID, and REVISION_ID columns.

ORGANIZATION_CODE

The organization to which the Item belongs; currently, user-defined attributes are supported only for master organizations, and the organization code is validated to ensure that it refers to a master organization.

ITEM_NUMBER

The item number (such as, concatenated segments) for the item.

REVISION

The three-letter code for the current revision of the item (only used if the attribute group is associated at the item revision level; for attribute groups associated at the item level, leave NULL).

Because the user-defined attributes framework is so flexible, its structure must be flattened out for this interface table. To understand this flattening it is useful to first define a logical attribute group row. For single-row attribute groups, the logical attribute group row is just the collection of attributes in the attribute group, but for multi-row attribute groups, each row in the attribute group is a logical attribute group row. For example, the single-row attribute group "Dimensions," with Attributes "Width" and "Height," has only one logical attribute group row, but multi-row attribute group "Orders," with attributes "Date" and "Price" has as many logical attribute group rows as there are separate orders to be recorded.

Every interface table row contains data for one attribute in a logical attribute group row, and a logical attribute group row spans as many interface table rows as there are attributes in the logical attribute group row. To keep these flattened-out logical attribute group rows in order, there is the ROW_IDENTIFIER column, which uniquely identifies each logical attribute group row (for example, all attributes with the same ROW_IDENTIFIER value will belong to the same logical attribute group row). Thus, if a multi-row attribute group has ten attributes and three rows of values (for example, three logical attribute group rows), then there will be thirty interface table rows for the attribute group and three distinct ROW_IDENTIFIER values in those thirty rows.

ROW_IDENTIFIER

The grouping identifier for a logical attribute group row; its value must be the same for all interface table rows in the logical attribute group row, and no two logical attribute group rows in the same data set may share the same ROW_IDENTIFIER value.

ATTR_GROUP_INT_NAME

The internal name of the attribute group to which the current interface table row's attribute belongs.

ATTR_INT_NAME

The internal name of the attribute for which the current interface table row holds a value.

ATTR_VALUE_STR

The value for the current interface table row's attribute if its data type is string.

ATTR_VALUE_NUM

The value for the current interface table row's attribute if its data type is number.

ATTR_VALUE_DATE

The value for the current interface table row's attribute if its data type is date. Values will be converted to and from date data types using the format specified in EGO_USER_ATTRS_DATA_PVT.G_DATE_FORMAT.

ATTR_DISP_VALUE

The value for the current interface table row's attribute (as a string, regardless of its data type) if the attribute has a value set with separate display and internal values (for example, value sets with validation type of independent or table). In all other cases, use the preceding three columns.

ATTR_UOM_DISP_VALUE

The description of the unit of measure associated with the attribute.

ATTR_VALUE_UOM

The internal value of the unit of measure associated with the attribute.

TRANSACTION_TYPE

One thought on “Oracle Item Category Assignment Open Interface Toms Sc430

Leave a comment

L'indirizzo email non verrĂ  pubblicato. I campi obbligatori sono contrassegnati *