Problem: Data not generated in file means rows not to be exported when hitting “File -> Export”. The windows’ informing exporting data comes up and end without any error message or exporting.

Solution:

The above errors verify issues with index on FND_LOBS table. The cause is either lack of space in tablespace behind FND_LOBS indexes or corrupt index. This can be fixed by:

Step 1 Identify the tablespace behind this index to verify sufficient space to tablespace .

SQL> select INDEX_NAME, TABLESPACE_NAME from DBA_INDEXES where TABLE_NAME='FND_LOBS';

Step 2 if no sufficient space, just adds more files to the index tablespace.

Step 3 Rebuild the indexes by executing $FND_TOP/sql/aflobbld.sql (version should be 115.22 or higher) as APPS user.

This script takes two Argument:

1) The name of the APPLSYS schema (ie: APPLSYS)
2) The name of the APPS schema (ie: APPS)

Reference

Metalink Note: 272526.1: 'Export' Function Has Stopped Working In All Modules
Metalink Note: 338651.1: Troubleshooting Export and Attachment issues in Oracle
Metalink Note: 338651.1: Troubleshooting Export and Attachment issues in Oracle
Metalink Note: 71639.1: EOERR: ORA-29861 domain index is marked LOADING/FAILED/UNUSABLE