Webservice (SOAP) used to retrieve data from Oracle EBS 12.1.3(RPC5) hits a size limit
SOAP based web-service is used to retrieve data from Oracle EBS.
It returns records provided payload size is below 20 MB.
This issue is noticed for multiple web service API`s and is irrespective of record count.
One of the API hits the size limit with 900 records while another one hits this size limit at around 17,000 records.
Webservice work fine if this size limit is not breached.
Once the record count fetches around 20MB of payload, it returns 'Receiving response: HTTP/1.1 500 Internal Server Error'.
EBS-12.1.3(RPC5) , Patch 27913724:R12.OWF.B: ISG Consolidated Patch for Release 12.1.3 (18_2_2) applied.
Please advise on how this payload sizing is setup. Any options to overcome this limit.