Question Re: Replication of employee data from SF EC to SAP HCM in Human Capital Management Q&A

Replication of employee data from SF EC to SAP HCM

anurag_pal — Sun, 06 Sep 2020 10:52:08 GMT

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

Re: Replication of employee data from SF EC to SAP HCM

siddharthrajora — Thu, 10 Sep 2020 19:14:56 GMT

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.

Re: Replication of employee data from SF EC to SAP HCM

anurag_pal — Fri, 11 Sep 2020 00:18:32 GMT

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

Re: Replication of employee data from SF EC to SAP HCM

siddharthrajora — Fri, 25 Sep 2020 18:54:33 GMT

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

Re: Replication of employee data from SF EC to SAP HCM

rxdash — Fri, 06 Oct 2023 17:37:05 GMT

This helped us fix our issue.