E1: ORCH: Orchestration/Service Request Data Request That Reads F0911- Table is Failing When Reading More Than 1000 Records (Doc ID 2535293.1)

Last updated on AUGUST 16, 2021

Applies to:

Goal

Created a new orchestration that reads data from the F0911 and writes this data to a csv file.
Noticed the following :
1. When the option is zero records on the service request then the limit seems to be 1000000 records because the sql statement is adding a fetch first 1000000 rows only:
  - Is 1000000 the limit and is this through a parameter?
  - The error that is displayed in the logs are a JAS MSG346 error which indicates a JAS database failure

2. When changing the option to 2000 records then the Orchestration client comes back with an out of memory error related to Java Heap space.
  - Did not use the caching option --> is there a calculation for the amount of memory needed?

3. When changing the option to 1000 records, then the orchestration goes through with no issues.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.