Export Large Data from Planning Tables

You can export large amounts of data from the planning table layouts in Oracle Fusion Cloud Supply Chain Planning for offline analysis. The data can be exported in either CSV or XLS format.

You can export up to 1 million rows and 4,000 columns, with a maximum of 2 million cells. For example, you can export a table with any of these combinations (all equaling 2 million cells):

• 1 million rows and 2 columns
• 500,000 rows and 4 columns
• 100,000 rows and 20 columns

Export Data in XLS or CSV Format

If you want to view the data before exporting,

1. In the Supply Planning work area, click the Manage Plans task to navigate to the Manage Plans page.
2. Select the plan whose data is to be exported.
3. Click the Action button and select the Open option.
4. In the Plan Summary page, from the Action menu, select the Export Data Format option.

If you want to directly export the data without viewing it,

1. In the Supply Planning work area, click the Manage Plans task to navigate to the Manage Plans page.
2. Select the plan whose data is to be exported.
3. Click the Action button and select the Export Data Format option.

You can also run the Export Data in Table Format scheduled process to export data. For more information, refer to the Export Data in Table Format topic in the Scheduled Processes for SCM guide.

More Points About Exporting Data in XLS or CSV Format

Microsoft XLS format has a limit of 256 columns and 65,536 rows per sheet.

Here’s how the export will be completed in XLS format when the data is more than 65,536 rows (but less than 1 million rows).

1. Output is split into multiple sheets within the same Excel workbook, with each sheet containing 65,536 rows or fewer.
2. The resulting XLS file includes a macro that will automatically run when the file is first opened.
3. This macro merges the sheets into one and converts the file from XLS to XLSX format.
   Note: Microsoft XLXS format has a limit of 1 million rows.