My Oracle Support Banner

Searching For Work Order Produces Error ORA-01722 Invalid Number (Doc ID 2044159.1)

Last updated on MAY 06, 2019

Applies to:

Oracle Enterprise Asset Management - Version 12.0.0 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

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!


In this Document
Symptoms
Cause
Solution
References


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