Home » Applications » Oracle Fusion Apps & E-Business Suite » File ==> exports from Apps - maximum row limit?
File ==> exports from Apps - maximum row limit? [message #208159] Fri, 08 December 2006 06:57 Go to next message
alastair_wood
Messages: 21
Registered: September 2006
Location: UK
Junior Member
Does anyone know if there's a maximum row limit for exports done through Apps?

A user has run a project expenditure inquiry which gives returns about 5,000 rows. Selecting File ==> Export kicks off the export prompts (more than 100 records retrieved, continue to end etc.), no red bar appears, the screen hangs for about 5 minutes and then the Apps window just closes.

I can run the same query for just one month (the original query is for 6 months) and the export works but takes 5 mins to export 850 rows.

Is there a limit to rows or characters for exports, or is it likely to be DB problem (ie. lack of tablespace)?

Any info appreciated.
Re: File ==> exports from Apps - maximum row limit? [message #208184 is a reply to message #208159] Fri, 08 December 2006 08:47 Go to previous messageGo to next message
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
Hi, Alastair,

As far as I know, there is no specific limit within the software, but there is possibly a limit in the tablespace. Try looking at MetaLink Note:226077.1

Cool HTH

David
Re: File ==> exports from Apps - maximum row limit? [message #208622 is a reply to message #208159] Mon, 11 December 2006 09:48 Go to previous message
alastair_wood
Messages: 21
Registered: September 2006
Location: UK
Junior Member
Thanks David, much appreciated - I'll get the DBA to check it out.

Alastair

Previous Topic: Avoid entering user and password on Single Sign On
Next Topic: Oracle 11i ADI Report Wizard
Goto Forum:
  


Current Time: Thu Jun 27 13:21:30 CDT 2024