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