ORA-01691

On Publishing Large Reports The Message ORA-01691: Unable To Extend LOB Segment

Applies to:

Oracle General Ledger - Version: 11.5.1 to 11.5.10.2 - Release: 11.5.1 to 11.5.10
Oracle Report Manager - Version: 11.5.0 to 11.5.10.2   [Release: 11.5 to 11.5]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 11.5.10
Program: RGRARG - Financial Statement Generator (FSG)

Symptoms

A Performance issue may be experienced with large Financial Statement Generator Reports (FSG) when submitted through Report Manager and log file shows the below message:

Publish and Presentation Program shows in set - , NVT name = PUBLISH_SET_ID, val = END PARAM
Param size? 31 Is In set? falsein set - , NVT name = PUBLISH_SET_ID, val = END PARAM
Failed to insert into database: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens:
MESSAGE = oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL
Statement "JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-01691: unable to
extend lob segment FRM.SYS_LOB0000345351C00004$$ by 5 in tablespace FRMD
".;

Issue is specific after applying the Patch 7350414 (Superceded)

Cause

This is caused by issues with the custom template used and the size of the report.

The error is caused by the amount of temporary disk space required by the publishing when trying to generate the report. This amount grows depending on the amount of data required in the report.

Solution

To implement the solution, please execute the following steps:

1. Increase the size of tablespace FRMD until the problem is resolved.

2. Size should be increased by large amounts of up to a gigabyte.

This error should be handled no differently from other errors indicating the
inability to extend a database segment. Initial confusion may occur given the
unique nature of LOB storage.