NO_ASSIGNMENT_WITH_THIS_ID error in the log of the Mass Appraisal Creation Program

(Doc ID 1391659.1)

Last updated on DECEMBER 21, 2016

Applies to:

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

Symptoms

On : 11.5.10.2 version, WPM

On Production, the Mass Appraisals Creation program failed due to pending transactions
as explained in <Note 821068.1.>
When running the Mass Appraisal Creation program with the option "Yes" for parameter "Delete pending transactions"  the program terminates with Warnings.

ERROR
-----------------------
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
NO_ASSIGNMENT_WITH_THIS_ID
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 90
User-Defined Exception


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Mass Appraisal Creation program with the option "Yes" for parameter "Delete pending transactions"
2. The program terminates in yellow (warning)


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, all appraisals are not created.

DATA
-----------------------
Key information for this plan and this issue:

START_DATE : 01-Jul-2011
END_DATE : 30-Jun-2012
OBJ_SETTING_DEADLINE : 29-Dec-2011
ASSIGNMENT_TYPES_CODE : E
PRIMARY_ASG_ONLY_FLAG : Y
LAST_UPDATE_DATE : 03-Jan-2012

Appraisals:
PERIOD_ID|TEMPLATE_ID|START DATE |END DATE |TASK STDT |TASK ENDDT |INIT~R|SYS_TYPE|AUTO_CONC|DAYS_BFR
23 |1 |01-Jan-2012|29-Feb-2012|01-Jan-2012|29-Feb-2012|EMP |STD |Y |0

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