Cannot Export to Excel the Complete List Of Projects Using the Projects Advanced Search Export Option
Last updated on JUNE 29, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms