My Oracle Support Banner

Get All Contracts REST API Is Only Fetching 500 Contracts (Doc ID 2779820.1)

Last updated on MARCH 07, 2023

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Symptoms

 On : 11.13.21.01.0 version, Webservice

Get all contracts REST API (https://<env>/fscmRestApi/resources/11.13.18.05/contracts?totalResults=true&fields=Id&onlyData=true) is only fetching 500 contracts.

If we run without specifying any limit and offset, then totalResults show 1079 and hasMore=true.

If we run with limit = 500, then it shows 500 contracts with below footer.
"totalResults": 500,
"count": 500,
"hasMore": false,
"limit": 500,
"offset": 0,

We can't retrieve the next 500 records by setting offset = 500.

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.