Symptom
While querying CompoundEmployee API Data through the Employee Delta Export spreadsheet, the following Error message is thrown:
Environment
SuccessFactors
Employee Delta Export spreadsheet
Reproducing the Issue
- Download the Employee Delta Export and the Excel Add-In from Admin Centre [For further details please refer to KBA 2358156 - How to query data using the MS Excel Add-In from Successfactors]
- Download and install the Excel Add-In and open the Employee Delta Export
- Enter the relevant parameters related to connection settings [For further details please refer to KBA 2358156 - How to query data using the MS Excel Add-In from Successfactors]
- Click on Get Data
- Permission-related error messages such as "The system cannot locate the resource specified" are logged in Error/Warning cell
Cause
SFAPI permission issues inevitably lead to errors on the Report.
Resolution
Below are the Permissions a user needs to extract data using the 'Compound Employee API' viz 'Employee Delta Export':
● Manage System Properties
○ Picklist Management and Picklists Mappings Set Up
● General User Permission
○ SFAPI User Login
● Employee Central API
○ Employee Central Foundation SOAP API
○ Employee Central HRIS SOAP API
○ Employee Central Foundation SOAP AP
○ Employee Central HRIS OData API
● Manage Integration Tools
○ Admin access to OData API
The following permission is required to access the Employee Delta Export UI:
● Manage Employee Delta Exporting Templates
You can set this permission in one of the following permission groups:
● Manage Dashboards / Reports
● Manage User
After setting the permission, logout and login again. You can now find Employee Delta Export link in 'Admin Center' and you can search for it using the Admin Tools search field.
NOTE: The document "Using the Employee Delta Export Add-in for Microsoft Excel" contains detailed information about the report. For details on how to download the document please refer to KBA #2358156 - How to query data using the MS Excel Add-In from Successfactors
See Also
Keywords
- Employee Delta Export
- CompoundEmployee API
- Error message: "The System cannot locate the resource specified".