1. Integration Playbooks for SCM
  2. Export Data in Table Format

Export Data in Table Format

Use the Export Data in Table Format action to export measure data from a planning table.

Use the exported file to integrate data from Oracle Fusion Cloud Supply Chain Planning application to other Oracle or external applications.

There are three ways to perform the Publish Data action:

  • Select a plan on the Manage Plans page, then select the Export Data in Table Format action from the Actions drop-down list for the plan you selected.
  • Open a plan to view it on the Plan Summary page. Select the Export Data in Table Format action from the Actions drop-down list for the open plan.
  • Run the Export Data in Table Format scheduled process from the Scheduled Processes work area. For more information, see Export Data in Table Format.

Key Features

  • Exports measure data from a plan based on a selected table.
  • You can use the export process even if you can't open the table because of limits on the volume of data that can be displayed on the page.
  • Export file will be formatted based on the layout of the selected table including:
    • The positioning of dimension levels and measures in rows and columns.
    • Column and row headings.
    • Summaries.
  • Levels on the filter bar will be converted to columns.
  • All hierarchies will be fully expanded.
  • Generates either a Microsoft Excel or comma-separated values (CSV) file that you can access can be access with the File Import and Export tool.

Best Practices

Use the Export Data in Table Format action when you want to export data in either a Microsoft Excel or CSV file format using a table configuration as a reference. This will convert all filter levels to columns and retain the exact table layout positioning of levels and measures in rows and columns.

Constraints

  • Output file is limited to 1 million rows, 4,000 columns, and 10 million cells.
  • When exporting in Excel format:
    • The number of columns will be limited to 256.
    • If the table selected for export has more than 65,536 rows (but less than 1 million rows), then the output will be split into multiple sheets within the same Excel workbook with each sheet having 65,536 rows or less.
    • The resulting XLS file will include a macro that runs automatically the first time the file is opened. This macro will merge the multiple sheets into a single sheet and convert the file from an XLS format to an XLXS format. Microsoft Excel XLXS format has a limit of 1 million rows.
  • You can't import the exported file using the pivot table's Import from File option.