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"

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

SuccessFactors

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>  

• 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

• 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

• 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

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 , Integrations , Problem