My Oracle Support Banner

Catalog Bulk Load - Items Upload (POXCDXBL) Completes With Error: system failure message is java.sql.SQLException: Invalid Batch Value (Doc ID 1465672.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle iProcurement - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On Applications 12.1.2
When attempting to upload the catalog , the following error occurs.

-- Error
icx.icatalog.loader.CatalogLoaderJob 1 "system failure message is java.sql.SQLException: Invalid Batch Value
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

 -- Steps
The issue can be reproduced at will with the following steps.


1.   Set the profile : "POR: Bulk Loader Commit Size" = 5

2.  Via iprocurement catalog admin or Buyer Work Center (BWC) via upload, upload a catalog file with 5 items for the GBPA
- see the error

Due to this issue, users cannot upload the files correctly.

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.