Symptom
When performing an SFAPI query to EmpPayCompNonRecurring entity, the payComponentCode field is not returning any data.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HXM Suite
- SFAPI
Reproducing the Issue
- The SFAPI call below is performed:
<queryString>SELECT pay_date,payComponentCode,user_id FROM EmpPayCompNonRecurring WHERE (person_id_external IN ('1111'))</queryString> - The response contains no value in payComponentCode:
<sfobject>
<id>EMPCN-4324</id>
<type>EmpPayCompNonRecurring</type>
<pay_date>2020-01-01</pay_date>
<payComponentCode xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<user_id>1111</user_id>
</sfobject>
Cause
The value of payComponentCode will return null if the pay component on current day is inactive.
This happens only in SFAPI, in OData this status check is not done.
Resolution
Please make sure that the pay component being selected is active at the day the query is performed.
See Also
Keywords
sfapi, deprecated, status, active, inactive, paycomponent, pay component, pay component code, , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem