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

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.

Symptoms

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
ALL LINES:

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.

Changes

 Upgraded from 12.06 to 12.1.3 delta 6

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms