1 2 Previous Next 18 Replies Latest reply: Jan 30, 2013 4:05 AM by jagadeesha RSS

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

    jagadeesha
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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