E1: 42: Invoice Print (R42565) With RTE Activated Has Memory Leak in LoadandUnloadInvoiceCache (B4003100) business function (Doc ID 2860979.1)

Last updated on JUNE 15, 2022

Applies to:

Symptoms

When attempting to run Custom Invoice Print (R5542565VI) over a large data selection, with Real Time Events (RTE) activated the following error appears in the JDE.LOG.

CAC0001017 - (jdeCacheOpenCursor) failed to open cursor due to reach the max #cursors (100) for cache (0B4003100)

The memory leak is coming from LoadandUnloadInvoiceCache (B4003100) which is specific to RTE.

There have been no ESUs created for bugs in the LoadandUnloadInvoiceCache (B4003100) business function.

The client reports that the Invoice is processed to completion, but the system stops sending RTE events after reaching max #cursors (100).

We verified the issue in a zoom conference with the client following the steps below:

1. Custom Invoice Print (R5542565VI) ran to completion (D-Done) status on 4/5/2022 but stopped sending Real Time Events after reaching Max 100 Cursors.
2. Invoice Report PDF shows 987 pages of “Proof” invoices were processed.
3. JDE.LOG shows error:
   1. CAC0001017 - (jdeCacheOpenCursor) failed to open cursor due to reach the max #cursors (100) for cache (0B4003100)
4. Run a test of Custom Invoice Print (R5542565VI) version with just 3 invoices with JDEDEBUG.LOG on.
5. Three Invoices were printed.
   1. JDEDEBUG Log shows the business function opening and not closing the cursors is LoadandUnloadInvoiceCache (B4003100)

Cause

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