SAP Knowledge Base Article - Public

3084387 - SF Odata Query Error [COE0020]Permission picklists_sys_admin is required

Symptom

Query response from SFOdata.Picklist, SFOdata.PicklistOption, PicklistLabel, or other picklist entities is showing below error.

Sample Query :

https://apisalesdemo4.successfactors.com/odata/v2/Picklist?$format=json$expand=picklistLabels$select=externalCode,picklistLabels/label,picklistLabels/locale

{

"error":{"code": "COE_GENERAL_FORBIDDEN",

"message": {

"lang": "en-US",

"value": "[COE0020]Permission picklists_sys_admin is required"

}}}

"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

  • SAP SuccessFactors HXM Suite OData API

Reproducing the Issue

1.Execute API Query request for a picklist entity type

https://<api_host_endpoint>/odata/v2/Picklist

2. See Error : "[COE0020]Permission picklists_sys_admin is required"

Cause

Missing Permission or Insufficient Permission

Resolution

To resolve error, need below Permission enabled to the Role assigned to the API User.

Admin Center --> Manage Permission Roles --> Manage system properties --> "Picklist Management and Picklists Mappings Set Up".

Authorization/Action

In Permission..., choose

Additional Info

Picklist Handling in OData and SOAP

Administrator Permissions  Manage System Properties  Picklist Management and Plicklists Mapping Set Up

For more information, see picklists.

See Also

SAP Successfactors HXM Suite Odata API Reference Guide >> Section Permissions

Keywords

COE_GENERAL_FORBIDDEN, [COE0020] Permission picklists_sys_admin is required, Picklist Management and Picklists Mappings Set Up, SFOdata.Picklist, SFOdata.PicklistOption, SFOdata.PicklistLabel, responsCode=403 , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM suite all versions