Symptom
When trying to find the field Application Date using Integration Center, or when executing a query in OData/SFAPI, I am not able to find it like we do in Ad-Hoc.
Environment
SAP SuccessFactors Recruiting Management
Reproducing the Issue
- Open Reporting, and create a new Recruiting V2 table report;
- Select columns and search for "Application Date";
- Now go to Integration Center, and create a new Integration;
- Select the JobApplication Entity, and look for the Application Date field;
- Not able to find it.
Cause
This happens because the Application Date is not an Exposed field through API. The field Application Date is not stored directly into a Database table/column, and that is the reason why we can't find it in Integration Center, neither OData API or SFAPI.
Resolution
In order to make the field visible, you need to configure the standard field applicationDate in application template.
How come that we see the field in Ad-Hoc then? Ad-hoc has some additional columns that are not found in Integration Center. That is because IC is pulling the data straight out from the database, the only information we have there is the information that is stored on the database. Now, on the Ad-Hoc side, we have native calculated columns, which are hardcoded into the product functionality accordingly to the necessity of the customers.
On Ad-hoc, when we see the Application Date column, we are actually seeing a calculation that the system is doing, getting information from the Audit and displaying to us on the field value.
Keywords
ad-hoc, ad, hoc, column, calculated, system, field, hard, coded, application, date, column, missing, can, not, find, found, integration, center, odata, api, sf , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem