My Oracle Support Banner

Publish Performance Management Plan Concurrent Fails with Error: ORA-20001: Data PER_EMP_NUMBER Not Found (Doc ID 2925780.1)

Last updated on MARCH 13, 2023

Applies to:

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



Publish Performance Management Plan concurrent finish in error after creating a new performance management plan. The following error can be found on performance management plan log page:

Eligibility Check errored for: XXX, Mr. (61). No Scorecard created.
ORA-20001: Data PER_EMP_NUMBER not found at line 10 of PIP_2023_UJ
Not Eligible. Publish plan SKIPPED for XXX, Mr. (61).
elig ORA-06512: at "APPS.HR_UTILITY", line 949

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

1. Using HRMS Manager responsibility.

2. Navigate to Payroll > Assignment Set.

3. Create an Assignment set using the following Criteria:

Database item = &PER_EMP_NUMBER

4. Generate the fast formula.

5. Create an Eligibility profile using Assignment set created.

6. Using HR professional responsibility > Performance Management.

7. Create a Performance plan using eligibility criteria > Publish the plan.

8. Publish Performance Management Plan concurrent finish in error.




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.