E1: 31A: R31802A Memory Leaks Cause Data Integrity Issues (Doc ID 2466893.1)

Last updated on NOVEMBER 15, 2024

Applies to:

Symptoms

E1 9.0 / Manufacturing Accounting, R31802A

R31802A, when run over large amounts of data is giving 'no memory' error on the work center error messages and causing a memory leak.                                                                
When looking at the logs we also see pointer and possible cursor leaks.                                                                
This is causing integrity issues between cardex and F0911.  Cardex has IM, and IC transactions but those transactions are not found in the F0911.                        
PDF is showing IH transactions only but they are duplicated. CTS1 for F3111 and F4801 are cleared.  Errors seen in the log:                                       
DB9900600 - Failed to store value, maximum exceeded.  Probable cause is forgetting to call jdeRemoveDataPtr().                                                                                    
CAC0001017 - (jdeCacheOpenCursor) failed to open cursor due to reach the max #cursors (100) for cache (0B3003130-1).

Changes

Cause

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