How to Convert 18 Character Salesforce IDs to 15 Character Salesforce IDs in Eloqua (Doc ID 2017887.1)

Last updated on FEBRUARY 12, 2016

Applies to:

Oracle Eloqua Marketing Cloud Service - Version 9 to 10 [Release 9 to 10]
Information in this document applies to any platform.

Goal

Salesforce IDs have been incorrectly exported with 18 characters and loaded into Eloqua. This data needs to be amended and corrected to the shorter 15 character format as the 18 character IDs are breaking 3rd party programs.

 

For example:

001400000750cdeXYZ 

must become:

001400000750cde

 

*In this example we are going to assume that it is the Account ID which is too long, but this solution could easily be amended for other Salesforce IDs.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms