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.

About the Author Muhammad Rawish Siddiqui

Master in Computer Science and Post-Graduation in MIS. EDRP (EC-Council Disaster Recovery Professional), Security+, OCP 7.3, 10, 11g, 12c, 11i, R12, OCE 11i System Administration, Linux and RAC 10g, 11g, and OCS in Performance Tuning. More than 18 years’ Information Technology consecutive hands-on experience, possess diversified business and technical background on a wide variety platforms, hardware and operating systems, in the Capacity of Sr. Team Lead Consultant, Sr. Database Administrator, Sr. Applications DBA, Sr. Resident Consultant and Manager Systems. Extensive experience in managing ERP environments and large Databases including Space Management, Backup and Recover, Performance Tuning, Routine Tasks Automation and Database/Applications Health Checks. Started Oracle related Career from Oracle 6. Worked on 7, 8, 9i, 10g, 11g, 12c & e-Business 11.0.3, 11.5.9, 11.5.10.2, R12 and R12.2. Distinct Technical Jobs such as installation, migration, implementation, upgrade, cloning, and maintenance were performed hundreds number of times. Database and Applications (Security & Performance) related Health Checks, RAC & Data Guard Implementation/Troubleshooting Switchover/Failover were also made during the tenure on the basis of As-When-Needed. Contact Me for Database/Applications Installation, Upgrade, Migration, Disaster Recovery, Troubleshooting and Health Checks.

Leave a Comment:

1 comments
oracle excel says December 16, 2011

You can use ORA_EXCEL (http://www.oraexcel.com) package to export data from Oracle database to Excel file.

Reply
Add Your Reply

Not found