SAP Knowledge Base Article - Public

2843442 - Field df_users_sysinfo_users_sys_id is not defined / RH_SFI_IMPORT_COMP_DATA for Compensation Talent Addon - SuccessFactors HCM Suite

Symptom

You are running the standard ERP program RH_SFI_IMPORT_COMP_DATA for Talent Addon and you are observing issues in the Admin Center > SFAPI Audit logs according example below.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Request:

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
    <Body>
        <submitQueryJob xmlns="urn:sfobject.sfapi.successfactors.com">
            <queryString>SELECT FORM_DATA_FORM_TEMPLATE_ID,USERS_SYSINFO_USERS_SYS_ID,USERS_INFO_EMPID_EMPID FROM AdhocReport_2061 CONSTRAIN BY df_USERS_SYSINFO_USERS_SYS_ID IN ('yourUser')</queryString>
        </submitQueryJob>
    </Body>
</Envelope>

Response:

<?xml version='1.0' encoding='UTF-8'?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
    <S:Body>
        <ns2:Fault xmlns:ns2="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns3="http://www.w3.org/2003/05/soap-envelope">
            <faultcode>ns2:Server</faultcode>
            <faultstring>SFAPI Domain Error!</faultstring>
            <detail>
                <ns2:SFWebServiceFault xmlns="urn:sfobject.sfapi.successfactors.com" xmlns:ns2="urn:fault.sfapi.successfactors.com">
                    <ns2:errorCode>INVALID_FIELD_NAME</ns2:errorCode>
                    <ns2:errorMessage>Field df_users_sysinfo_users_sys_id is not defined</ns2:errorMessage>
                </ns2:SFWebServiceFault>
            </detail>
        </ns2:Fault>
    </S:Body>
</S:Envelope>

Environment

  • SuccessFactors HCM Suite
    • SFAPI Adhoc calls
  • Integration Add-On for SAP ERP HCM and SuccessFactors HCM Suite

Reproducing the Issue

  1. Activate the Admin center > Audit log Settings > click in the button "Enable all payloads" for SFAPI to enable the full logs during the next 4 hours
  2. Run the ERP report/program RH_SFI_IMPORT_COMP_DATA
  3. Observe the error in the Response Payload of the Admin center > SFAPI Audit log > for the call done with operation submitQueryJob

Cause

Missing config in Reporting module

Resolution

If you received the same error message inside the SFAPI Audit logs response (INVALID_FIELD_NAME / Field df_users_sysinfo_users_sys_id is not defined), the steps to solve this are:

  1. Open the Home > "Report center" and edit the report corresponding of your SFAPI entity, in my example was ADHOCREPORT_2481 (you can check the reports in the Admin center > SFAPI Data Dictionary proxying the report owner).
  2. Goto this report, click edit
  3. Goto filter, select UserId filter
  4. Select "User Prompted" checkbox

example.PNG

  1. Save the report, After that, you will see the missing field inside Admin center > SFAPI Data Dictionary.

example02.PNG

These steps above will include back the field df_users_sysinfo_users_sys_id inside the report and will solve the mentioned issue.

Keywords

Field df_users_sysinfo_users_sys_id is not defined, INVALID_FIELD_NAME, program or report RH_SFI_IMPORT_COMP_DATA, Integration Add-On for SAP ERP HCM and SuccessFactors HCM Suite, SFAPI Adhoc, submitQueryJob, SFAPI Domain Error!. Addon, Talent, Compensation , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT-ADD , Talent Hybrid AddOn Solution , LOD-SF-INT , Integrations , PA-SFI-TM , Integration with SuccessFactors BizX Talent Management , How To

Product

SAP SuccessFactors HCM Suite all versions ; integration add-on for SAP ERP HCM and SAP SuccessFactors HCM Suite all versions