How many rows can be exported from the Manage Items page search results?
You can display a maximum limit of 500 rows of item search results on the Manage Items page, and you can export a default maximum limit of 500 rows by using the Export to Excel action.
To ensure that your export includes all of the items you want, perform your item search in a way that limits the search results to the export limit. A message in the exported spreadsheet tells you if the export limit was reached, and if some rows weren't exported.
If you want to export more than 500 rows, Oracle recommends defining a report based on the Source System Item subject area using Oracle Transactional Business Intelligence (OTBI).
You can improve the performance of the export by setting the limit on the number of item rows exported to the spreadsheet. You control the export limit by specifying the value of the profile option Item Export Row Limit (EGP_EXPORT_ITEM_ROWLIMIT) at site level. The default value is 500. Be aware that increasing the limit might adversely affect performance and timeouts, depending on your data. To modify the default, use the Manage Advanced Item Profile Options task in the Setup and Maintenance work area:
-
Offering: Product Management
-
Functional Area: Items
-
Task: Manage Advanced Item Profile Options