SAP Knowledge Base Article - Public

3421313 - BIB replication: Inconsistent data in ECPAO_QRY_ADM table

Symptom

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"

Environment

  • SAP SuccessFactors Employee Central Integration to SAP Business Suite

Reproducing the Issue

  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'

Cause

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.

Resolution

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

See Also

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

Keywords

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

Product

SAP SuccessFactors HXM Core 2311