Export File Not Working

6991426.992 SR Number Support Identifier 3696728 3 Severity Oracle Application Object Product Library AIX5L Based Systems (64-bit) Platform n/a SR Reference

Open Date Name Last Update Product Version

Detailed Status Hard Close BUG Reference n/a

Abstract FILE->EXPORT IS NOT CREATING THE EXCEL EXPORT FILE

Resolution History 10-JUN-08 08:02:13 GMT

Severity Conditions

Yes Business Risk Other (please describe below): Explain Other FILE->EXPORT is not creating the Excel export file. While doing FILE -> EXPORT, it shows exporting to excel but it terminates without prompting to open/save the excel file it doesnot even create any excel file. ### Detailed Problem Statement ### FILE->EXPORT is not creating the Excel export file. While doing FILE -> EXPORT, it shows exporting to excel but it terminates without prompting to open/save the excel file it doesnot even create any excel file. ### Steps to Reproduce ### FILE->EXPORT ### Instance Name and Type of System ###

10-JUN-08 08:02:13 ERPBA LG 17-JUN-08 09:18:04 11.5.10

ILTES,test ### Recent Changes ### No ### Workaround ### Not available ### Impact on Business ### users are unable to export the data in excel. ### What version of application installing? ### 11.5.10 ### What version of Oracle database installing? ### 9.2.0.x ### What rapidwiz version? ### No idea ### Staged installation being used? ### No ### What type of system configuration? ### FILE->EXPORT is not creating the Excel export file. While doing FILE -> EXPORT, it shows exporting to excel but it terminates without prompting to open/save the excel file it doesnot even create any excel file. ### Documentation referenced? ### FILE->EXPORT is not creating the Excel export file. While doing FILE -> EXPORT, it shows exporting to excel but it terminates without prompting to open/save the excel file it doesnot even create any excel file. ### Customer work hours and timezone ### IST ### milestones and deadlines ### ### Files to be Loaded: Note183274.1 ### No Files Can you easily recover from, bypass or work around the problem? No

Does your system or application continue normally after the problem occurs? Yes Are the standard features of the system or application still available; is the loss of service minor? Yes

Contact me via : Telephone -> 09811354071

10-JUN-08 08:52:39 GMT UPDATE ====== Hi Erpba, Thank you for using MetaLink. We are currently reviewing/researching the situation and will update the Service Request (SR) or call you as soon as we have relevant information. Thank you for your patience. Best Regards, Kalaivani Global Customer Services STATUS ======= @WIP -- Work In Progress

10-JUN-08 08:52:54 GMT . UPDATE ======= Hi Erpba, 1. Is this issue is happening in all the forms of all the responsibility. 2. Was this working fine earlier. 3. Follow Note 338545.1 Ext/Mod How To Enable Debugging When Export Fails In Applications 11i: please upload the resulting Log file.

4. Run the following query in SQL*Plus and let me know result: 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;

Thanks, Kalaivani STATUS ======= @CUS -- Waiting for requested information

10-JUN-08 08:53:00 GMT Email Update button has been pressed: Sending email to [email protected]. 11-JUN-08 09:15:52 GMT . FOLLOW UP ========== Hi Erpba, Please update the SR as soon as possible with the current status and/or requested information so we can continue working the i ssue. Thank You, Kalaivani

STATUS ======= @CUS -- Waiting for Customer Update

11-JUN-08 09:15:57 GMT Email Update button has been pressed: Sending email to [email protected]. 11-JUN-08 11:28:06 GMT The customer : [email protected] : has uploaded the following file via MetaLink: export_debug_snapshot.doc

11-JUN-08 11:29:07 GMT The customer : [email protected] : has uploaded the following file via MetaLink: Doc2.doc

11-JUN-08 11:30:14 GMT New info : [email protected] Hi,

1. Is this issue is happening in all the forms of all the responsibility. YES 2. Was this working fine earlier. YES 3. Follow Note 338545.1 Ext/Mod How To Enable Debugging When Export Fails In Applications 11i: please upload the resulting Log file. UPLOADED 4. Screen shot uploaded

Regards ----------ERPDBA(LG)

11-JUN-08 11:57:32 GMT . UPDATE ======= Hi Erpba, I have reviewed the file uploaded,Please let me know the result of the following query: 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; /

Thanks, Kalaivani STATUS ======= @CUS -- Waiting for requested information

11-JUN-08 11:57:38 GMT

Email Update button has been pressed: Sending email to [email protected]. 12-JUN-08 09:41:12 GMT New info : [email protected] Hi , We have run the query given by you and we're getting the error mentioned below .. 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 dbms_output.put_line(url); 14 end; 15 / declare * ERROR at line 1: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE ORA-06512: at "APPS.FND_GFM", line 537 ORA-06512: at line 8

Regds LGDBA

13-JUN-08 02:55:56 GMT . UPDATE

======= Hi Erpba, Please perform the following: ACTION PLAN ============ 1. Run afupdlob.sql first, this will drop the index. 2. Then run aflobbld.sql to rebuild. 3. Retest the issue.

