Cannot Export Data from E-Business Suite to Excel (Doc ID 731921.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Application Object Library - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2012***

Symptoms

When trying to export data from sales order line entry screen to an excel file, the save option dialog window is not displayed and as a result you cannot export the application data.

After running the following block of pl/sql code:

SQL> set serveroutput on;
SQL> declare
2 db_file number;
3 mime_type varchar2(255) :='text/plain' ;
4 out_string varchar2(32767) :='Just some plain text that is stored' ;
5 web_server_prefix varchar2(500);
6 url varchar2(500);
7 begin
8 db_file :=fnd_gfm.file_create(content_type =>mime_type,program_name=>
9 'export');
10 fnd_gfm.file_write_line(db_file,out_string);
11 db_file :=fnd_gfm.file_close(db_file);
12 url:=fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,db_file,TRUE)
13 ;
14 dbms_output.put_line(url);
15 end;
16 /


We can see this error:

declare
*
ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-00604: error occurred at recursive SQL level 2
ORA-01653: unable to extend table CTXSYS.DR$WAITING by 210 in tablespace CTXD
ORA-06512: at "APPS.FND_GFM", line 730
ORA-06512: at "APPS.FND_GFM", line 754
ORA-06512: at line 10

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