1. Integrating Sales with Oracle E-Business Suite, Release 12.1.3
  2. Map Products Manually

Map Products Manually

You can create product mappings by comparing the SQL results from Oracle E-Business Suite to the CSV file from Oracle CX Sales. Here is one example for mapping desktop computers. To map products manually, do the following:

  1. In the Oracle E-Business Suite SQL results, filter on descriptions containing Desktop.

  2. Note the values in the ITEM and INVENTORY_ITEM_ID columns.

  3. In the Oracle CX Sales Excel file, filter on descriptions containing Desktop.

  4. Note the values in the Item column.

  5. Map the corresponding products to each other.

    The following table shows an example:

System

Column

Value

Oracle CX Sales

Description

Sentinel 9000 Desktop

Oracle CX Sales

Item

AS54600

Oracle E-Business Suite

DESCRIPTION

Sentinel Deluxe Desktop

Oracle E-Business Suite

ITEM

AS18947

Oracle E-Business Suite

INVENTORY_ITEM_ID

155