Pagination capped at 500 for many resources. Paginating using the key column also not possible.
[REST APIs]
There are quite a few resources like Expenses (https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-expenses-get.html), TaxTransactionBusinessCategories (https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-taxtransactionbusinesscategories-get.html) etc. which stop returning items after fetching first 500 items (offset=500). Even though more items exist, the hasMore attribute is returned as false.
A workaround is to paginate using the key attribute. For example, we can fetch more results for Expenses using q=ExpenseId>{last_id_in_the_response}&limit=100&orderBy=ExpenseId:asc.
But the fix is not possible for resources which do not have a key attribute defined or more than one attribute is a key. For example: TaxTransactionBusinessCategories does not list any finder variable for its PrimaryKey Finder (https://docs.oracle.com/en/cloud/saas/financials/26d/farfa/op-taxtransactionbusinesscategories-get.html). Also neither