OraFAQ Forum: Reports & Discoverer » Report taking Long time in discoverer desktop

Home » Developer & Programmer » Reports & Discoverer » Report taking Long time in discoverer desktop (Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report taking Long time in discoverer desktop [message #323067]

Tue, 27 May 2008 04:15

lakshminarayana.j
Messages: 9
Registered: May 2008
Location: Pune

Junior Member

Hi ,

I am facing critical problem in Discoverer report.

I have one report with GL and AP details.

In discoverer admin edition i have made the proper joins between folder items gl_je_headers,gl_je_lines,gl_code_combinations,gl_je_batches ap_invoice_distributions and ap_invoices_all.

Joins are like

jl.je_header_id = jh.je_header_id and
jh.je_batch_id = jb.je_batch_id and
jl.code_combination_id = cc.code_combination_id
and aid.dist_code_combination_id =gcc.code_combination_id.
and aia.invoice_di=aid.invoice_id

In desktop edition when i am trying to run the report it's taking more than 2 hours.(I am taking sum(jl.accounted_dr),sum(jl.accounted_cr),invoice_num,invoice_date).

Suggest me.

Note: these joins are made between the various folder items in Admin.There was no query as single folder.

Report message to a moderator

Re: Report taking Long time in discoverer desktop [message #323086 is a reply to message #323067]

Tue, 27 May 2008 04:45

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

How long does it take if you execute the query in SQL*Plus? (you can copy the SQL statement from Discoverer Desktop).
If that's two hours too, then you have a general performance issue to solve, if not, then it's Discoverer.

Report message to a moderator