My Oracle Support Banner

E1: 07: Pre-Payroll DBA Calculation Source File (B0700005) Not Closing Cursor To Timecard Cache Causing Max Cursors To Be Exceeded. (Doc ID 2358349.1)

Last updated on FEBRUARY 07, 2018

Applies to:

JD Edwards EnterpriseOne US Payroll - Version 9.0 to 9.2 [Release 9.0 to 9.2]
Information in this document applies to any platform.

Symptoms

On : 9.0 version, Payroll

When submitting Pre-Payroll for Payroll IDs that process a large number of employees, the R07200 (Pre-payroll) does not complete processing and when the job is terminated only a small number of employees are processed and can be seen in the payment review screen.

The following error can be seen repeatedly in the jde log:

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


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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