Responses To REST API Very Slow

(Doc ID 2304492.1)

Last updated on SEPTEMBER 09, 2017

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Performance

ACTUAL BEHAVIOR
---------------
Responses to REST API very slow

When invoking the below REST API URL for retrieving 100 accounts, the response mostly times out and sometimes takes more than 2 minutes to return data

https://<URL>/crmCommonApi/resources/latest/accountsq?expand=PrimaryAddress&fields=PartyUniqueName,PartyNumber,OrganizationDEO_ID_Index_c,OrganizationDEO_ID_c;PrimaryAddress:AddressLine1,AddressLine2,City,Country,PostalCode,AddressId,State&totalResults=true&offset=0&limit=100&onlyData=true

EXPECTED BEHAVIOR
-----------------------
Responses shouldnt be slow

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Browser
2. Call web service using the URL
https://<URL>/crmCommonApi/resources/latest/accountsq?expand=PrimaryAddress&fields=PartyUniqueName,PartyNumber,OrganizationDEO_ID_Index_c,OrganizationDEO_ID_c;PrimaryAddress:AddressLine1,AddressLine2,City,Country,PostalCode,AddressId,State&totalResults=true&offset=0&limit=100&onlyData=true
3. Response is slow

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the responses in timely manner.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms