3372631 - Error in EmpCostAssignmentItem: [COE0019]Failed to retrieve result with given criteria

When performing an OData API query on EmpCostAssignmentItem entity, the error below occurs:

"[COE0019]Failed to retrieve result with given criteria"

This error also occurs in Integration Center, the error is this one below:

[COE0019]Failed to retrieve result with given criteria.
Code: COE_GENERAL_SERVER_FAILURE
Status: Internal Server Error
Status Code: 500

The issue also occurs when the query is performed in EmpCostAssignment with an expand to EmpCostAssignmentItem, for example:

GET odata/v2/EmpCostAssignment?$expand=items

• SAP SuccessFactors HXM Suite
  • OData API
  • Integration Center

This issue was already identified as a defect.

The current plan is to fix it through a patch which will occur on these dates:

• Preview deployment is 18-Sep-23
• Production deployment is 21-Sep-23

Workaround: perform the query with the parameter "$tempTableSize=1". For example:

GET odata/v2/EmpCostAssignment?$expand=items&$tempTableSize=1

This workaround is not valid for Integration Center. On Integration Center scenario there isn't a workaround available.

expand, items, EmpCostAssignment, 500, criteria, employee, cost, assignment, MDF-83915 , KBA , LOD-SF-INT-MDF , Metadata Framework API (MDF) , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Problem