Saturday, October 22, 2011

IC: AH FP.K3 8223235 ORA-20001: THE ATTRIBUTE APPRAISAL_ID CANNOT BE UPDATED

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    
IC: AH FP.K3 8223235 ORA-20001: THE ATTRIBUTE APPRAISAL_ID CANNOT BE UPDATED
Symptoms:
We have 4 Appraisal periods in PMP. After 1st period ends, objectives are not visible for 2nd and subsequent reviews. Reason - process 'Mass Appraisal Creation' can't compete successfully.
Error: ORA-20001: The attribute appraisal_id cannot be updated
Log files:
TRACE FILE
-------------------
+---------------------------------------------------------------------------+
Human Resources: Version : 11.5.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

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

Current system time is 01-JUL-2009 14:47:37

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

**Starts**01-JUL-2009 14:47:38
**Ends**01-JUL-2009 14:47:40
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Entering:hr_wpm_mass_apr_push.appraisal_push, 10
hr_wpm_mass_apr_push.appraisal_push, 20
Plan Name: Z Performance Management Plan 2009, 21
Concurrent Request ID: 1126254, 22
hr_wpm_mass_apr_push.appraisal_push, 30
Entering:hr_wpm_mass_apr_push.populate_plan_apprsl_periods, 10
Leaving:hr_wpm_mass_apr_push.populate_plan_apprsl_periods, 80
hr_wpm_mass_apr_push.appraisal_push, 40
hr_wpm_mass_apr_push.appraisal_push, 50
hr_wpm_mass_apr_push.appraisal_push, 60
hr_wpm_mass_apr_push.appraisal_push, 70
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
Processing Appraisal for scorecard 60, 10
get_scorecard_info hr_wpm_mass_apr_push.create_appraisal_for_person, 20
get_assignment_info hr_wpm_mass_apr_push.create_appraisal_for_person, 20
get_appraisal_templ_info hr_wpm_mass_apr_push.create_appraisal_for_pe, 20
rson, 20
p_appr_initiator_code = EMP
login person = 4485
login name = AU_DEEPAK.SETHI
resp id = 50261
p_appraisal_sys_type = STD
MGR MENU = HR_MANAGER_APPRAISALS_MENU
EMP MENU = HR_EMPLOYEE_APPRAISALS_MENU
l_appraisal_mgr_menu = HR_MANAGER_APPRAISALS_MENU
l_appraisal_empl_menu = HR_EMPLOYEE_APPRAISALS_MENU
l_selected_menu = HR_EMPLOYEE_APPRAISALS_MENU
l_function_id = 23334
l_function_name = HR_STANDARD_APPRAISAL_SS
l_function_id = 23334
l_function_name = HR_STANDARD_APPRAISAL_SS
l_func_params = pSystemType=EMPSTD&pItemType=HRSSA&pProcessName=HR_APP
RAISAL_DETAILS_JSP_PRC&pApprovalReqd=YD&pAMETranType=SSHRMS&pAMEAppId=
800&pCalledFrom=HR_STANDARD_APPRAISAL_SS&pFunctionId=23334&pMenuId=778
88&OAFunc=HR_STANDARD_APPRAISAL_SS
find_appraisal: Found Appraisal for this Person 7321:3102, 20
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 80
hr_wpm_mass_apr_push.appraisal_push, 80
hr_wpm_mass_apr_push.appraisal_push, 90
hr_wpm_mass_apr_push.appraisal_push, 100
hr_wpm_mass_apr_push.appraisal_push, 50
hr_wpm_mass_apr_push.appraisal_push, 60
hr_wpm_mass_apr_push.appraisal_push, 70
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
Processing Appraisal for scorecard 61, 10
get_scorecard_info hr_wpm_mass_apr_push.create_appraisal_for_person, 20
get_assignment_info hr_wpm_mass_apr_push.create_appraisal_for_person, 20
get_appraisal_templ_info hr_wpm_mass_apr_push.create_appraisal_for_pe, 20
rson, 20
p_appr_initiator_code = EMP
login person = 4485
login name = AU_DEEPAK.SETHI
resp id = 50261
p_appraisal_sys_type = STD
MGR MENU = HR_MANAGER_APPRAISALS_MENU
EMP MENU = HR_EMPLOYEE_APPRAISALS_MENU
l_appraisal_mgr_menu = HR_MANAGER_APPRAISALS_MENU
l_appraisal_empl_menu = HR_EMPLOYEE_APPRAISALS_MENU
l_selected_menu = HR_EMPLOYEE_APPRAISALS_MENU
l_function_id = 23334
l_function_name = HR_STANDARD_APPRAISAL_SS
l_function_id = 23334
l_function_name = HR_STANDARD_APPRAISAL_SS
l_func_params = pSystemType=EMPSTD&pItemType=HRSSA&pProcessName=HR_APP
RAISAL_DETAILS_JSP_PRC&pApprovalReqd=YD&pAMETranType=SSHRMS&pAMEAppId=
800&pCalledFrom=HR_STANDARD_APPRAISAL_SS&pFunctionId=23334&pMenuId=778
88&OAFunc=HR_STANDARD_APPRAISAL_SS
find_appraisal: Found Appraisal for this Person 12373:3103, 20
ORA-20001: The attribute appraisal_id cannot be updated

