Error Removing Scorecards in Performance Management Plan Administration Tasks Log for More Than One Plan Members in One Attempt (Doc ID 2090974.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Performance Management - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
When attempting to remove scorecard for more than one plan members in one attempt then we receive below error in concurrent request "Performance Management Plan Administration Tasks" logfile.  If we try to remove scorecard for one plan member at a time then no error has been received.

Error:
PERWPMADMINCP module: Performance Management Plan Administration Tasks
+---------------------------------------------------------------------------+
Errors occured processing the selected persons. Pl. check the concurrent log for details.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
after effective date
l_task_code:REMOVE_SC
l_sub_taskcode:
Number of selected persons: 10
Removing scorecard for: Mr. XXX
Removing scorecard for: Mr. YYY
Error removing scorecard:YYY- NOT_STARTED_WITH_MGR.
ORA-06511: PL/SQL: cursor already open
Removing scorecard for: ZZZ
Error removing scorecard:ZZZ- NOT_STARTED_WITH_MGR.
ORA-06511: PL/SQL: cursor already open

Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to HR Profession v4.0 => Performance Management => Performance Management Plan => Create a Performance management Plan.
2. Now navigate to HR Profession v4.0 => Performance Management => Plan Administration => Query for Plan => select "Remove Scorecard" => Click "Continue".
3. Select more than one plan members for scorecard removal. => Click "Submit".
4. Now navigate to HR Profession v4.0 => Performance Management => Process Monitor and Reports => Concurrent program "Performance Management Plan Administration Tasks" has completed in status "Warning".
5. Click on log file for concurrent program, gives error NOT_STARTED_WITH_MGR.ORA-06511: PL/SQL:cursor already open

Cause

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