My Oracle Support Banner

Cannot Export to Excel the Complete List Of Projects Using the Projects Advanced Search Export Option (Doc ID 1940040.1)

Last updated on OCTOBER 05, 2020

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.


When number of rows returned by the Advance Project Search page is greater then the value given in the profile option FND: View Object Max Fetch Size and the value is exported to excel, only the rows up to the value in the profile option are exported. For example, when the FND: View Object Max Fetch Size is set to 2000 and the Advance Project Search returns 175 rows, 175 rows are exported. But if the FND: View Object Max Fetch Size is set to 150, the Advanced Search now only returns 151 rows and when exporting, only 151 rows are exported versus the 175 that were returned in 12.06.

Several other applications are reporting something similar.  From Bug 12615329 : ON DEMAND -BWC ORDERS/AGREEMENTS - EXPORT BUTTON DOES NOT EXPORT

Export All property of Export Button is set to False.  This causes the no of rows to be limited by the profile option FND: View Object Max Fetch Size.


 Upgraded from 12.06 to 12.1.3 delta 6


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.