Searching For Work Order Produces Error ORA-01722 Invalid Number

(Doc ID 2044159.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to query an existing work order the following error occurs.

ERROR

ORA-01722 Invalid Number... FRM-40505: ORACLE error : unable to perform query.



STEPS

1. EAM: Work Orders-> Work Orders
2. Find org/Work Order = PUE / 139983
3. ORA 01722 Invalid Number
4. Press Details button
5. FRM-40505: ORACLE error : unable to perform query

Changes

 

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