Searching For Work Order Produces Error ORA-01722 Invalid Number
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.
When attempting to query an existing work order the following error occurs.
ORA-01722 Invalid Number... FRM-40505: ORACLE error : unable to perform query.
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
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