One of your ideas has been delivered from your suggestion.Export Data in Format Specified in a Planning Table

The planning table layouts in Oracle Fusion Cloud Supply Chain Planning enable you to flexibly slice and dice data per your business requirements. Sometimes your configuration of a table can result in data that exceeds the limit set for the amount of data that you can view on the page. Previously, you could export data only when it was within the limits for online viewing. With this update, you can export data even if it exceeds the limits set for online analysis, which enables you to do offline analysis with large volumes of data.

You can now export a table without opening it, so you can now export data even if it exceeds the limits set for online analysis. The exported data retains the table layout, including the positioning of dimension levels and measures in rows and columns, column and row headings, and summaries.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

You can export data in table format from:

  • The Actions button for the currently open plan
  • The Actions menu on the Manage Plans page for the currently selected plan
  • The Scheduled Processes work area by running the Export Data in Table Format process and selecting the plan and table name

The format of the export file is 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.

Member filters and measure filters configured for the table will be respected.

The export file will be:

  • An XLS file that can be opened in Microsoft Excel
  • Limited to 65,536 rows and 256 columns
  • Zipped and posted in File Import and Export
  • Named <Plan Name>_<Table Name>_<Process ID>

Conditional formatting won't be reflected in the export file.

Import of exported file isn't supported.

Access Requirements

There are no new roles or security privileges needed to access this enhancement.

  • Users who currently have access to open planning tables will automatically be able to use this feature.

Users who are assigned a configured job role that contains one or both of these privileges can access this feature:

  • Maintain Planning Tables (MSC_MAINTAIN_PLANNING_TABLES_PRIV)
  • View Planning Tables (MSC_VIEW_PLANNING_TABLES_PRIV)

These privileges were available prior to this update.