Loading

Error 'ORA-20000: ORA-06512:' on Upsert Operation in Salesforce

Publiceringsdatum: Jun 16, 2025
Beskrivning

In Salesforce, you may see the below error when performing an upsert operation on records:

ORA-20000: ORA-06512: at "SNEEZY.SIMPORTLOOKUP", line 850 ORA-06512: at "SNEEZY.SIMPORTLOOKUP", line 823 ORA-06512: at line 1 : SQLException while executing plsql statement

Lösning

The optional External_ID_Field Salesforce parameter is a variable that specifies the custom field that should be used to match records that already exist in your organization's data. This custom field must be created with the External Id attribute selected. 

Additionally, if the field does not have the Unique attribute selected, the context user must have the “View All Records” object-level permission for the target object or the “View All Data” permission so that upsert does not accidentally insert a duplicate record. 

Upsert Statement

To avoid this, you can do one of the following: 

1. Update the 'field' matching field 'External_Id__c' to be unique. 
2. Change the user profile(s) to view all data for the object 
Knowledge-artikelnummer

000385833

 
Laddar
Salesforce Help | Article