E1: 42W: Reduce Cursors Allocated To Order Fulfillment Cache Functions (Doc ID 1935315.1)

Last updated on OCTOBER 02, 2017

Applies to:

JD Edwards EnterpriseOne Fulfillment Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

Auto Fulfillment (R4277701) crashes due to memory issues when a large number of records are processed and repetetive data is loaded to cache for each line processed.

Caches used by  Auto Fulfillment (R4277701)during phase 1 of the process include:

Allocation Quantity Cache (B4277711),                      
Auto Allocation Commit Cache (B4277715),                    
Auto Fulfillment Errors Cache (B4277745),                  
Auto Fulfillment Save UKID (B4277755),                      
Auto Fulfillment Data Cache (B4277758),                    
SLR Header Cache (B4277775),                                
SLR Detail Cache (B4277776)

Currently all of the listed functions initialize the respective cache to 50 cursors.

The initialization of cache cursors should be reduced from 50 to 10 per business function to reduce the memory consumption and eliminate memory crashes after processing just 10,000 lines.

STEPS TO REPRODUCE:

  1. Setup Order Level and Line Level Service Level Rules in Fulfillment Management.
  2. Create more than 20,000 order lines which enter Fulfillment Management
  3. Run Auto Fulfillment (R4277701) over 20,000 order lines.
  4. The job ends in E-Error status after processing failed after processing about 10,000 records and Oracle Database errors indicating memory problems appear in the JDE.LOG, such as OCI0000020 - Out of memory for allocating return values

Cause

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