Web Services Seems To Be Limiting Rows

(Doc ID 2019606.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


Web services seems to be limiting rows.

Want to use web services to pull a few fields in ALL records from Opportunities.

When  remove the filter from the payload,  only get 500 rows, but  there are at least 2500 opportunities in the database.

To be able to get all the information from Opportunities using WebServices

The issue can be reproduced at will with the following steps:
1) Run the payload
2) Count the rusults
3) Open DTA
4) Export all Opportunity records
5) Count results
6) Compare count in step 2 with count is step 5


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