Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

‘File ->Export’ Function is troubling

Posted on November 13th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Hard Time this week for me ,struggling with Finance user from another entity to see unexpected things reported , Out of the box File -> export function was not working properly, some of them reported Browser crashing some of them reported data not exported 100% from form, some of them reported longer duration to export for nearly 500 records from Invoice Inquiry or Invoice Entry form.

There are few cases which user can experience

  • File - Export does not bring up a Save As prompt
  • File -Export may leads to Browser crashes
  • File - Export takes long time to export into Excel
  • File - Export not exporting 100% data from form
  • File - Export creates zero byte file
  • File -Export on selecting "Continue to End" causes system to hang

More less, these problems are encountered by some additional setup requirement in IE . Here are few troubleshooting points, if you are using IE 6 or 7.

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/*

6. Make sure you disable Pop-up Blocker

7. If you have still an issue , try this based out of note :338545.1

  • Make sure you have checked step 1,2,3.
  • Login to AP responsibility and try exporting from the data from Invoice workbench after search for invoice batch.
    Are you able to export?
  • If not ,Go to (Tool Bar) Help -> Diagnostics -> Examine
    Set Block = ENVIRONMENT
    Set Field = FND_EXPORT_DEBUG
    Set Value = TRUE
  • Export and observe the messages that are generated during the export process.
    What is the last pop up message ?
  • Try to run the following piece of code in SQLPLUS*

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
fnd_global.apps_initialize(user_id => <put your user id>,resp_id => <put your resp id>,resp_appl_id => <put your appl id>);
DBMS_SESSION.SET_NLS('NLS_LANGUAGE','AMERICAN');
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 still not able to fix, ask Oracle for further resolution.

8.If you are not able to 100% export in excel do a quick check

Run this query immediatly after Export get completed
select count(*) from fnd_lobs where program_name='export';

If counts not matches then you need to recreate the index using script $FND_TOP/sql/aflobbld.sql. This is because the File/Export functionality of EBS uses system LOB columns to store temp data before it is outputed to a browser. If that temp data becomes large enough as the result of large export query set, then the max_extents limitation of the column is reached thereby causing the export to fail.

Most of my user experinces these issues with WIN2K or XP SP1 and SP2, but not with SP3.No clue for me with service pack.

Is there any linkage with window XP or 2000 .Net Framework installation and Service pack in client desktop for this feature? Do share some thoughts if anyone got such kind of issue in past.

Related Posts

Posted in AOL | 4 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. Martand Joshi Says:

    You can press “CTRL” button and then press Export. Many of the problems can be solved by this.

  2. jimmy Says:

    you can try to add the erp site to the believable site to your browser.

  3. sanjitanand Says:

    Hey Jimmy,

    i didnot get you, what you says.
    could you elaborate please

    sanjit

  4. Destini Mauk Says:

    Thanks for the blog post.Really thank you! Really Great.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.