5 Replies Latest reply: Aug 13, 2013 3:22 AM by salviabu RSS

    Output report XML very slow

    user12193364
      Hi,
      I designed the report output includes 40 columns and 100000 rows. However, the request and opens slow in XML format on the client very slow.

      Please ask you one optimal solution to the problem above?

      (Version R12)

      Thank alot!

      Edited by: user12193364 on 14:03 24-04-2013
        • 1. Re: Output report XML very slow
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.
          Hi,
          I designed the report output includes 40 columns and 100000 rows. However, the request and opens slow in XML format on the client very slow.

          Please ask you one optimal solution to the problem above?
          Are you running the report from the application?

          Is the issue with processing the request or just with opening the output file?

          What is the size of the concurrent request output file?

          R12: Troubleshooting Known XML Publisher and E-Business Suite (EBS) Integration Issues [ID 1410160.1]
          EBS - Technology Area - Webcast Recording 'BI Publisher / XML Publisher Overview & Best Practices - Webinar' [video] [ID 1513592.1]
          Poor Performance /High Buffer Gets In FND_CONC_TEMPLATES [ID 1085293.1]
          Performance Issue - PDF Generated With BI Publisher [ID 956902.1]
          Overview of Available Patches for Oracle XML Publisher embedded in the Oracle E-Business Suite [ID 1138602.1]
          Tuning Output Post Processor (OPP) to Improve Performance [ID 1399454.1]

          Thanks,
          Hussein
          • 2. Re: Output report XML very slow
            user12193364
            Hi Hussein,

            Thanks for your replies

            Are you running the report from the application? => EBS version 12

            Is the issue with processing the request or just with opening the output file? => opening the output file

            What is the size of the concurrent request output file? => *> 100MB*

            ...
            Thanks,
            Hussein

            Thanks & regards
            Suson.

            Edited by: user12193364 on 13:37 01-05-2013

            Edited by: user12193364 on 13:38 01-05-2013

            Edited by: user12193364 on 13:39 01-05-2013
            • 3. Hepl me: Sync error!!!
              user12193364
              Posted: 12:36 03-05-2013          
                   Edit                    Reply
              ORA-20002: 3122: Duplicate item 'OEOH/10017' could not be created. in Package OE_ORDER_WF_UTIL Procedure Create_HdrWorkItem

              User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineProcess

              User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure Start_HdrProcess???

              Pls, help me!
              • 4. Re: Hepl me: Sync error!!!
                Hussein Sawwan-Oracle
                user12193364 wrote:
                Posted: 12:36 03-05-2013          
                     Edit                    Reply
                ORA-20002: 3122: Duplicate item 'OEOH/10017' could not be created. in Package OE_ORDER_WF_UTIL Procedure Create_HdrWorkItem

                User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineProcess

                User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure Start_HdrProcess???

                Pls, help me!
                Please see if the solution in (When copying Quote with Expired Price List, Customer Acceptance fails ORA-20002: 3122 [ID 1485756.1]) helps.

                Thanks,
                Hussein
                • 5. Re: Output report XML very slow
                  salviabu

                  is der any solution to this problem of openeing the huge file?