Thank you, Kalaivani Global Customer Services STATUS ======= @CUS -- Waiting for customer action plan results

13-JUN-08 02:56:13 GMT Email Update button has been pressed: Sending email to [email protected]. 14-JUN-08 05:26:03 GMT New info : [email protected] Hi , We're unable to find the required scripts name "afupdlob.sql" . We searched it in FND_TOP , But didn't found it . So , Ple ase send the script to us OR the location from where we can download it .. Regds LGDBA

14-JUN-08 12:02:01 GMT

New info : [email protected] Hi , Please update this TAR . As the user testing is suffering ... regds LGDBA

14-JUN-08 16:51:03 GMT New info : [email protected]

Please update this TAR . As the user testing is suffering ... Regards LG

15-JUN-08 10:05:23 GMT . UPDATE ======= Hi Erpba, since SR update after the end of myshift not able to update the SR. To implement the solution, please execute the following steps: You will be able to get the script under $FND_TOP/sql. sql> connect apps/apps sql> @$FND_TOP/sql/afupdlob.sql applsys apps sql> @$FND_TOP/sql/aflobbld.sql applsys apps

Thanks, Kalaivani STATUS =======

@CUS -- Waiting for requested information

15-JUN-08 10:05:29 GMT Email Update button has been pressed: Sending email to [email protected]. 16-JUN-08 09:32:18 GMT . FOLLOW UP ========== Hi Erpba, Please update the SR as soon as possible with the current status and/or requested information so we can continue working the i ssue. Thank You, Kalaivani STATUS ======= @CUS -- Waiting for Customer Update

16-JUN-08 09:32:25 GMT Email Update button has been pressed: Sending email to [email protected]. 16-JUN-08 10:08:09 GMT New info : [email protected] Dear, You will be able to get the script under $FND_TOP/sql.

sql> @$FND_TOP/sql/afupdlob.sql applsys apps sql> @$FND_TOP/sql/aflobbld.sql applsys apps

we are unable to find the afupdlob.sql under $FND_TOP/sql. kindly send the sql for us (e.g . refer us the loaction on metalik where this sql can be found. We will highly appreciate your effort. Regards, ERPDBA(LG)

16-JUN-08 10:11:48 GMT . UPDATE ======= Hi Erpba, Please run teh program "Rebuild Help Search Index" from system administrator resposibility , this inturns calls the sql script. and retest the issue. Thanks, Kalaivani STATUS ======= @CUS -- Waiting for requested information

16-JUN-08 10:11:54 GMT Email Update button has been pressed: Sending email to [email protected]. 17-JUN-08 07:18:12 GMT . FOLLOW UP ========== Hi Erpba,

Please update the SR as soon as possible with the current status and/or requested information so we can continue working the i ssue. Thank You, Kalaivani STATUS ======= @CUS -- Waiting for Customer Update

17-JUN-08 07:18:17 GMT Email Update button has been pressed: Sending email to [email protected]. 17-JUN-08 08:59:06 GMT New info : [email protected] Hi, The issue has been resolved after running the mentioned concurrent . Thanks a lot.

Regards, ----------ERPDBA(LG)

17-JUN-08 09:15:51 GMT . ISSUE CLARIFICATION ==================== Customer is not able to export from any forms of oracle applications. The export was working fine earlier. . ISSUE VERIFICATION

=================== Verified the issue by the screen shots in the file export_debug_snapshot.doc, which shows the step by step debug information whe n export happens. . CAUSE DETERMINATION ==================== Cause for the issue is Index got corrupted.

CAUSE JUSTIFICATION ==================== Cause for the issue has been been found from the debug sql.Which shows domain index has iss ue. . PROPOSED SOLUTION(S) ====================== 1. Run the below sql> connect apps/apps sql> @$FND_TOP/sql/afupdlob.sql applsys apps sql> @$FND_TOP/sql/aflobbld.sql applsys appsc OR 2. Please run teh program "Rebuild Help Search Index" from system administrator resposibility , this inturns calls the above sql scr ipt. 3. Retest the issue.

PROPOSED SOLUTION JUSTIFICATION(S) ==================================== The sql or the program provided will help to recreate the index. . SOLUTION / ACTION PLAN ======================= To implement the solution, please execute the following steps: 1. Please run the program "Rebuild Help Search Index" from system administrator resposibility , this inturns calls the

above sql script. 2. Retest the issue.

17-JUN-08 09:17:12 GMT . UPDATE ======= Hi Erpba, It was my pleasure working with you.I am hard closing this service request now after getting your confirmation.When the service req uest is closed, you will receive a customer survey notification. I request you to kindly spare few minutes to complete the survey for the closed service re quest.The survey responses means a lot to us. They are monitored and analyzed in ternally, So that we keep improving on our customer satisfaction levels. Kindly find some part of your valuable time and fill the survey. For any added concerns please drop in a mail to my manager Yadhu at yadhunath.srinivasamurthy@or acle.com Best Regards, Kalaivani Global Customer Services STATUS ======= Inactivated -- Issue Resolved

17-JUN-08 09:18:04 GMT Email Update button has been pressed: Sending email to [email protected].