Last updated on SEPTEMBER 12, 2016
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.
The issue can be reproduced at will with the following 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms