My Oracle Support Banner

JAVA "Java.sql.SQLSyntaxErrorException: ORA-01722: Invalid Number" When Selecting the Award Merit Function in Compensation Workbench (CWB) (Doc ID 2395379.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Compensation Workbench - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.


While clicking on Award Merit function in Compensation Workbench, the below error occurs:


## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(


oracle.apps.ben.selfservice.cwb.worksheet.server.AllocationsVOImpl.executeQuery( at
oracle.apps.ben.selfservice.cwb.worksheet.server.AllocationsPlanVOImpl.executeQuery( at
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(


The issue can be reproduced at will with the following steps:
1. Open Compensation Workbench as Manager or Administrator.
2. Click on Award Merit function.


Customer is using:

Oracle Database 12c Enterprise Edition Release - 64bit Production
PL/SQL Release - Production


To view full details, 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 a vibrant support community of peers and Oracle experts.