3321038 - Integration Center is giving the error Bad Request Status Code: 400 - Recruiting Management

When generating export report in Integration Center, the user is getting the error "The data type of the given value String cannot be cast to the target type Edm.Decimal. Code: BadRequestException Status: Bad Request Status Code: 400"

SAP SuccessFactors Recruiting Management

1. Go to Integration Center
2. Start creating a Scheduled Simple File Output Integration
3. Select the affected entity as the initial entity
4. Click Next
5. Then the error appears

This is caused by misconfiguration. Some possible causes include:

1. One or more custom fields are configured as reportable in Provisioning but defined with different data type.
2. “Status” field is configured in the candidate profile template (CPT).

For Cause 1:

1. In Provisioning > Managing Recruiting > Configure Reportable Custom Fields, open the entity (job requisition, application or candidate) where you are getting the error in Integration Center.
2. Click the Save button to see possible error in the field type mapping.
3. Correct the field data type mapping of field ID with warning.
4. After saving the adjustment, click the 'Synchronize Existing Data' button on the page.
5. Once it has completed, go to the instance Admin Center > OData API Metadata Refresh and Export and click on Refresh metadata.

For Cause 2:

Remove the "status" field from the Candidate Profile Template (CPT). According to the implementation guide, there is a disclaimer: "Don't configure this in the Candidate Profile Template. It doesn't populate with any data".

1. Remove any references to the status field from the CPT and save the updated template.
2. Afterwards, perform an OData metadata refresh from Admin Center > OData API Metadata Refresh and Export, and then validate the behavior again in Integration Center.

Candidate Profile Field Definition: Field ID and Field Type | SAP Help Portal

job requistion, job application, jobreq, jobapp, candidate, candidatelight, Text, Textarea, Richtext, Boolean, Hyperlink, Object, Number, Percent, Picklist, IC, status , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem