Create Mappings for Oracle Sales

To create a new mapping for use with Oracle Sales:

  1. Navigate to the Mappings page.
  2. Click Create Mapping.
  3. Use the following elements to complete the mapping:

    Element

    Description

    Name

    Enter a unique name for your export mapping.

    Data Type

    Select Company or Contact to obtain the correct list of mappings.

    Mapping Type

    Specify whether the mapping is for a Search Export or a Match Export job to Sales.

    Template Type Select Sales and Service to create a mapping for use with Sales. DaaS automatically maps the discovered attributes to those in Sales.

    Add Attribute

    Add an attribute mapping that you accidentally removed but you still want added. If you extended the attributes in Sales, use Add Attribute for any attributes that you extended in Sales.

    For each list displayed, select the attribute or object.

    See Edit Sales Mappings for more information about the Sales attributes.

    Note: Match Export mappings require that certain attributes exist. If you delete required attributes, then your import job fails. See About Matching Records and Analyze Rejected Match Export Jobs.If you get error DCS-1059, make sure that your mapping file has Column Data Attribute = ExternalId mapped to Column Target Attribute = PartyId, or, make sure that your input file contains a column header called ExternalId (or any name) with values that uniquely identifies the account record in Sales.
  4. Click Save & Select.
  5. Apply the mapping to a search export or match export job by following these procedures:

    When prompted for the mapping, select the one that you created.