Forum Post: Using Progress And Salesforce Lightning Connect Getting An Error Trying To...

Status
Not open for further replies.
P

patchpv

Guest
We are working on a Proof of Concept using Salesforce Lightning Connect along with Progress DataDirect software to connect Salesforce to our Oracle E-business Suite ERP system. We are facing an issue updating or deleting records from the oracle database when the primary key is a numeric field. Error message received is "Type mismatch while updating the external column ExternalId" Anybody else faced this issue? This works fine if the oracle table's primary key is a character field. One thing I have noticed is that if the oracle primary key value is 123, the value for the salesforce external id in the external object is displayed as 123.0

Continue reading...
 
Status
Not open for further replies.
Top