This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 30, 2013 2:05 AM by jagadeesha RSS

File-> Export not working after upgrade from 11i to R12

jagadeesha Newbie
Currently Being Moderated
Hi,

File -> Export not working after upgrade from 11i to R12.1.3 in few systems. Can you please let me know what could be the issue.

If export record count more than 200 it is working fine in all the systems and if change the profile option "Export MIME type” value to ‘text/tab-separated-values’ from application/excel also it is wokring.

Thanks and Regards,
Jagadeesha
  • 1. Re: File-> Export not working after upgrade from 11i to R12
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post exact error code and message. Are there any error messages in the database alert log file ? Pl review the troubleshooting steps in these MOS Docs

    Information You Should Upload When Creating an SR for File Export and Attachments [ID 427964.1]
    Troubleshooting Export and Attachment issues in Oracle Applications 11i [ID 338651.1]

    HTH
    Srini
  • 2. Re: File-> Export not working after upgrade from 11i to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    968890 wrote:
    Hi,

    File -> Export not working after upgrade from 11i to R12.1.3 in few systems. Can you please let me know what could be the issue.

    If export record count more than 200 it is working fine in all the systems and if change the profile option "Export MIME type” value to ‘text/tab-separated-values’ from application/excel also it is wokring.

    Thanks and Regards,
    Jagadeesha
    What is the error you get?

    Can you find any errors in the application.log file?

    Please see these docs and make sure you have all the patches applied.

    R12: Export TXT Mime Type Cannot be Mapped For Excel [ID 1291324.1]
    Oracle Applcations Forms File Export Not Working fndgfm.jsp error : Java Exception [ID 1384669.1]
    How To Export Form Data To a CSV Format File [ID 779079.1]

    Thanks,
    Hussein
  • 3. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Hi Srini,

    Thanks for your response and feed back of my post.

    Not getting any error message just it is hanging and no luck in both the updated notes.

    Cheers,
    Jagadeesha
  • 4. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Hi Hussein,

    Thanks for your response and feed back of my post.

    Nothing in the application log and this issue only few desktops or systems and this happing only in production so can't apply in lower enviornment and test the issue.

    Cheers,
    Jagadeesha
  • 5. Re: File-> Export not working after upgrade from 11i to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    What about the log files? Have you reviewed all database/application log file?
    Nothing in the application log and this issue only few desktops or systems and this happing only in production so can't apply in lower enviornment and test the issue.
    What is the difference between prod and other instances?

    Please apply those patches in the lower environments before applying it in production and see if you can reproduce the issue in production.

    Thanks,
    Hussein
  • 6. Re: File-> Export not working after upgrade from 11i to R12
    EBSDBA Expert
    Currently Being Moderated
    Hi Jagadeesha,
    Nothing in the application log and this issue only few desktops or systems and this happing only in production so can't apply in lower enviornment and test the issue.
    If this error is only for few machines, then make sure

    That the download option in Brower settings is set to enabled.

    Navigate to

    For IE:

    Tools -> Internet Options -> Security -> (Select the zone in which you e business suite is added, like trusted sites for ex) -> Then click on custom level -> Scroll down till you see downloads and enable all the three options.


    Thanks
  • 7. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Hi ,

    Thanks for your update. Alreday download options is enabled for all three and added e business suite url in trusted sites. Still same issue.


    Regards,
    Jagadeesha
  • 8. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Hi Hussein,

    No changes as per my undersandting Production and Non-production instance. This issue is there only few desktops and not all the desktops and one more obersvation is if more than 200 records it is working in all the desktops.

    Regards,
    Jagadeesha
  • 9. Re: File-> Export not working after upgrade from 11i to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    968890 wrote:
    Hi Hussein,

    No changes as per my undersandting Production and Non-production instance. This issue is there only few desktops and not all the desktops and one more obersvation is if more than 200 records it is working in all the desktops.

    Regards,
    Jagadeesha
    What is the difference between those desktops and other ones? Are they running on the same OS and use the same Office (Excel) version?

    Is the issue related to desktops or to usernames? Please verify.

    Thanks,
    Hussein
  • 10. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Both are having the same OS and same excel version.

    Yes it is related to Desktop.

    Regards,
    Jagadeesha
  • 11. Re: File-> Export not working after upgrade from 11i to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    968890 wrote:
    Both are having the same OS and same excel version.

    Yes it is related to Desktop.
    Then, there should be something different between them.

    Have you tried to obtain FRD log file and see if any details are collected in the log?

    Thanks,
    Hussein
  • 12. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Can you please let me know how to collect the FRD log.


    Regards,
    Jagadeesha
  • 13. Re: File-> Export not working after upgrade from 11i to R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    968890 wrote:
    Can you please let me know how to collect the FRD log.


    Regards,
    Jagadeesha
    Please see these docs.

    R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications [ID 438652.1]
    Steps To Take FRD Trace in 11.5.10 & R12 [ID 867943.1]
    How To Collect And Use Forms Trace (FRD) in Oracle Applications Release 12 [ID 373548.1]

    Thanks,
    Hussein
  • 14. Re: File-> Export not working after upgrade from 11i to R12
    jagadeesha Newbie
    Currently Being Moderated
    Enabled the FRD. Below are few last lines. Can you please let me know what i can in this log file contents.

    In Argument 1 - Type: String Value: global.frd_debug

    Executing GET_ITEM_PROPERTY/FIELD_CHARACTERISTIC Built-in:
    In Argument 0 - Type: Integer Value: 196613
    In Argument 1 - Type: Number Value: 54
    Out Argument 0 - Type: String Value: 12

    Executing COPY Built-in:
    In Argument 0 - Type: String Value: Entering app_menu.set_prop.
    In Argument 1 - Type: String Value: global.frd_debug

    Executing FIND_MENU_ITEM Built-in:
    In Argument 0 - Type: String Value: FILE.EXPORT
    Out Argument 0 - Type: Integer Value: 19

    Executing GET_MENU_ITEM_PROPERTY Built-in:
    In Argument 0 - Type: Integer Value: 19
    In Argument 1 - Type: Number Value: 79
    Out Argument 0 - Type: String Value: TRUE

    Executing COPY Built-in:
    In Argument 0 - Type: String Value: Completed app_menu.set_prop.
    In Argument 1 - Type: String Value: global.frd_debug

    Executing COPY Built-in:
    In Argument 0 - Type: String Value: Completed app_synch.menu_toolbar_sync. Event is WHEN-NEW-ITEM-INSTANCE.
    In Argument 1 - Type: String Value: global.frd_debug

    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: GLOBAL.APP_CUSTOM_MODE
    Out Argument 0 - Type: String Value: NORMAL

    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: GLOBAL.APP_CUSTOM_MODE
    Out Argument 0 - Type: String Value: NORMAL

    Executing COPY Built-in:
    In Argument 0 - Type: String Value: NULL
    In Argument 1 - Type: String Value: GLOBAL.OUT

    Executing USER_EXIT Built-in:
    In Argument 0 - Type: String Value: FND GETPROFILE NAME="UPK_RECORDING_ENABLED" FIELD="GLOBAL.OUT" N
    FNDCPVCM, 11, Built-In, Entry, 316509814, USER_EXIT

    FNDCPVCM, 11, Built-In, Exit, 316509814, USER_EXIT


    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: GLOBAL.OUT
    Out Argument 0 - Type: String Value: N

    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: system.current_form
    Out Argument 0 - Type: String Value: FNDCPVCM

    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: system.current_block
    Out Argument 0 - Type: String Value: MASTER

    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: system.current_form
    Out Argument 0 - Type: String Value: FNDCPVCM

    Executing NAME_IN Built-in:
    In Argument 0 - Type: String Value: system.current_block
    Out Argument 0 - Type: String Value: MASTER

    Executing GET_APPLICATION_PROPERTY Built-in:
    In Argument 0 - Type: Number Value: 75
    Out Argument 0 - Type: String Value: IHR40P

    Executing COPY Built-in:
    In Argument 0 - Type: String Value: Completed call_all_libraries. Event is WHEN-NEW-ITEM-INSTANCE.
    In Argument 1 - Type: String Value: global.frd_debug

    Executing COPY Built-in:
    In Argument 0 - Type: String Value: Completed app_standard.event. Event is WHEN-NEW-ITEM-INSTANCE.
    In Argument 1 - Type: String Value: global.frd_debug
    FNDCPVCM, 10, Prog Unit, Exit, 316509814, /FNDCPVCM-3/P45_30_DEC_201223_28_33

    FNDCPVCM, 9, Trigger, Exit, 316509814, WHEN-NEW-ITEM-INSTANCE

    FNDCPVCM, 8, Prog Unit, Exit, 316509814, /DMU-4/P8_30_DEC_201223_23_12


    # 15 - FNDCPVCM:MASTER.USER_CONCURRENT_QUEUE_NAME.1359399301498413820
    WINDOW FNDCPVCM PROGRESS_INDICATOR RESIZE 4198 1500 3

    # 16 - FNDCPVCM:MASTER.USER_CONCURRENT_QUEUE_NAME.1359399301512613925
    WINDOW FNDCPVCM PROGRESS_INDICATOR RESIZE 4198 1500 3
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points