My Oracle Support Banner

Fusion HCM REST API: Error While Using OrderBy on an Attribute From a Child Resource (Doc ID 2723180.1)

Last updated on OCTOBER 26, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

 
When attempting to perform a GET on workers hcmRestApi with orderBy=names.FirstName (an attribute from a child resource),
the following error occurs.

ERROR
-----------------------
{
"title": "Bad Request",
"status": "400",
"o:errorDetails": [
{
"detail": "URL request parameter orderBy with value names.FirstName is not valid.",
"o:errorCode": "27519"
}
]
}

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. GET on <host> /hcmRestApi/resources/11.13.18.05/workers?onlyData=true&fields=PersonNumber;names:FirstName,DisplayName,FullName&orderBy=names.FirstName

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.