"ORA-01722: invalid number" Exception When Using Migration Project Export With Equipment Group (Doc ID 1966686.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.3.4 to 6.3.7 [Release 6.3]
Information in this document applies to any platform.

Symptoms

Exception when using Migration Project Export with Equipment Group. When trying to export the migration project with 'EQUIPMENT_GROUP' object, OTM raised:


java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01722: invalid number

STEPS
-----------------------
This exception happen every time no matter what equipment is selected.

1. Create an 'Export' Migration project and assign an EQUIPMENT_GROUP to it
2. Navigate to Business Process Automation > Process Management > Migration Project Export.
3. Select the project created in step 1. Then click 'Submit' button.
4. View the log and see the exception:
ava.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01722: invalid number

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