Export Data to Microsoft Excel

You can export data from various tables within Supply Chain Planning work areas to a Microsoft Excel spreadsheet. You can do this from a plan, from a simulation set, or from plan inputs.

To export data, click the Export icon at the top of a table or select the Export option from the Actions menu.

Some points to consider:

• Only columns that are shown in the table are included in the export. This includes columns that you need to scroll to view.
• The contents of notes aren’t exported.
• If you’ve sorted the table, the export matches the sorted order. For example, if you’ve sorted by date, the export maintains that order in the exported spreadsheet.

• By default, the maximum number of rows that will be exported is 20,000 rows. This is to limit potential memory issues when exporting too much data in a single export. This doesn’t apply to pivot tables; pivot tables don’t use row limits.

  • If the export process reaches the row limit, the process adds a line at the end of the exported worksheet that not all rows were exported.
  • The row limit can be adjusted, up or down, by specifying a value in the FND_EXPORT_ROWLIMIT profile option. If no value is specified for FND_EXPORT_ROWLIMIT, the default limit of 20,000 rows is used.
  • The following tables use the FND_EXPORT_ROWLIMIT option. (Not all Supply Chain Planning work areas use all these tables.)
    • Attribute-Based Transfer Recommendations
    • Build Plan
    • Demand Fulfillment
    • Exceptions
    • Forecast Consumption
    • Item Relationships
    • Item Structures
    • Items
    • Order Comparison
    • Pegging Analysis
    • Resource Requirements
    • Resources
    • Routings
    • Suppliers
    • Supplies and Demands