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.

Symptoms

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

ERROR

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

...

oracle.apps.ben.selfservice.cwb.worksheet.server.AllocationsVOImpl.executeQuery(AllocationsVOImpl.java:52) at
oracle.apps.ben.selfservice.cwb.worksheet.server.AllocationsPlanVOImpl.executeQuery(AllocationsPlanVOImpl.java:84) at
oracle.apps.ben.selfservice.cwb.worksheet.server.AllocationsAMImpl.initializeObjects(AllocationsAMImpl.java:240)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)

STEPS

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.

Changes

Customer is using:

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

Cause

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.