Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

not able to do autocorrect load to salesforce table in bods

hi all,

my requirement is to load from an oracle table to salesforce table.

source is not delta enabled [means source cannot send delta records and it is upto the bods job to figure out the delta]

the data flow is simple: one to one mapping of source to target fields.

i wanted to try the auto-correct load option, but i am not able to figure out what to populate this field "external id column name"

1 : i tried leaving this "external id" field blank,

          the job failed with error message that this field cant be left blank

2: i tried to populate "external id" = "ID" [this is key column in oracle table],

         the execution failed saying that "ID" column not allowed for "external id"

3: next i tried to populate "external id" = "Id" [this is key column in salesforce target table],

         the execution failed saying that "Id" column not allowed for "external id"

4: next i tried to give other random columns , but none of them was successful.


please suggest.

i have mentioned the dataflow layout below

[source -> query transform (direct mappings) -> salesforce target table ]


Former Member
Former Member replied

hi all,

this was resolved by creating external id on the salesforce table,

and providing that column name in the sf-target table properties.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question