E1: 07: Pre-Payroll DBA Calculation Source File (B0700005) Not Closing Cursor To Timecard Cache Causing Max Cursors To Be Exceeded.
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.
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)
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