When you upload a CSV file of Service Points with the Energy & Utilities Cloud Service Point bulk upload, the upload fails if your org requires custom fields on the Premises object. The failure occurs even when every CSV row contains a valid Premise Id and that Premises record already has values in the required fields.
DmlExecutionException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [Custom field] Here, [Custom field] is the required Premises field.For every CSV row, the bulk upload inserts a generic Premises record. This happens whether or not the row contains a Premise Id. The upload populates only the system-generated Name on this generic Premises record and leaves all other Premises fields blank.
When a row includes a Premise Id, the upload links the new Service Point to that existing Premises record. The generic Premises insert still runs as well. If any Premises custom field is required, the generic insert fails with REQUIRED_FIELD_MISSING, and the upload fails. The values already on the referenced Premises record don't prevent this failure.
You can't supply the missing values in the CSV file. The upload template accepts only Service Point fields, so any Premises field added as a column causes the "Incorrect CSV" error.
Make the affected Premises custom fields not required, then run the upload again.
REQUIRED_FIELD_MISSING exception and note each field listed under "Required fields are missing".Notes
If the upload still fails after you complete these steps, contact Salesforce Support and include the debug log from the failed upload.
005461854

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.