ORA-06502: PL/SQL: Numeric or Value Error: NULL Index Table Key Value When Publish or Republish the Plan
(Doc ID 2258362.1)
Last updated on SEPTEMBER 09, 2024
Applies to:
Oracle Performance Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
When attempting to republish a plan with Reevaluate Plan Population option, the Republish Performance Plan process failed and the following error can be found on concurrent log:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
STEPS
The issue can be reproduced at will with the following steps:
1. Using HR Professional responsibility.
2. Navigate to Performance Management page.
3. Go to Performance Management Plans link.
4. Search for the plan > Click on Update option.
5. Click Next option till the republish plan options are displayed.
6. Select Reevaluate Plan Population option > Click on Republish option.
7. Concurrent Republish Performance Plan finished in error.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |