3421313 - BIB replication: Inconsistent data in ECPAO_QRY_ADM table

When BIB employee replication is executed on ERP system, next error is found on tx. SLG1:

"Inconsistent data in ECPAO_QRY_ADM table; contacttechnical support - Message No. ECPAO_IN_PROCESSING055"

• SAP SuccessFactors Employee Central Integration to SAP Business Suite

1. Replicate employee from EC to ERP, running report ECPAO_EE_ORG_REPL_QUERY
2. Error ECPAO_IN_PROCESSING055 is found on tx. SLG1
3. A request with following message can be found on SRT_MONI:
   'Problem during invoking SuccessFactors Web service. SOAP faultCode S:Server, faultString SFAPI Domain Error!, errorCode INVALID_SFQL, errorMessage: Invalid SFQL! Error: query "" is not properly formed'

This error is raised because system cannot find on table ECPAO_QRY_ADM the source of employee replication query executed.

A possible scenario is that confirmation web service CO_PAOCF_EC_EMPLOYEE_MASTER_DA doesn´t point to the correct URL "/cxf/ERP_to_EC_EmployeeMasterDataReplicationConfirmation". If URL maintained on confirmation service points to '/cxf/EC_to_ERP_Master_Data_And_Org_Query', an empty query is sent, so when answer is received from EC, error "Inconsistent data in ECPAO_QRY_ADM table; contacttechnical support - Message No. ECPAO_IN_PROCESSING055" is raised because query isn´t available on table ECPAO_QRY_ADM.

Adjust confirmation's web service URL, as described on step 7 of the following implementation guide link:

Enabling the SAP S∕4HANA Outbound Web Services to Set Up the Connection from SAP S∕4HANA to the Middleware
https://help.sap.com/docs/SAP_SUCCESSFACTORS_EMPLOYEE_CENTRAL_INTEGRATION_TO_SAP_BUSINESS_SUITE/b22a1d132dfa438698bceadbafd7a57d/f9e2894c61414ed18a440b040ecb5618.html

About how to find the correct URLs, refer to GUIDE :How to Find the Endpoint URLs

You can test outbound connectivity from SAP ERP HCM to SAP Cloud Integration, using the Ping Web Service button to check message errors.

Enabling the SAP ERP HCM Outbound Web Services to Set Up the Connection from SAP ERP HCM to the Middleware

3083889 - Error while running the query

KBA , LOD-EC-INT-ORG , Org Integration EC to ERP On Premise , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , Problem