EBS导出功能一闪而过的问题

环境：AIX6.1 EBS R12.1.1

问题：服务器测试环境没有问题，正式环境突然遇到一闪而过不能导出，导入也不能正常使用。

解决流程：

1. Make sure your browser will have setup completed for these 2 categories:

• ActiveX controls
• Downloads

You should follow these Steps:

• Go to IE Tools menu - Internet Options - Security - Custom Level
• Adjust all the settings for ActiveX Controls and Downloads to be either 'enable' or prompt for zones Internet, Local Intranet, and Trusted Zones
• Restart the browser and now test if the export process works

2. Make sure if users desktop are using a proxy server to access the web via MSIE. If you set "Bypass proxy server for local addresses" in Internet Options -> Connection -> LAN Settings check if the File > Export works without error.

3. Make sure you have set System Profile Options 'Export: Mime type' to 'text/tab-separated-values' or or 'application/vnd.ms-excel'

4.Delete Browser Cache > Tools > Internet Options > zone=temporary internet files : delete files {checked offline content}

5. You should also delete C:program files/oracle/jinitiator<version>/jcache/*

测试PLSQL：

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;

运行如上PLSQL代码，发现表空间报错。

扩展表空间正常，至此解决完毕。