3295527 - Internal Server Error : 500 while querying Background data using OData API

While querying Background data using OData API you encounter following error

ERROR: com.sap.gateway.core.ip.component.odata.exception.OsciException: Internal Server Error : 500 : HTTP/1.1

SAP SuccessFactors HXM Suite

* OData API

The following error codes are captured in backend system logs

1. [COE0019] - Received non success response code from API server

2. Error code 11216 | SAP DBTECH JDBC: CANNOT CONVERT DATA XXX TO TYPE JAVA.MATH.BIGDECIMAL, where XXX represents the value stored in database table.

The reason is that the text value XXX is stored in a Background record of an employee and the associated field is of Picklist type. It should have the Option ID of a Picklist instead.

Please raise a case for SAP Cloud Product Support under LOD-SF-INT-ODATA component for SuccessFactors Integration team. Cloud Product Support team will internally check with database team to find out the Background record that has the value XXX and share the respective employee details with customer.

Customer need to fix the data from UI, by updating Option ID in the Picklist field, after receiving the employee details.

3307723 - Server Error : 500 while querying Background data using OData API

COE0019, JAVA.MATH.BIGDECIMAL, 11216, 500, Background_*, Background_Education, OData, Picklist, Option ID, text, database, com.sap.gateway.core.ip.component.odata.exception.OsciException: : 500 : HTTP/1.1 , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem