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 MAY 07, 2024

Applies to:

Symptoms

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

ERROR
-----------------------

"+---------------------------------------------------------------------------+

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

l_task_code:CHANGE_TOP_SUPERVISOR

l_sub_taskcode:

New supervisor id: 30211

new supervsior_id is: 30211

Commit:Y

............

........................."

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

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.

BUSINESS IMPACT
-------------------------------------

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.

Cause

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