Unable To Make Mass Change Main Appraiser

(Doc ID 2322671.1)

Last updated on OCTOBER 30, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, Appraisals

When attempting to update appraisals using the Mass Change Main Appraiser function, the following error occurs.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation
## Detail 0 ##

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. HR Professional v4.0
2. Mass Change Main Appraiser
3. Search page opens
4. Enter Period Start & End Date, Appraisal template, and Supervisor name
5. Click the "Go" button
6. Framework Tech Stack error is displayed


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