My Oracle Support Banner

REST API Unexpected Number of Results For Account Object When Ordering By Contact Attributes (Doc ID 2650702.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion B2B Service Cloud Service - Version and later
Information in this document applies to any platform.


Integration user was fetching in pagination way, Accounts, by doing Get call to REST API, and passing query parameters and conditions in the WS API.

I.e. the user was using a API like this : https:// <pod url >/crmRestApi/resources/latest/accounts?onlyData=true&offset=20&limit=20&totalResults=true&q=OrganizationName like '*Test*'&orderBy=PrimaryContactName:asc

If certain fields were passed in the "orderBy" parameter on query, the results and their count on the response are returned with different values than the standard SQL queries done for the fusion tables i.e. SELECT * FROM FUSION.HZ_PARTIES WHERE PARTY_NAME LIKE ''%Test% AND STATUS = 'A'.

The ordering fields that were observed to do this are the ones that relate the Account to a contact, namely:



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

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