Symptom
During employee master data and organizational assignment replication from SAP SuccessFactors Employee Central to the on-premise SAP system, the following error message is raised:
You don't have the authorization to change table ECPAO_QRY_ADM
Message No. ECPAO_IN_QUERY002
This error manifests differently depending on the integration scenario in use:
Scenario 1 – ECS4HCM (with Staging Area)
- No replication requests are appearing in the staging area viewer (transaction ECPAO_EE_VIEWER / ECPAO_RPRQ_EE_VIEWER) after running the replication program.
- SLG1 logs for the affected employee show message ECPAO_IN_QUERY002.
Scenario 2 – PA_SE_IN (without Staging Area)
- The replication message appears stuck in "In Process" status in SRTUTIL / SRT_MONI without progressing.
- When checking SLG1 with Object: ECPAO_IN and Sub-Object: GEN, message ECPAO_IN_QUERY002 is found in the orchestration logs.
Read more...
Environment
- SAP SuccessFactors Employee Central Integration to SAP Business Suite (PA_SE_IN)
- SAP SuccessFactors Employee Central Integration with SAP HCM for SAP S/4HANA (ECS4HCM)
Product
Keywords
ECPAO_QRY_ADM, ECPAO_IN_QUERY002, no authorization, authorization missing, employee replication, BIB replication, PA_SE_IN, ECS4HCM, staging area, SRTUTIL, SRT_MONI, SLG1, ECPAO_IN, GEN subobject, S_TABU_NAM, S_TABU_DIS, SU53, STAUTHTRACE, ECPAO_EE_ORG_REPL_QUERY, ECPAO_EE_VIEWER, ECPAO_RESET_QRY_ADM, SAP_HR_ECPAO_WEBSERVICES, stuck in process, no requests staging area , KBA , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview