cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Replication of employee data from SF EC to SAP HCM

anurag_pal
Discoverer
0 Likes
1,803

Hello Experts,

We are trying to integrate SF with SAP HCM on S4/HANA platform. When we are invoking the employee data replication query ECPAO_EE_ORG_REPL_QUERY, we are getting below error in SOAMANAGER monitor:

Problem during invoking SuccessFactors Web service. SOAP faultCode ns2:Server, faultString SFAPI Domain Error!, errorCode INVALID_SFQL, errorMessage: Invalid SFQL! Error: "person" must be specified in the SELECT clause

If anyone came across similar type of situation and any pointers will be helpful to resolve this

Regards

Anurag Pal

Accepted Solutions (0)

Answers (3)

Answers (3)

siddharthrajora
Product and Topic Expert
Product and Topic Expert
0 Likes

can you check in SLg1 or SRTUTIL, do you see any error or any information?

anurag_pal
Discoverer
0 Likes

Thanks Siddharth for your quick response.

Its working now. but still replication is not happening. Do you have some suggestion if there is some deviation to be taken care from standard process of BIB replication?

Regards

Anurag Pal

siddharthrajora
Product and Topic Expert
Product and Topic Expert
0 Likes

please check the template, ie in your Select template mapping, perperson should be there ie WS_2

"person", "employment" and "job info" should be mapped, these are mandatory.

Try with standard delivered template too.

rxdash
Explorer
0 Likes

This helped us fix our issue.