Integration of Phone Fields between Eloqua and Fusion Sales

Summary:

Integration of Oracle Fusion Sales and Oracle Eloqua: Phone Number Fields

Content (please ensure you mask any confidential information):

We are searching for experiences / best practice for integration of Oracle Fusion Sales and Oracle Eloqua in terms of Phone Number Fields.

The issue:

• Oracle Fusion Sales provides 4 fields to store phone number portions (country code, area code, main phone, extension)
• Oracle Eloqua provides 1 field to store full phone numbers
• For the integration this is an issue:
  Merging phone numbers from Sales (that are splitted into four fields) into one field in Eloqua will not be a problem,
  but to parse phone numbers from Eloqua (that are stored completely in one field) to fit into the four fields in Sales will be a high level of customization, requires significat effort and must be considered a risk of high susceptibility to errors