Error ORA-01000: Maximum Open Cursors Exceed While Running Pin_cycle_fees. (Doc ID 3047180.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Symptoms

ERROR in dm_oracle logs:
-----------------------

STEPS
-----------------------

pin_cycle_fees is run for duration of one day for the customer accounts as per following:

pin_cycle_fees -verbose -regular_cycle_fees -start 05/18/24 -end 05/19/24

NOTE: After checking from Database end following SQL Id is found to be causing the issue -

select sql_text from v$sql where sql_id = 'SQL_ID';
BEGIN PIN.acct_sync.enq_event(:event_name, :flist_buf, :flist_buf_len, 'PIN.IFW_SYNC_QUEUE', :mesg_id) ;END;

Cause

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