My Oracle Support Banner

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

Last updated on MARCH 15, 2022

Applies to:

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


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


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


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

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