2010788 - Exception 'Field df_users_sysinfo_users_sys_id is not defined' in RH_SFI_SYNCH_COMP_DATA

When running report RH_SFI_SYNCH_COMP_DATA to pull back compensation information from SuccessFactors, the SQL statement that is sent via PI to SF is building the statement including field names that do not exist in the report. Specifically the statement generated to be executed by the SF API is using a field called DF_USERS_SYSINFO_USERS_SYS_ID. The User ID field included in the report is called USERS_SYSINFO_USERS_SYS_ID.

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

• Integration Add-On for SAP ERP HCM and SuccessFactors HCM Suite
• Compensation scenario

1. Run the report RH_SFI_SYNCH_COMP_DATA.
2. Import fails and when looking at the API log (or in SFAPI audit log) you can see the SQL statement generated with the field df_USERS_SYSINFO_USERS_SYS_ID which does not exist.

On SF the column for the user ID must have the property 'Constrainable'.

Please make sure there is a filter defined for UserID as shown in the screenshots:

KBA , PA-SFI-TM , Integration with SuccessFactors BizX Talent Management , Problem

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