SAP Knowledge Base Article - Public

2686246 - Compound Emloyee Query returns error "Invalid SFQL! Error: Multiple changes per day effective dated objects like cust_MCPD are not supported in snapshot and delta modes"

Symptom

Below error message is returned while executing the Compound Employee Query:

Invalid SFQL! Error: Multiple changes per day effective dated objects like cust_MCPD  are not supported in snapshot and delta modes

Environment

SuccessFactors

Reproducing the Issue

1. Execute the below Compound Employee Query:

    <urn:query>

    <urn:queryString>SELECT compensation_information, employment_information, job_information, paycompensation_recurring, person, personal_information, cust_MCPD FROM CompoundEmployee WHERE person_id_external = '205'</urn:queryString>

   <urn:param> <urn:name>queryMode</urn:name> <urn:value>delta</urn:value> </urn:param>

   </urn:query>

2. The response has the below error message:

   <ns2:errorCode>INVALID_SFQL</ns2:errorCode> <ns2:errorMessage>Invalid SFQL! Error: Multiple changes per day effective dated objects like cust_MCPD are not supported in snapshot and delta  modes</ns2:errorMessage>  

Cause

  • One of the object that is selected in the Compound Employee Query is an object that has Effective Dating value as Multiple Changes Per Day
  • And the query mode used is either "delta" or "snapshot"
  • Objects that have Effective Dating value as "Multiple Changes Per Day" are not supported in the delta or snapshot query mode of Compound Employee

Resolution

  • Remove the object which has Effective Dating value as "Multiple Changes Per Day" from the query
  • For example in the query that is used in the "Reproducing the Issue" section has cust_MCPD as an object which has Effective Dating as Multiple Changes Per Day

    MCPD.PNG

  • Remove this object from the Compound Employee Query and re-execute the query or do not use the query mode as "delta" or "snapshot"
  • The query will return successful result

Keywords

Multiple Changes Per Day, Compound Employee API, Invalid SFQL! Error: Multiple changes per day effective dated objects like cust_MCPD  are not supported in snapshot and delta modes , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core 1808