Cause: 
The attribute appraisal_id cannot be updated with the API per_obj_b
us.chk_non_updateable_args because it has already be set. 

Action: 
Respecify the attribute value for appraisal_id or contact your l
ocal support representative.
ORA-20001: The attribute appraisal_id cannot be updated

Cause: 
The attribute appraisal_id cannot be updated with the API per_obj_b
us.chk_non_updateable_args because it has already be set. 

Action: 
Respecify the attribute value for appraisal_id or contact your l
ocal support representative.
ORA-20001: The attribute appraisal_id cannot be updated

Cause: 
The attribute appraisal_id cannot be updated with the API per_obj_b
us.chk_non_updateable_args because it has already be set. 

Action: 
Respecify the attribute value for appraisal_id or contact your l
ocal support representative.
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 80
hr_wpm_mass_apr_push.appraisal_push, 80
hr_wpm_mass_apr_push.appraisal_push, 90
hr_wpm_mass_apr_push.appraisal_push, 100
hr_wpm_mass_apr_push.appraisal_push, 50
hr_wpm_mass_apr_push.appraisal_push, 60
hr_wpm_mass_apr_push.appraisal_push, 70
Entering:hr_wpm_mass_apr_push.create_appraisal_for_person, 10
Processing Appraisal for scorecard 62, 10
get_scorecard_info hr_wpm_mass_apr_push.create_appraisal_for_person, 20
get_assignment_info hr_wpm_mass_apr_push.create_appraisal_for_person, 20
get_appraisal_templ_info hr_wpm_mass_apr_push.create_appraisal_for_pe, 20
rson, 20
p_appr_initiator_code = EMP
login person = 4485
login name = AU_DEEPAK.SETHI
resp id = 50261
p_appraisal_sys_type = STD
MGR MENU = HR_MANAGER_APPRAISALS_MENU
EMP MENU = HR_EMPLOYEE_APPRAISALS_MENU
l_appraisal_mgr_menu = HR_MANAGER_APPRAISALS_MENU
l_appraisal_empl_menu = HR_EMPLOYEE_APPRAISALS_MENU
l_selected_menu = HR_EMPLOYEE_APPRAISALS_MENU
l_function_id = 23334
l_function_name = HR_STANDARD_APPRAISAL_SS
l_function_id = 23334
l_function_name = HR_STANDARD_APPRAISAL_SS
l_func_params = pSystemType=EMPSTD&pItemType=HRSSA&pProcessName=HR_APP
RAISAL_DETAILS_JSP_PRC&pApprovalReqd=YD&pAMETranType=SSHRMS&pAMEAppId=
800&pCalledFrom=HR_STANDARD_APPRAISAL_SS&pFunctionId=23334&pMenuId=778
88&OAFunc=HR_STANDARD_APPRAISAL_SS
find_appraisal: Found Appraisal for this Person 12636:3104, 20
Leaving:hr_wpm_mass_apr_push.create_appraisal_for_person, 80
hr_wpm_mass_apr_push.appraisal_push, 80
hr_wpm_mass_apr_push.appraisal_push, 90
hr_wpm_mass_apr_push.appraisal_push, 100
Number of errors occured:0, 108
Maximum errors allowed:3000, 109
Leaving:hr_wpm_mass_apr_push.appraisal_push, 110
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PRINT -------------+


