My Oracle Support Banner

Concurrent Program "Change The Top Supervisor For Plan" Ends Up in Error "ORACLE error 6510 in FDPSTP", "ORA-06510: PL/SQL: unhandled user-defined exception", "ORA-06512: at "APPS.HR_PERF_MGMT_PLAN_INTERNAL", line 10002" (Doc ID 2900348.1)

Last updated on OCTOBER 04, 2022

Applies to:

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


When executing the program "Change the Top Supervisor for Plan" in Rollback mode, Program ends in error and the following error is logged in the Log File



Human Resources: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

PERWPMADMINCP: Performance Management Plan Administration Tasks


Current system time is 10-JUN-2022 14:32:54


**Starts**10-JUN-2022 14:32:54

**SQL error and free**10-JUN-2022 14:32:56

ORACLE error 6510 in FDPSTP

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception

ORA-06512: at "APPS.HR_PERF_MGMT_PLAN_INTERNAL", line 10002

ORA-06512: at line 1

The SQL statement being executed at the time of the error was:10-JUN-2022 14:32:56


Start of log messages from FND_FILE


after effective date



New supervisor id: 30211

new supervsior_id is: 30211





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

1. Login to "HR Professional V4.0" Responsibility.

2. Navigate to function "Performance Management".

3. In the launched page, under the cluster "Administration".

4. Click on the link "Plan Administration".

5. In the launched page, select the plan for which the Top Supervisor needs to be changed.

6. Now select the task "Change the Top Supervisor for Plan" and click on "Continue" button.

7. In the launched page, enter the "New Supervisor" value and with Mode selected as "Rollback", click on the "Submit" Button.

8. Now go back to application home page and navigate to HR Professional V4.0 --> Performance Management.

9. In the launched page, under the cluster "Batch Requests", click on the link "Process Monitor and Reports".

10. In the launched page, you can review the status of the concurrent program being called. The status of the program is error-ed out and when opened up the error log, saw the error message above.


The issue has the following Business Impact: Due to this issue, End user is not able to change the Top Supervisor of the plan, after there was a change in top management in the organization.

                                                                                    Since this top supervisor change is not happening, user is not able to proceed with their appraisal review process as well.


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.