You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Salesforce Integration FinalBatch error

Accepted answer
21
Views
5
Comments
edited Jul 24, 2019 8:28PM in Integration 5 comments

Summary

Bulk Data load to Salesforce fails

Content

Hi,

I am trying to upload a CSV file to Salesforce through the Salesforce Adapter and the Bulk Data upsert operation. The upsert seems to work fine and generates the proper XML to send to salesforce, but when it reaches my FinalBatch operation, it fails with "invalid JobID" coming back from Salesforce.

I am using a similar flow to what is shown in the Oracle documentation here:

ttps://docs.oracle.com/en/cloud/paas/integration-cloud/sforce-adapter/handle-huge-data-sets-asynchronously-different-bulk-operations.html

Attached is a picture of my integration flow. It fails at FinalBatch. The "mapping to FinalBatch" is not doing anything because there is nothing I can use from the upsert to send a jobID to the final batch operation. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!