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

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

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