My Oracle Support Banner

Payroll ECC Data Load Fails with ORA-01000: maximum open cursors exceeded (Doc ID 2873327.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Oracle Payroll - Version 12.2.6 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to run Payroll ECC Data Load, child process "ECC Run Data Load" fails with the following error.

There is an error while trying to ingest data for this load rule pay_gen_ecc_data_load.GET_ECC_DATA_LOAD_INFO with dataset pay-dashboard for job 45,735 ORA-00604: error occurred at recursive SQL level 1

ORA-01000: maximum open cursors exceeded



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Login as HRMS Manager responsibility

  2. Submit "Payroll ECC Data Load"
    (N) Processes and Reports > Submit Processes and Reports > Single Request
  3.  The child process "ECC Run Data Load" fails with the error.



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

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