This discussion is archived
5 Replies Latest reply: Aug 13, 2013 1:22 AM by salviabu RSS

Output report XML very slow

user12193364 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated

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

Legend

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