Why is it taking so long to get search results when exporting audit summary of Fusion Application Business Objects?

For Fusion Application Business Objects, by default, 10000 records per table can be exported to Excel from the audit report search. Sometimes, this can take time.

To restrict the number of records that can be exported to Excel, you can create the FND_AUDIT_EXPORT_ENTITY_LIMIT profile option and set a lesser value for it.

Create Profile Option

To create the profile option, follow these steps.

1. In the Setup and Maintenance work area, go to the Manage Profile Options task.
2. Click Actions > New.
3. On the Create Profile Option page, enter these details.
   • Enter Profile Option Code as FND_AUDIT_EXPORT_ENTITY_LIMIT.
   • Enter the required Profile Display Name.
   • From the Application list, select Oracle Middleware Extensions for Applications.
   • From the Module list, select Oracle Middleware Extensions for Applications.
   • Select the start and end dates.
4. Save your changes.
5. On the Manage Profile Options page, search for the newly created FND_AUDIT_EXPORT_ENTITY_LIMIT profile option.
6. From the results, select the FND_AUDIT_EXPORT_ENTITY_LIMIT profile option.
7. In the Profile Option Levels section, select Enabled and Updatable for the Site level.
8. Save your changes.

Set Value for the Profile Option

To set value for the profile option, follow these steps.

1. In the Setup and Maintenance work area, go to the Manage Administrator Profile Values task.
2. Search for and select the FND_AUDIT_EXPORT_ENTITY_LIMIT profile option.
3. In the Profile Values section, enter a value lesser than 10000 in the Profile Value column.
4. Click Save and Close. Your changes affect users the next time they sign in.