Archive Daily Archives: February 17, 2010

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); […]

Read More
Not found