Create Cross-References in Order Management

Use Product Information Management to create a cross-reference for Order Management.

In this example, assume your source system uses AS54000 Desktop Computer for the item name, but you use AS54888 Desktop Computer in Product Information Management and in your fulfillment system. You will create a cross-reference that establishes a relationship between these names.

This topic uses example values. You might need different values, depending on your business requirements.

For details about how to create cross-references, including using the Manage Item Relationships page, see Document ID 1309859.1 (Oracle Product Information Management, Understanding Item Cross References), on My Oracle Support.

1. Make sure you have the privileges that you need to administer Order Management.

2. Create a lookup.

   • In the Setup and Maintenance work area, go to the task.

     • Offering: Order Management

     • Functional Area: Orders

     • Task: Manage Cross Reference Types

     You will use this lookup later in this procedure.

   • On the Manage Cross Reference Types page, make a note of the rows that the search results display.

     • Charge Master

     • Old Item Number

     • Supplier Part Number

     • Golden Tax Adaptor

     You can use these predefined values, or create a new one. For this example, you create a new one.

   • In the Lookup Codes area, click Actions > New, set the values, then click Save and Close.

     Attribute	Value
     Lookup Code	item_name The value you enter must match the value you import from the source system. Product Information Management uses this value when it receives data from your source system, such as in a web service payload, to complete the cross-reference.
     Enabled	Contains a check mark.
     Meaning	Item Name
     Description	Item relationship type to use when cross-referencing to an old item name in a legacy source system.

3. Create the cross-reference.

   • Make sure you have the privileges that you need to administer Product Information Management.

   • Go to the Product Information Management work area, then click Tasks > Manage Item Relationships.

   • On the Manage Item Relationships page, set Item Relationship Type to Cross-References, then click Go.

   • In the search results, click Actions > Create

   • In the Create Cross-Reference Relationship dialog, set the values.

     Attribute	Value
     Organization	Vision Operations
     Item	AS54888
     Type	Item Name This is the value you created earlier in this procedure on step 2.
     Value	AS54000 Desktop Computer
     Description	Cross-reference to the AS54000 on our legacy source system.

   • Click Save and Close.

     Product Information Management creates a cross-reference between item AS54888 in Product Information Management and item AS54000 Desktop Computer in your legacy order capture system.

Use the Product Information Management Work Area

If you use the Product Information Management work area, then you set Item Relationship Type to Spoke System Items. This relationship is useful when you must map and identify items that Product Information Management consolidates from more than one source system into a single master item.

Do step 3 described above, but with these differences.

1. On the Manage Item Relationships page, set Item Relationship Type to Spoke System Items.

2. In the Create Spoke System Item Relationship dialog, set the values.

   Attribute	Value
   Organization	Vision Operations
   Item	AS54888 Desktop Computer
   Spoke System	LEGACY_SOURCE_SYSTEM Assume you already set up this spoke system in the Product Information Management work area.
   Spoke System Item	AS54000 Desktop Computer

   Product Information Management creates a cross-reference between item AS54888 in Product Information Management and item AS54000 Desktop Computer in the Product Information Management work area.