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 laterInformation 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 |