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

Last updated on APRIL 09, 2023

Applies to:

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

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