Cannot Push Visit To Production Getting ORA-01722: invalid number error (Doc ID 433201.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 05-Sep-2012***
***Checked for relevance on 15-Sep-2014***
***Checked for relevance on 04-Apr-2016***

Symptoms

Responsibility : Complex MRO Super User

Navigation: Planning --> Visit Work Package --> Create Visit (or select existing Visit in a "Planning" status) --> eg: Visit 3 created --> Click Validate.

While pushing a visit to production results following error messages.

The following error occurred:
The entity with header id (0) generated the following error(s).
The Work Order 3 - TEST1 received an error status since an unexpected error occured in
the work order while performing attribute validations.
The entity with header id (1) generated the following error(s).
The Work Order 53 received an error status since an unexpected error occured in the
work order while performing attribute validations.
The entity with header id (2) generated the following error(s).
The Work Order 54 received an error status since an unexpected error occured in the
work order while performing attribute validations.

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