Symptom
When trying to do an UPSERT through Integration Center, getting an error: "JobRequisition: UPSERT failed for the row with key: . Reason: Invalid value for Internalstatus: Approved. The row will not be processed for subsequent entities."
Environment
SAP SuccessFactors Recruiting Management
Cause
The value set for internalStatus was Pre-approved, Approved and Closed, that are not the expected values for this field through OData API.
Resolution
The expected values for internalStatus when the update is done through Integration Center or OData API are:
- 0 - Requisition Pre-Approved;
- 1 - Requisition Open/Approved;
- 2 - Requisition Closed.
So, the CSV file to update fields through Integration Center must include one of the 3 values above, or, if doing directly through the metadata, then to use the numbers above in the query.
NOTE: Verify if the requisition is pre-approved (internalStatus = 0), otherwise the message may appear to. As a alternative, you may refer: isDraft=true for Preapproved (0). isDraft=false for Approved (1).
See Also
Keywords
job, requisition, api, odata, integration, center, centre, upsert, update, insert, internal, status, internalstatus, approved, preapproved, closed, pre-approved. , KBA , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem
SAP Knowledge Base Article - Public