Mass Appraisals: Mass Appraisals Creation Program errors: ORA-01403: No Data Found (Doc ID 1192344.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Performance Management - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


This note provides a brief overview of internal Bug:8526120


Symptoms

When attempting to create appraisals automatically through a plan by running the WPMAPRPUSH module: Mass Appraisal Creation program, the following error occurs.

WPMAPRPUSH module: Mass Appraisal Creation
+---------------------------------------------------------------------------+

Current system time is 21-JUN-2010 13:11:59

+---------------------------------------------------------------------------+

**Starts**21-JUN-2010 13:11:59
**Ends**21-JUN-2010 13:12:03
The Publish Performance Management Plan concurrent program completed with errors. Please see the log file for details.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Entering:hr_wpm_mass_apr_push.populate_plan_apprsl_periods, 10
Leaving:hr_wpm_mass_apr_push.populate_plan_apprsl_periods, 80
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 90
ORA-01403: no data found
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 90
ORA-01403: no data found
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 90
ORA-01403: no data found
Number of errors occured:3, 108
Maximum errors allowed:100, 109
Leaving:hr_wpm_mass_apr_push.appraisal_push, 110
+---------------------------------------------------------------------------+
End of log messages from FND_FILE




STEPS TO REPRODUCE

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

1. A non global hierarchy defined:
- name = PMS TEST3
- version number = 1
- Date from = 01-jan-2010
- top org = NL001_ROTTERDAM_HR
- subordinate = NL001_ROTTERDAM_PAYROLL

2. top org
name = NL001_ROTTERDAM_HR
date from = 01-jan-2010
org class. = HR Organization

subordinate org
name = NL001_ROTTERDAM_PAYROLL
date from = 01-jan-2010
org class. = HR Organization

3. EMPLOYEE 1
employee number = 102
full_name = KM.J.
org = NL001_ROTTERDAM_PAYROLL
supervisor = D.S.K, assignment_number = 48786

EMPLOYEE 2
employee number = 103
full_name = GPTO.
org = NL001_ROTTERDAM_PAYROLL
supervisor = D.S. K, assignment_number = 48786

SUPERVISOR
employee number = 48786
full_name = D.S. K
org = NL001_ROTTERDAM_HR
supervisor = A.V.Ome), assignment_number = 63180

4. Create Plan: General Information
name = PMS TEST4
start date = 01-jan-2010
end date = 31-dec-2010

Create Plan: Population
hierarchy ty� = organization
organization hierarchy = PMS TEST3
hierarchy version = 1
top organization = NL001_ROTTERDAM_HR

Create Plan: Process
Include Objective Setting in Process = yes
Start Date = 01-jan-2010
Deadline = 20-jun-2010
method = cascading
automatic allocation = yes
Include Appraisals in Process = yes
Appraisal Template = PMS MEES3
Period Start Date = 01-jan-2010
Period End Date = 31-dec-2010
Task Start Date = 21-jun-2010
Task End Date = 31-dec-2010
Initiator = main appraiser
Appraisal Type = standard appraisal
purpose = annual
create appraisals = yes

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