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: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe the view is badly written?

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is a "seeded" view?

Report message to a moderator

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)

Report message to a moderator

Previous Topic: error while install EPS
Next Topic: Calendar with multiple selection of dates
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 09:09:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.