My Oracle Support Banner

Importing Maintenance Asset Template Ends in Error: "ORA-01722: invalid number" (Doc ID 2445726.1)

Last updated on SEPTEMBER 23, 2018

Applies to:

Oracle Maintenance Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

Importing Maintenance Asset template ends in the following error:

Record 1: Rejected - Error on table FUSION.CSE_ASSETS_INT, column QUANTITY.
ORA-01722: invalid number

Step to Reproduce the Issue

1.Prepare the Maintenance Asset data into the FBDI Template

2.Generate the CSV file

3. Submit the "Load Interface File for Import" Ess Job with below parameters

    A : Import Process : Import Assets

    B : Data File : Choose your previously created csv Zip file

4. Wait for the program to finish. If there is any error , Please check the Log file.

Changes

 

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
Changes
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.