Mass Change Main Appraiser Search Page In Error On Go Button After Upgrade To 12.2.6 From 12.1.3, Error ORA-00936: missing expression

(Doc ID 2380252.1)

Last updated on MARCH 29, 2018

Applies to:

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


On : 12.2.6 version, Appraisals

When trying to perform a Mass Change Main Appraiser Search page ends in Error on Go Button after upgrade to 12.2.6 from 12.1.3.

Attached is supporting document.

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

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

1. HR Professional V4.0-> Mass Change Main Appraiser.
2. Mandatory parameters added and Go.
3. Page Errors with missing expression.

The issue has the following business impact:
Due to this issue, users cannot complete appraisal during UAT.




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