Symptom
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"
Environment
SAP SuccessFactors Recruiting Management
Reproducing the Issue
- Go to Integration Center
- Start creating a Scheduled Simple File Output Integration
- Select the affected entity as the initial entity
- Click Next
- Then the error appears
Cause
One or more custom fields are configured as reportable in Provisioning but defined with different data type.
Resolution
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. Click the Save button to see possible error in the field type mapping. Correct the field data type mapping of field ID with warning. After saving the adjustment, click the 'Synchronize Existing Data' button on the page. Once it has completed, go to the instance Admin Center > OData API Metadata Refresh and Export and click on Refresh metadata.
Keywords
job req, jonApplication, jobrequisition, candidatelight, Text, Textarea, Richtext, Boolean, Hyperlink, Object, Number, Percent, Picklist, IC , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem