OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » cannot convert oracle apps report output file into excel file

Home » Applications » Oracle Fusion Apps & E-Business Suite » cannot convert oracle apps report output file into excel file

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

cannot convert oracle apps report output file into excel file [message #380507]

Mon, 12 January 2009 02:26

radhavijaym
Messages: 65
Registered: December 2008
Location: singapore

Member

Hi,
My user trying to convert report output file into excel file but getting error

"File not loaded completely" error.

Report message to a moderator

Re: cannot convert oracle apps report output file into excel file [message #380508 is a reply to message #380507]

Mon, 12 January 2009 02:47

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How large is this report? Excel has limit regarding number of rows per sheet (64K), so - perhaps it can not fit.

Report message to a moderator

Re: cannot convert oracle apps report output file into excel file [message #380529 is a reply to message #380508]

Mon, 12 January 2009 03:37

radhavijaym
Messages: 65
Registered: December 2008
Location: singapore

Member

ya file is very large.
when trying to open in excel file im getting error "file not loaded completely" so what to do now to solve this issue.
i saved the output file of report as text file.
text file size is 12.2MB.

my microsoft excel version is 2002.

so what to do to solve this issue.

[Updated on: Mon, 12 January 2009 03:39]

Report message to a moderator

Re: cannot convert oracle apps report output file into excel file [message #380551 is a reply to message #380529]

Mon, 12 January 2009 05:28

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Split the file into chunks of 64K rows is one way. Another is to Google for "how to load a very large file into a MS Excel spreadsheet". Whichever option you choose, you'll have to have more than one sheet in a book.

Report message to a moderator

Previous Topic:	Import Standard PO
Next Topic:	Last Payroll Run for employee

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 26 08:39:55 CDT 2024