My Oracle Support Banner

Cannot Open Work Orders in Self Service due to Errors: JBO-27122 ORA-01722 (Doc ID 1245805.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Enterprise Asset Management - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance 11-Aug-2012***


When opening work orders in Self Service page, the following error occurs:

An exception has occurred. Please contact your system administrator.

Highlights from the java exceptions:

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

java.sql.SQLSyntaxErrorException: ORA-01722: invalid number


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.