Update Planning Table Data Scheduled Process

Use the Update Planning Table Data scheduled process to update measure values in Oracle Fusion Cloud Supply Chain Planning.

Note: The Update Planning Table Data scheduled process can be launched only from the Import action on the toolbar of a planning pivot table.

Key Features

  • Export data from a planning pivot table to Microsoft Excel and change any planning measure in the spreadsheet.
  • Import the updated planning measure data back into the table when you've finished making changes offline.

Best Practices

For better performance:

  • Use the DisableAuditFromImportFromExcelUpdate parameter to disable a measure audit if one isn't required.
  • Use the MSC_REST_CALL_UPDATE_MATRIX profile option to skip the matrix table update during the import process.

Constraints

  • Import file must be a Microsoft Excel .xlsx file.
  • You can change only the cell value. You can't delete a row or a column or change the row or column order.
  • The maximum file size is 1 GB.