My Oracle Support Banner

offset does not work for REST API expenseReports (Doc ID 3043936.1)

Last updated on AUGUST 27, 2024

Applies to:

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

Symptoms

 Response results("totalResults", "count" , and "hasMore") are incorrect when execute REST API expenseReports with offset.

[NO offset]
- Request
https://fa-xxxx-xxxx.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/expenseReports?limit=499&totalResults=true&onlyData=true
- Response
"totalResults" : 8550,
"count" : 499,
"hasMore" : true,
"limit" : 499,
"offset" : 0,
"links" : [ {
"rel" : "self",
"href" :
"https://fa-xxxx-xxxx.fa.ocs.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/expenseReports",
"name" : "expenseReports",
"kind" : "collection"
} ]

[With offset=50]
- Request
https://fa-xxxx-xxxx.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/expenseReports?limit=499&totalResults=true&offset=50&onlyData=true- Resonse
"totalResults" : 500,
"count" : 450,
"hasMore" : false,
"limit" : 499,
"offset" : 50,
"links" : [ {
"rel" : "self",
"href" :
"https://fa-xxxx-xxxx.fa.ocs.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/expenseReports",
"name" : "expenseReports",
"kind" : "collection"
} ]
}

totalResults , count , and hasMore are incorrect .

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.