Export Supplies and Demands Data

You can export supplies and demands data into a Microsoft Excel spreadsheet. However, what data gets exported depends on how and where you initiate the export process.

• If you export data from the Supplies and Demands pegging mode, your spreadsheet includes child rows tied to each root node that's exported. You can export up to 500 root nodes. The two options to export are:

  • Include All Child Rows: Export all child rows, even if they aren't expanded in the table.

  • Include Child Rows if Expanded: Export the child rows only if you have expanded them in the table.

  The export process exports all rows that match your criteria until it reaches the maximum number of rows allowed.

• If you export data from the Supplies and Demands plain table mode (also called flat file mode), the exported data includes only the records retrieved by your search, but doesn't include pegged data.

  The export process exports all rows that match your criteria until it reaches the maximum allowed.

In both pegging and plain table mode, the export process uses the FND_EXPORT_ROWLIMIT profile option to determine the maximum number of rows to export.

• If a maximum row limit isn't defined in FND_EXPORT_ROWLIMIT, then the default limit is 20,000 rows.
• If the export process reaches the row limit, then the process adds a line at the end of the exported worksheet stating that not all rows were exported.