Printing output file.
Request ID : 1126254 
Number of copies : 0 
Printer : noprint 

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


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 01-JUL-2009 14:47:41

Solution:


run the diagnostic as stated in NOTE.211747.1 HRMS11i.sql
 Download and review the readme and pre-requisites for Patch 7541270.
Download and apply Patch 6840731: 6840731 - ONE OFF FOR 6819797

Technical Description:
------------------------------------------------------------------------------
The issue is resolved by modifying the conditon in procedure
create_appraisal_for_person, so that Pending Appraisee feedback is also
included in addition to Completed appraisals.

Fixed file : per patch/115/sql/pewpmaprpush.pkb 115.30

Files delivered by this patch :

Product Directory File Version 
fnd patch/115/import afcpprog.lct 115.40 
fnd patch/115/import aflvmlu.lct 115.20 
fnd patch/115/import afmdmsg.lct 115.29 
per java/selfservice/appraisals/server AppraisalsHomeAMImpl.java 115.19 
per java/selfservice/appraisals/server EmpMyAppraisalsInProgressVO.xml 115.10 
per java/selfservice/appraisals/server EmpMyAppraisalsInProgressVORowImpl.java 115.4 
per java/selfservice/appraisals/server MgrAppraisalsInProgressVO.xml 115.10 
per java/selfservice/appraisals/webui EmpMyAppraisalsInProgressCO.java 115.2 
per java/selfservice/appraisals/webui MgrMainAppraiserInProgressCO.java 115.2 
per java/wpm/common/server EmpTaskVO.xml 115.15 
per java/wpm/common/server MgrTaskVO.xml 115.8 
per java/wpm/common/webui EmpPlanTasksCO.java 115.7 
per java/wpm/common/webui MgrPlanTasksCO.java 115.4 
per java/wpm/perfmgmtplans/webui UpdatePMPageButtonBarCO.java 115.8 
per java/wpm/perfmgmtplans/webui UpdatePMProcessCO.java 115.16 
per mds/wpm/common/webui EmpPlanTasksRN.xml 115.4 
per mds/wpm/common/webui MgrPlanTasksRN.xml 115.2 
per patch/115/import/US perzzcncprg00232.ldt 115.9 
per patch/115/import/US perzzlookup00528.ldt 115.3 
per patch/115/import/US perzzlookup02701.ldt 115.4 
per patch/115/import/US perzzmsg1003111.ldt 115.0 
per patch/115/import/US perzzmsg3002848.ldt 115.0 
per patch/115/sql pepmpbsi.pkb 115.51 
per patch/115/sql pepmpbsi.pkh 115.10 
per patch/115/sql pepmsrhi.pkb 115.3 
per patch/115/sql pepmsrhi.pkh 115.2 
per patch/115/sql pepmsrsd.sql 115.0 
per patch/115/sql pewpmaprpush.pkb 115.30 
per patch/115/sql pewpmaprpush.pkh 115.3

References:
run the diagnostic as stated in NOTE.211747.1 HRMS11i.sql
Note.565971.1 Ext/Mod After A Plan Is Published, If The Supervisor Of A Person Is Changed While Resubmitting The Plan A New Appraisal Is Created: 
BUG 6819797 - WPM IS CREATING DUPLICATE APPRAISALS FOR EMPLOYEES TRANSFERRED TO NEW MANAGER
After publishing plan ,if the supervisor of a person is changed while resubmitting the plan a new appraisal is created for the person
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: