My Oracle Support Banner

Import From Excel Upload Is Throwing Error When Trying To Upload Structures (Doc ID 2692336.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Product Hub - Version 12.2.4 and later
Information in this document applies to any platform.


Oracle Product Hub - Version 12.2.4 and later

Uploading a BOM structure by doing an excel import throws the following error in Structure Bulkload program.

Error Message
at oracle.apps.fnd.cp.request.Run.main(
## Detail 0 ##
java.sql.SQLException: Overflow Exception
at oracle.sql.NUMBER.toInt(
at oracle.sql.NUMBER.intValue(
at oracle.jbo.domain.Number.intValue(

Steps to Reproduce
The issue can be reproduced with the following steps:
1. Development Manager > Batch Import > Import Items > Import from Excel
2. Enter the Object, Structure Type, Structure Name and Import Format
3. Click Import
4. Create a new excel record with the BOM structure details for one row.
5. Click oracle > Upload on the excel menu
6. Enter the Batch name
7. Choose the Import option as"Immediately on Data Load"
8. Click Upload
9. Structure Bulload program completes in Warning.
    Log file shows the above error.



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.