Skip to Main Content

General Cloud Infrastructure

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-12899: value too large for column ??? (actual: 53, maximum: 10) while supplier attachments through FBDI upload

Sadanand GundaDec 20 2024

While trying to upload supplier attachments using FBDI upload for more than 50 rows at a time, we are facing below error.
ORA-12899: value too large for column ??? (actual: 53, maximum: 10). If we try to upload with a smaller batch (less than 50 rows) same data is getting uploaded. We have to load 5000+ records and uploading in smaller batches is taking time. Need your help to resolve this issue.

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Dec 20 2024
0 comments
78 views