Update an Action for the First Objective Created in a Scorecard - Errors: ORA-20002: 3000: Invalid Value(s) Passed for Arguments (Doc ID 1072146.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Performance Management - Version 12.0 HRMS RUP 7 to 12.1.2 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked For relevance on 01-FEB-2013***

This note provides a brief overview of

Symptoms

Problem Statement:

In Manager or Employee Self-Service, through All Actions Awaiting Your Attention, when attempting to update an action for the first objective created in a scorecard the following error occurs.

## Detail 0 ##
java.sql.SQLException: ORA-20002: 3000: Invalid value(s) passed for arguments. ITEMTYPE=NULL ITEMKEY=NULL ANAME=PROCESS_NAME
ORA-06512: at "APPS.PQH_SS_WORKFLOW", line 1196
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)




Steps to Reproduce:

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

  1. Log in with a manager, make sure that this manager is participating in a PMP, and he has an employee who has sent him the scorecard earlier (and the scorecard was approved), or the scorecard is blank, and no action was taken on it yet.
  2. Choose Manager Self Service and Performance Management. Click on the Go to task icon of the Cascade or set objectives task for your Performance Management Plan (PMP).
  3. Choose the employee, and click on the Action icon.
  4. Click on the Create Objective button. Enter the objective details, then click on Apply.
  5. Click on Home. Choose the All Actions Awaiting Your Attention function.
  6. There is a new Action created in the table. The subject is a number, and it is not clickable. The Update and the Delete icons are enabled. If you click on Update, you get an unexpected error page . If you click on Delete, then after confirmation, the action is deleted. 
  7. Go back to the Performance Management homepage, and Transfer the scorecard to the employee. Log out.
  8. Log in as the Employee. Use Employee Self Service, Performance Management.
  9. Click on the Go to task icon for the Set objectives task. Create a new objective, click on Apply, then click on home.
  10. Choose the All Actions Awaiting Your Attention function. A new action is created, the subject is a non clickable number, the Update and the Delete icons are enabled. Do not click any of them!
  11. Click on Home again, and navigate to Performance Management. Create a second objective for the employee, then click on Home, and go to All Actions Awaiting Your Attention.

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