Oracle eBusiness Export Function Stopped Working (11i export report to Excel)

Everything was okayed before and now the aforesaid issue occurs.

• Login to SQL*Plus as apps user and run the following:
  set serveroutput on
  declare
  db_file NUMBER;
  mime_type VARCHAR2(255) := ‘text/plain’;
  out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’;
  web_server_prefix VARCHAR2(500);
  url VARCHAR2(500);
  begin
  db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’);
  fnd_gfm.file_write_line(db_file, out_string);
  db_file := fnd_gfm.file_close(db_file);
  url := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent, db_file, TRUE);
  dbms_output.put_line(url);
  end;
  /
• If it shows, errors like
  declare
  *
  ERROR at line 1:
  ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
  ORA-01653: unable to extend table CTXSYS.DR$WAITING by 5394 in tablespace CTXD
  ORA-06512: at “APPS.FND_GFM”, line 537
  ORA-06512: at line 8
• Then run the following command:
  SQL> select file_name from dba_data_files where TABLESPACE_NAME=’CTXD’;
  FILE_NAME
  ——————————————————————————–
  /oracle/oraprod/proddata/ctxd01.dbf
  /oracle/oraprod/proddata/ctxd02.dbf
  alter tablespace ctxd add datafile ‘/oracle/oraprod/proddata/ctxd03.dbf’ size 1024m;
• And prior to Applications reconfirm the issue by rerunning i.e.
  set serveroutput on
  declare
  db_file NUMBER;
  mime_type VARCHAR2(255) := ‘text/plain’;
  out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’;
  web_server_prefix VARCHAR2(500);
  url VARCHAR2(500);
  begin
  db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’);
  fnd_gfm.file_write_line(db_file, out_string);
  db_file := fnd_gfm.file_close(db_file);
  url := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent, db_file, TRUE);
  dbms_output.put_line(url);
  end;
  /
• Error is not supposed to be there.