SAP Knowledge Base Article - Public

2361469 - Recruitment - SFAPI Error with Entity JobApplication when adding a filter with field lastModifiedForAppStatus in query


Getting an error when try to add a filter with field “lastModifiedForAppStatus” from JobApplication entity in query


Successfactors RCM SFAPI

Reproducing the Issue

SFAPI response throwing an error when try to add a filter with field “lastModifiedForAppStatus” in the query. Field is present in the SFAPI “JobApplication” entity.

Querry having issue:

select candidateId, statusId, jobReqId, jobReqTemplateId from JobApplication where lastModifiedForAppStatus > to_date('2015-06-13T00:00:01Z')

Request: Add a filter with field "lastModifiedForAppStatus"



Response:Getting an error "SFAPI Domain Error" in the response

Error Response.PNG


The issue is because of the incorrect format of the date field in the filter used in the query.

Correct format for lastModifiedForAppStatus field when used in filter in query is below:

SELECT candidateId,jobReqId,jobReqTemplateId,statusId FROM jobapplication WHERE lastModifiedForAppStatus > to_date('2015-06-13','yyyy-mm-dd')

The difference in the error query and the correct one is the format of the date which is highlighted in bold above. When you run this query, it will result the data.


lastModifiedForAppStatus, JobApplication Entity , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem


SAP SuccessFactors HCM Core 1605