My Oracle Support Banner

Upload a document with more than 2mb size in document maintenance screen. Failed to post data to database during "insert": SQL Statement "JBO-29000: Unexpected exception caught :java.sql:SQLException,msg=ORA Invalid Operation" (Doc ID 2752730.1)

Last updated on FEBRUARY 16, 2021

Applies to:

Oracle Financial Services Lending and Leasing - Version 14.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Upload a document with more than 2mb size in document maintenance screen. System fails with error. System does not throw error when the file size is 1650kb.
  
ERROR
-----------------------
Failed to post data to database during "insert": SQL Statement "JBO-29000: Unexpected exception caught :java.sql:SQLException,msg=ORA Invalid Operation".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to document maintenance and upload a document which has file size greater than 2mb

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload document having file size greater than 2mb,.Impacts loan processing

Changes

 

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
Changes
Cause
Solution


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