OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Discoverer Report is running for long time

Home » Applications » Oracle Fusion Apps & E-Business Suite » Discoverer Report is running for long time

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

Discoverer Report is running for long time [message #390990]

Tue, 10 March 2009 11:07

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

Littlefoot
Messages: 21823
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

B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad

Senior Member

sharanand@gmail.com

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

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

Littlefoot
Messages: 21823
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

B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad

Senior Member

sharanand@gmail.com

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 22:23:25 CDT 2025