My Oracle Support Banner

Catalog Agreement Lines Upload Fails - Unexpected Database Error Invalid Number ORA-01722 (Doc ID 1069952.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle iProcurement - Version 12 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

In Oracle iProcurement on Release 12.0 or 12.1.1,  when attempting to load catalog, the following error occurs.

Error

oracle.core.ojdl.LoggingException: oracle.core.ojdl.LoggingException:
Attempt to write to a closed LogWriter
...
...
icx.icatalog.loader.sql.JDBCDataLoader bindLinesInterfaceStmt.end
icx.icatalog.loader.sql.JDBCDataLoader "Caught SQLException in
processItemBatch(): java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
...
...
icx.icatalog.loader.CatalogDataTXTUploader handleLoaderException.begin
icx.icatalog.loader.CatalogDataTXTUploader LoaderException is
oracle.apps.icx.icatalog.loader.LoaderException
icx.icatalog.loader.CatalogLoaderJob failJob.begin
icx.icatalog.loader.CatalogLoaderJob failure message is ICX_CAT_DATABASE_ERR
icx.icatalog.loader.CatalogLoaderJob "Throwable is
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
...
...



What is working

Users can manually enter the catalog item to the agreement.

Steps to Reproduce

1. Log in and select Purchasing Super User
2. Navigate: Agreements > Update Add Lines via Upload.
3. Select Text file to upload.
4. One line in Uploaded text file , created from downloaded resources.

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.