1. Integrating Oracle Sales with Oracle CPQ
  2. Edit Attribute Mappings

Edit Attribute Mappings

The Oracle CPQ REST Integration Type includes an Attribute Mapping UI for administrators to map Oracle Sales attributes to Oracle CPQ attributes. Depending on the integration type, mapped fields are either imported from a Sales object to an Oracle CPQ object, or exported from an Oracle CPQ object to a Sales object.

You can use this feature with these integrations:

  • Import Opportunity
  • Upsert Quote
  • Export Lines
  • Line Sync Complete

The Attribute Mapping page has predefined standard attribute mappings for new customers and allows sales administrators to modify and extend the integrations without the use of XSL templates. This page supports text-based searches to find available attributes and drag and drop them.

The Attribute Mapping page always displays the available Oracle CPQ attributes on one side of the page and the available Sales attributes on the other side. The mapped attributes are displayed in the middle with an arrow indicating the direction of the data flow. Icons identify the attribute type, and the attribute variable name displays when you hover over an attribute name. You can add new attribute mappings and edit (with the edit icon) or delete (with the delete icon) existing attribute mappings.

Here are the steps to add new attribute mappings or edit the existing attribute mappings:

  1. Go to Administration Platform > Commerce and Documents Process Definition.

  2. In the Navigation list for the applicable process, select Integrations, and click List.

  3. Click the integration name for the REST Integration that you want to edit.

  4. Click Edit, next to Request Mapping or Response Mapping.

  5. Click the Add Row icon or drag and drop an attribute to create a new attribute mapping row.

    1. Select the appropriate Oracle CPQ attribute.

    2. Select the appropriate CX Sales attribute.

    3. Click the Apply icon or click outside the row to register the mapping.

  7. Click Save to save changes or click Finish to save changes and exit the page.

  8. Deploy the changes. See: Deploy your changes.