Adding Attachments Error With ORA-01653: Unable to Extend Table APPLSYS.FND_LOBS by 16 in Tablespace APPS_TS_MEDIA (Doc ID 2047864.1)

Last updated on JULY 26, 2017

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Oracle Purchasing - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Oracle Supplier Hub - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On  Release 12.1.3 version,

When attempting to add attachments to the Supplier and/or Purchasing documents the following error occurs.

ERROR
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException:
JBO-26041: Failed to post data to database during "Insert" SQL Statement "INSERT INTO
FND_LOBS(FILE_ID,FILE_NAME,FILE_CONTENT_TYPE,FILE_DATA,FILE_FORMAT)
VALUES (:1,:2,:3,:4,:5)".
.
## Detail 0 ##
java.sql.SQLException: ORA-01653: unable to extend table APPLSYS.FND_LOBS by 16 in tablespace APPS_TS_MEDIA
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)


STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Apply Attachments to Suppliers or Purchasing documents
2. Receive Error: JBO-26041: Failed to post data to database during "Insert"

   ## Detail 0 ##  Java.sql.SQLException: ORA-01653: unable to extend table APPLSYS.FND_LOBS by 16 in tablespace APPS_TS_MEDIA

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms