Home » Applications » Oracle Fusion Apps & E-Business Suite » Discoverer Report is running for long time
Discoverer Report is running for long time [message #390990] Tue, 10 March 2009 11:07 Go to next message
sreenu80
Messages: 50
Registered: July 2006
Location: bangalore
Member

Hi Friends,

i am running one discovere report it is running long time(more than 5 hrs)

The sql statement is behind the report is very simple it is picking data from one view "hrfg_position_hierarchies"

please help on providing some tunnings tips to resolve the issue.

Thnaks
sreenu

[Updated on: Tue, 10 March 2009 11:52]

Report message to a moderator

Re: Discoverer Report is running for long time [message #391040 is a reply to message #390990] Tue, 10 March 2009 14:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe the view is badly written?
Re: Discoverer Report is running for long time [message #391174 is a reply to message #390990] Wed, 11 March 2009 06:05 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Check the conditions used in view table
Re: Discoverer Report is running for long time [message #391668 is a reply to message #390990] Thu, 12 March 2009 22:53 Go to previous messageGo to next message
sreenu80
Messages: 50
Registered: July 2006
Location: bangalore
Member

The underline view is Seeded view.

Please provide is there any document avalable for this.
Re: Discoverer Report is running for long time [message #391684 is a reply to message #391668] Fri, 13 March 2009 01:02 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is a "seeded" view?
Re: Discoverer Report is running for long time [message #392135 is a reply to message #391684] Mon, 16 March 2009 09:57 Go to previous message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

it is discoverer default view table (not customized)
Previous Topic: error while install EPS
Next Topic: Calendar with multiple selection of dates
Goto Forum:
  


Current Time: Fri Dec 09 21:19:16 CST 2016

Total time taken to generate the page: 0.11043 seconds