Checklist Process Errors With 'cursor Already Open'

(Doc ID 2020478.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP5 version, Checklist

When attempting to run the Allocate Checklists and Tasks process the following error occurs in the logfile.

ORACLE error 6511 in FDPSTP
Cause: FDPSTP failed due to ORA-06511: PL/SQL: cursor already open
ORA-06512: at "APPS.PER_CHECKLIST_EVENTS", line 844
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Hire a new employee who will be allocated a checklist
2. run Allocate Checklists and Tasks process


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