Employees Appraisal Is 'Pending Approval' After It Is Completed By Main Appraiser: Error Message 3103: Attribute 'HR_APPR_COMPL_STATUS' does not exist for item 'HRSSA/72416'.

(Doc ID 1537138.1)

Last updated on NOVEMBER 08, 2017

Applies to:

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


On : 12.1 HRMS RUP4 version, Appraisals

For some of the employees appraisal status is 'Pending Approval' after it is completed by main appraiser.
For all employees where appraisal status is PENDINGAPPR, manager is active and appraisals not rejected by manager.
Employee appraisal status is showing as 'Pending Approval' and all fields are grayed out. So employee or manager can not update anything.

Workflow status is Error with below details :

For is happening for some of employees in production as well as non production environments for same employees.


3103: Attribute 'HR_APPR_COMPL_STATUS' does not exist for item 'HRSSA/72416'

Workflow status is Error with below details :
Failed Activity Appraisal Commit Transaction V5.1
Activity Type Function
Error Message 3103: Attribute 'HR_APPR_COMPL_STATUS' does not exist for item 'HRSSA/72416'.
Error Stack Wf_Engine.SetItemAttrText(HRSSA, 72416, HR_APPR_COMPL_STATUS, E) hr_appraisal_workflow_ss..commit_transaction(HRSSA, 72416, 248139, RUN) Wf_Engine_Util.Function_Call(hr_appraisal_workflow_ss.commit_transaction, HRSSA, 72416, 248139, RUN)

Customer ran the update script from NOTE 553537.1 however after both of update queries, appraisal is accessible according to it's status as 'PLANNED' or 'ONGOING' but after appraisal is completed by appraiser, it is again goes into 'Pending Approval' and all fields goes grayed out.

The issue can be reproduced at will with the following steps:
1. Completion of appraisal from appraiser


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