SAP Knowledge Base Article - Public

3274437 - OData API Error "The data type of the given value String cannot be cast to the target type Edm.Decimal" - Recruiting Management

Symptom

  • Error when querying data from Recruiting OData API entities.
  • The data type of the given value String cannot be cast to the target type Edm.Decimal.

Environment

SAP SuccessFactors Recruiting Management

Cause

The error occurs if any custom fields of the type "number", "currency" or "picklist" is mapped to the "text" type on Provisioning > Configure Reportable Custom Fields page.

Resolution

  1. Go to Provisioning > Configure Reportable Custom Fields;
  2. Review the Field IDs mapped to 'Text, Textarea, Richtext, Boolean, Hyperlink, Object' and check the field type in the Recruiting template;
  3. Remove the field from the wrong type and map it to the correct type;
  4. Click the button 'Synchronize Existing Data' on the page.

Note: As a customer, you do not have access to Provisioning. To complete tasks in Provisioning, please contact your Implementation Partner.

If you are no longer working with an Implementation Partner, you can submit a change request to SAP Support using the approval document downloaded from the following KBA.

  • KBA 2258199 - Software Change Request for SuccessFactors Recruiting Management.
  • Request item: "Make a field reportable"

See Also

KBA 2388677 - What Type of Fields Can Be Reported in Configure Custom Reportable Fields - RCM

Keywords

RCM, OData, API, error, BadRequestException, job requisition, job application, candidate, offer approval, report, text, number, currency, picklist, Configure Reportable Custom Fields , KBA , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem

Product

SAP SuccessFactors Recruiting all versions